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 »
Trim all text fields in MS Access database
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 »
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 »
Follow Me