title: How can I check for null values in Access?
body: <p>I am new to Access. I have a table full of records. I want to write a function to check if  any id is null or empty. If so, I want to update it with xxxxx.
  The check for id must be run through all tables in  a database.
  Can anyone provide some sample code?</p>