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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment