Time Stamp/Time Tag

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working with a program that is looking for an element that is updated
each time a change is made to a record. They refer to it as time tagging.
How do I identify/create a field in my tables in Access 2000 that will
accomplish this?

Thanks for your help!
C. Brennan
 
Assuming you're using a form for all of your updates, put logic to update a
LastUpdatedDTM field in your record in the form's BeforeUpdate event.

If you're using queries for updates, you can specify Now() as one of the
fields to update the LastUpdatedDTM field.

It's not possible to do if you're updating the tables directly.
 
Back
Top