Check records' last edit time

Crilen007

Uhm, Title... *shrug*
Local time
Today, 11:00
Joined
Jun 13, 2003
Messages
531
There a way to see when a record was edited last?
 
AFAIK - only if you've stored the date/time in a field with the record.

FWIW - I have fields called modDate and modUser in the tables for which I wish to track this sort of information. Then, in the BeforeUpdate event of the appropriate forms, I set these fields to Now() and CurrentUser() (respectively). (Of course, the CurrentUser bit is only useful if you've implemented Access Security and have multiple user names!)

One caveat: This information is only stored when edits are made in a form (with the appropriate code attached); edits made directly in the table will not be so tracked.
 
I was afraid of that. Thanks =)
 

Users who are viewing this thread

Back
Top Bottom