Hi all,

I have included the fields DateAdded and DateChanged in every table.
When a new record is added the field DateAdded is updated with the value now().
When a record is changed the field DateChaned is updated.
Apart from this I have a tabel AuditTrail. When a record changes the old and new values are stored here.

When I am working on 1 of my forms all these actions are covered using VBA. This works fine.

My question: (more than) sometimes I change records with (ad hoc) queries which are not stored.
Does anybody know, or have experience, to capture the above mentioned actions (update the audit trail and update the field DateChanged) without having to make or save 1 or more queries?

Thanks in advance
Hein

Hein

If you are using Access 2010, there are "data macros" you can use when values are changed in tables. These are similar to "triggers" in SQL-Server.

Before Access 2010, not so much!

Alas,

I am using Access 2002.
Thanks for your input Jeff!

Hein

If you use Audit Trail Table, you must use Forms to add/edit data since the Form Events are required to add audit records into the Audit Trail Table!