Posts tagged with 'SQL', page 1 of 1

SQL

Updated code to trim all text fields in a MS Access database

December 11, 2012 by JP

Comments

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 »

Filed Under: Access, VBA

Tagged With: SQL, trim

List all MS Access queries in database

July 22, 2011 by JP

Comments

In my quest to optimize my Access queries, I wanted to view the underlying SQL for each query. However I have dozens of queries and manually examining each one is a hardship. Here's how I did it with VBA.

Filed Under: Access

Tagged With: loop, query, SQL

Updated Access VBA code to delete empty records

January 13, 2010 by JP

Comments

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!

Filed Under: Access

Tagged With: Access, database, delete, field, GetCurrentDB, record, Row, SQL, table, VBA