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

Audit Trail

P: n/a
I'm looking for an simple bit of code that I can put on any field in a
form to record any changes. Not only do I need to know who changed the
field, but also what the original value was.

Is that possible?
Any examples available?

Thanks in advance.

Laura

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Access does not provide this for you, but if all changes are made through
forms, you can use the events of the form to record edits, deletions and
inserts.

Details in:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

--
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.

"musicloverlch" <lh****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I'm looking for an simple bit of code that I can put on any field in a
form to record any changes. Not only do I need to know who changed the
field, but also what the original value was.

Is that possible?
Any examples available?

Nov 13 '05 #2

P: n/a
This worked great on the main form. Should it work on subforms, too?
I couldn't get it to work, and I don't want to make myself frustrated
trying to, if i isn't supposed to.

Thanks for all your help!
Laura

Nov 13 '05 #3

P: n/a
Yes. Works on subforms.

--
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.

"musicloverlch" <lh****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
This worked great on the main form. Should it work on subforms, too?
I couldn't get it to work, and I don't want to make myself frustrated
trying to, if i isn't supposed to.

Nov 13 '05 #4

P: n/a
Did you know that you are fabulous? THANKS! :-)

Nov 13 '05 #5

P: n/a
"musicloverlch" wrote
Did you know that you are fabulous? THANKS! :-)


Don't tell him _that_... he will feel all important and expect us to buy him
drinks at the MVP Summit. <GRIN>

Actually we all think Allen is, at the very least, fabulous and are going to
buy him drinks, anyway!

Larry
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.