The site formerly known as Code For Excel and Outlook
In How to get most recent DBEngine object, Access MVP Alex Dybenko shows us some VB.NET code for grabbing the latest version of DAO's DBEngine Object.
It smartly uses a loop to start from the newest version and walks its way down to the lowest version, trying to set an object reference each time. But the VBA version of the same code just hardcodes each version. Why not loop in VBA as well?
Continue Reading: Reference latest version of DBEngine »
Here are four quick tips I use to keep my database file size down and my queries running quickly. These have been gleaned from various articles I've read over the last few years. You'll want to follow these in order to ensure each step benefits from the one before it. If you have any more, add them in the comments section.
Continue Reading: 4 Tips to Keep your Access Database in Tip Top Shape »
Using the code I found in the newsgroups, I also had a need to remove all Nulls from every table in my databases.
Continue Reading: Remove Nulls in all Fields in MS Access Database »
In my quest to optimize my Access queries, I wanted to view the underlying SQL for each query. However I have dozens of queries and manually examining each one is a hardship. Here's how I did it with VBA.
Continue Reading: List all MS Access queries in database »
I recently had a need to trim fields in a table in one of the databases I use. Borrowing code from a newsgroup post, I was able to come up with VBA code to trim all the text fields in all the tables in a database (2003 MDB).
Continue Reading: Trim all text fields in MS Access database »
Site last updated: February 3, 2012
Follow Me