The site formerly known as Code For Excel and Outlook
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 »
February 4, 2008 by · Back in January, I promised to post a macro that imports data from Excel into Access programmatically.
Continue Reading: Import data to Access from Excel »
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 »
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 »
Site last updated: February 8, 2012
Follow Me