Category Archives: VBA
Two Functions You Don’t Use Enough
Wayne Wallace shows you how to use two functions (Eval and Format) to do things that you might not have thought of. One of the great things about working in the Access environment is the number of functions that are … Continue reading
The FileSystemObject
Sometimes your data isn’t a database; sometimes you need to get data from a flat file. Or maybe you need information about your users’ files. Chris Weber shows how to solve all of these problems with the FileSystemObject. Have you … Continue reading
SubQueries to the Rescue
One of SQL’s more useful features is its subqueries. Peter Vogel hunts them down for you in this article and shows how to get some enormous performance gains. He even bags the rare and powerful correlated subquery. In an earlier … Continue reading
Stupid Date Tricks
In this article, Doug Steele demonstrates a useful formula to use with date calculations. If I’ve got a date, can I determine the date of the Monday for the week that date is in? For instance, I’ve got a date … Continue reading
Spatial Data, Part 3
In the final article of his three-part series on handling spatial data, David provides an application that makes use of the toolkit built up in our previous two issues. In the previous two articles in this series (see “Accessing Spatial … Continue reading
