Track Changes

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

Hello:

I have a shared database running on a network drive. I
would like to track when record changes occur and who did
it.

Problem 1: I'm not able to tack changes, when they occur
in subforms. (I have a main form with 3 subforms)

Problem 2: for CurrentUser I'm currently getting "admin",
since I don't have any security levels set up, however
everybody in our system has to look on each machine here,
is it possible to read the general user NetID and put it
in my filed CurrentUser?

I would really appreciate any help.

Nicole

BeforeUpdate Event:
Me![Last Change] = CurrentUser() & " " & Now()
 
On my website (see sig below) are two small sample databases:
"AuditTrail.mdb" and "AuditTrail2.mdb" which illustrate how to do both of
these things.
 
Back
Top