Posts tagged with 'field', page 1 of 1

field

Remove Nulls in all Fields in MS Access Database

July 25, 2011 by JP

8 Comment(s)

Using the code I found in the newsgroups, I also had a need to remove all Nulls from every table in my databases.

Filed Under: Access

Tagged With: field, Null, TableDef

Trim all text fields in MS Access database

July 20, 2011 by JP

1 Comment(s)

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).

Filed Under: Access

Tagged With: database, field, trim

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