Last Changed

[Guest]

I was wondering what the best (or easiest) way to track when the last time a
record was changed/updated?

 

[Franck]

I was wondering what the best (or easiest) way to track when the last time a
record was changed/updated?

look for afterupdate trigger

 

[Guest]

Unfortunately Access doesn't support triggers. However there is an After
Update event at form level or even the Dirty property of the form. They could
be used to update a date/time field to Now().

The key here is that it must be a form. If someone is changing data directly
at form level or using update queries, you are out of luck with .mdb files.

 

[Guest]

Thanks that's what I thought. Yes, all the data is updated through a form.
I've got a field in the table called LastUpdated (date formattted). Could you
help me with suggesting what sort of code would I have to put in the After
Update event to get this working.

 

[Guest]

On the form's Dirty event, put the following:

Private Sub Form_Dirty(Cancel As Integer)
Me.LastUpdated = Now()
End Sub

You may need the LastUpdated field on the form; however, it can be hidden.

 

[Rick Brandt]

Thanks that's what I thought. Yes, all the data is updated through a
form. I've got a field in the table called LastUpdated (date
formattted). Could you help me with suggesting what sort of code
would I have to put in the After Update event to get this working.

BeforeUpdate, not AfterUpdate. If you edit a record in AfterUpdate you
trigger another update and get stuck in a loop.

In BeforeUpdate..


Me!LastUpdated = Now()