By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

Record Last Updated

P: n/a
I have an access database and I often need to check when a record was last
changed by a user. Is there a simple way to achieve this

Nick H
May 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Access does not record this data, but you can do it if all updates are done
through forms.

Add a date/time field named (say) UpdatedOn to your table.

In the BeforeUpdate event procedure of the form:
Me.UpdatedOn = Now()

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nicholas Howells" <N G Ho*****@ntlworld.com> wrote in message
news:t8***************@newsfe3-gui.ntli.net...
I have an access database and I often need to check when a record was last
changed by a user. Is there a simple way to achieve this

May 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.