Tracking Updates to Tables

[Karrie]

Is there a way to have a field in a table automatically
update with a date/time stamp when someone modifies the
record?

I know there is a way to do this if you are using a form
to access your data, but due to many circumstances (time)
we have some databases where we work in the tables.

Thanks!

Karrie

 

[Jeff Boyce]

Karrie

In Access tables, no. (the short answer)

Also, tables give you no events and little control. Forms and form controls
give you a host of events and significant control over what/how data is
entered/updated. Consider forcing the use of a form, rather than allowing
table data entry.

If the backend is in SQL-Server or other heavy-duty db, look into
"triggers".

Good luck

Jeff Boyce
<Access MVP>

 

[Vanmechelen Hans]

What you could do, however, is make a datasheet view form and add two table
fields:
_DateAdded: set in table default value = Date() (format showing date + time)
_DateChanged: add in the form's afterUpdate event: Me!_DateChange = Date()
this is very minimal, but might already provide what you need. If you want, I
think you can delete the controls referencing to these fields from the form as
well, to avoid any confusion for the users.

Hans, Belgium

Jeff Boyce schreef: