tracking changes

  • Thread starter George Applegate
  • Start date
G

George Applegate

I have a payroll record data base - records the employee, date, time,
in or out of when they punch in.

I am going to have to allow some users the ability to delete, add or
even change records.

Is there an easy model to follow of how I can somehow track when
changes are made and what those are?

For instance, can I somehow write copies of any records that are
changed to another table? Can I write copies of any record added to
another table or copy any record deleted to another table? If a
record is changed, it'd be nice to have a "before" and "after" view.

I am sure someone has run across this issue before and am wondering
how it might best be resolved.

thanks for any suggestions.
ga

George Applegate
(e-mail address removed)
 
G

Golfinray

Recording the date and time is fairly easy. Add a Last Updated field to the
table and then add to your form. Go into the lastupdated text box on the
form, look at events, and in the beforeupdate event type
Me.last_updated=now()
For who updated, that is more complicated. See www.allenbrowne.com for a
solution.
 

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

Dynamic Naming of Form Button 3
sqlite-odbc write conflict 2
saved exports in 2007 2
problem opening access table 4
default fields 2
Unclear change tracking process 0
question on dlookup 3
runtime access 2007 1

Top