In Trim all text fields in MS Access database I posted a method for removing excess spaces from a field in Access. This is a guest post from Dave Braunschweig showing how to do the same using ADODB.
Continue Reading »
Access
This category includes Microsoft Access code samples for VBA. Queries, forms and reports may also be covered.
Updated code to trim all text fields in a MS Access database
This is a guest post from Eric @ http://ventre-a-pattes.net/.
I loved your TrimAllTextFieldsAllTables [Editors note: See original post], but it fails if some tables have no text fields. Attached is a slightly modified version that fixes the issue.
Thanks again.
Continue Reading »
Reference latest version of DBEngine
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 »
4 Tips to Keep your Access Database in Tip Top Shape
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.
Follow Me