Here's something I thought might be useful, but I'm not yet sure how.
Continue Reading: Table array hardcoding »
Updated Access VBA code to delete empty records
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 »
Listing all Access tables in your database
July 31, 2009 by · In your Access application, you may have a need to list all of the tables in your database.
For example, you may want to run a query on all of the tables, or want to display the table names in a list box for the end user to select from.
You don't, however, want to go through the trouble of hard coding table names into your procedure. Every time you add, remove or rename a table, you have to remember to update the list of tables. Very inconvenient.
Continue Reading: Listing all Access tables in your database »
Check Access table(s) from Excel using Automation – Updated Code
January 31, 2008 by · Here is the revised and completed code that I posted yesterday. The DAO declarations are moved outside the Sub procedure and the 'Set' statements are outside the function loop. Also, the table & column headers are now passed as arguments to the function, making the code more compact. The speed increase over yesterday's code is significant.
Continue Reading: Check Access table(s) from Excel using Automation – Updated Code »
Check Access table(s) from Excel using Automation
January 30, 2008 by · Finally, with some help from the good folks over in the microsoft.public.access.modulesdaovba newsgroup, I was able to complete my code to search an Access database for some information stored in an Excel worksheet.
Continue Reading: Check Access table(s) from Excel using Automation »
Follow Me