Get last updated date/time ?

[Guest]

Hi,

I have an Access database which is used by my team.
Members of the team take home this database and work on it -
inserting/updating data.

Is it possible to have a splash screen in Access which displays the last
date/time a record was inserted or updated in the Access database?

Thanks
Steve.

 

[Douglas J. Steele]

The only way you can keep track of when a record was updated is if you're
updating through a form, in which case you write VBA code in the
BeforeUpdate event to populate the date field. If you've got that, then you
can create a form that reads the table, looking for the highest date value
and displays it, and have that form as your startup form.