What is the best way to record the fields changed, user, and time.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the best way to record the fields changed, user, and time for each
field that is modified. Is there a way to do it without creating a query &
macro for each field?
 
Hi Renae.

Big question. You need to do that in the AfterUpdate event of the form, when
you know that the changes have been made. But at that stage, the OldValue of
the controls is no longer available, so you need to record those in the
BeforeUpdate event of the form, so you can compare them.

There's an example of how to record inserts, edits, and deletions in:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending records to new table using field names as values 2
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
Differents totals for each year of birth within a Field. 3
Best way to enter records containing repeating information? 1
Best Tool to Repair Corrupted PDF Files 0
Check length for each record for a delimited file 4
Access 2007 Time format - Sports Lap timing and calculating 4
hyperlink field to send email 6

Back
Top