who modified this record?

[Guest]

I'm developing a database that will have several field users inputting data that feeds into several tables of my database. I plan to give each of these users a unique ID log-in, and would like to find a way to track which records they have modified (and when). I've got the and-when answered from reading other posts in this newsgroup, but would someone please let me know how to add the "who modified me last" field into my tables, and have it get the information from the log-in

If I can figure get this going, I might be able to salvage what is left of the weekend! Yikes!

Gina

 

[Douglas J. Steele]

Just add a field to your table, then in the form's Before_Update event, set
the value for that field.

If you've applied Access Security, so that your users have to log into your
application, you can use CurrentUser() to get their ID.

If you want their Network ID, see the code in
http://www.mvps.org/access/api/api0008.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I'm developing a database that will have several field users inputting

data that feeds into several tables of my database. I plan to give each of
these users a unique ID log-in, and would like to find a way to track which
records they have modified (and when). I've got the and-when answered from
reading other posts in this newsgroup, but would someone please let me know
how to add the "who modified me last" field into my tables, and have it get
the information from the log-in?

 

[tina]

hi Doug. a tangental question: in a completely unsecured database, should
CurrentUser() always return Admin?
thx, tina

 

[Douglas J. Steele]

Yes.