Tracking changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luther - 04 Nov 2005 16:08 GMT

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.

Reply to this Message

Allen Browne - 04 Nov 2005 17:00 GMT

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

Signature

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.

> Here is the situation:
>
[quoted text clipped - 13 lines]
>
> Thanks.

Reply to this Message

Luther - 04 Nov 2005 18:04 GMT

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

> 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,
[quoted text clipped - 22 lines]
> >
> > Thanks.

Reply to this Message