Date of Change

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stig - 20 Jan 2005 21:16 GMT

Hi
Can I add a field to a table that shows when the record was last modified?
Thanks once again for all the help kind people have been giving on these
newsgroups.
Dave

Reply to this Message

Douglas J. Steele - 20 Jan 2005 21:32 GMT

Not unless you're using a form to update your data. If you are, put logic in
the form's BeforeUpdate event to set the LastModified date to Now.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi
> Can I add a field to a table that shows when the record was last modified?
> Thanks once again for all the help kind people have been giving on these
> newsgroups.
> Dave

Reply to this Message

Rick Brandt - 20 Jan 2005 21:36 GMT

> Hi
> Can I add a field to a table that shows when the record was last
> modified? Thanks once again for all the help kind people have been
> giving on these newsgroups.
> Dave

Add the field [RevisedOn] (for example) to the table and then in the form
used for editing use the BeforeUpdate event...

Me.RevisedOn = Now()

ALL edits must be done with a form that uses this code. You cannot enforce
this when editing the table directly.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Stig - 21 Jan 2005 06:52 GMT

Thanks for the help

> Hi
> Can I add a field to a table that shows when the record was last modified?
> Thanks once again for all the help kind people have been giving on these
> newsgroups.
> Dave

Reply to this Message