Access Date/Time

[Joe Sutphin]

Is there any way to know the date/time a record was added to a table? Does
Access have some sort of hidden value a user can query to ascertain the
information? TIA.

 

[Jeff Boyce]

Joe

Open the table in design mode. Add a DateCreated (date/time) field. Set
the Default property of that new field to:

=Now()

Everytime a new row is added, the DateCreated will be populated.

 

[Joe Sutphin]

That's a good tip, but what about records that already exist? I need to know
when they were added.

Joe

 

[John Vinson]

That's a good tip, but what about records that already exist? I need to know
when they were added.

If you weren't recording it at the time the record was created, there
is literally no way on Earth to know. That information is not recorded
anywhere in Access.

 

[Guest]

What is the best way you update this field when a record is changed?

 

[Douglas J. Steele]

The only way is to use a form to update the table, and set the field's value
in the Before_Update event.