Tracking changes

L

Luther

Hi,

Here is the situation:

1. 6 fields that are 2 digits each
2. 1 check box field named "changed"

What I would like to do is track how many times someone changes data in any
of the 6 fields; right now, they would just check the "changed" box (don't
want to trust that). I would like to do something that would give me a count
of these changes.

This way, I can report the percentage of changes within this database.

Any help on this would be appreciated.

Thanks.
 
A

Allen Browne

Access does not provide you with logging, but if all changes are made
through a form, you can use the events of the form to track inserts,
changes, and deletions of your records.

If you are comfortable with VBA code, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html
 
L

Luther

Thank you very much for your input. I will try this solution and report
back....
 
Top