Date/Time Show When Changes Made

G

Guest

Hi,

When changes are made in a table or form, I want the date and time to appear
showing me when changes were made in any of the fields.

How can it work?
MTIA.
 
D

Douglas J. Steele

It's not possible if you're working directly with tables.

Using foms, you have to put code into the form's BeforeUpdate event to
update the row's LastChanged field (which, of course, you have to add to the
table yourself)

You might find what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html to be useful.
 

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

Last date of update saved on UpdatedOn when Save Button is click 5
Reports showing more than needed 4
Can't change data type to date in access table 3
Who's in and who made changes 13
Date Stamp Only When *Field* Changes, not Whenever *Record* Change 4
Error Message 1
Split Database and Form Update issue 8
Test form for changes on close 6

Top