Audit

[Mary M]

We currently have a field in a form that is updated each time a user enters
the form. The field has Me!FIELDNAME = Date. in the before update event.

I would like to do the same thing, but to another table. I was hoping to
create a table that had Date, Name of person logged in, and the primary key
field and have the table updated each time someone accesses a record.

I have a couple of questions:

1. How can I get the network user name of the person into the table?

2. How can I copy the current primary key to the new table and same record
as the name and date?

What would the code be to do this and in which event should it happen?

Basically, I'm looking to create a table that shows who was in the db, when
and what they did.

Any help would be greatly appreciated.

Many thanks in advance.

 

[Douglas J. Steele]

To get the user's network name, see
http://www.mvps.org/access/api/api0008.htm

I'm not quite sure I follow question 2. However, see whether what Allen
Browne has at http://www.allenbrowne.com/AppAudit.html is what you need.