The site formerly known as Code For Excel and Outlook
August 16, 2011 by · 
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 »
July 20, 2011 by · 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 »
January 20, 2010 by · In Checking Access properties using VBA, I posted code for Access that checks if a given database property exists. I also included code samples for adding and setting built-in properties.
But how do you check the built-in properties names to see what properties you can edit?
Continue Reading: Listing built-in Access database properties »
January 13, 2010 by · I recently had to use the code I posted in Clean and Repair Your Access Database to delete blank records from a database. But it failed because one of the tables has spaces in the name. I didn't create the table, I swear!
Continue Reading: Updated Access VBA code to delete empty records »
Site last updated: February 9, 2012
Follow Me