Changes/Updates Question

[Guest]

Hi all,

I am wondering if I create usernames and passwords, if there is a way to
display in the database who has added or changed information?

If I have a database of contacts, for example, and multiple users -- if one
user enters a new contact is there a way to display who entered this contact
on the form?

 

[Douglas J. Steele]

Add a LastUpdatedBy field to your table, and put code in the form's
BeforeUpdate event to set the value of that field to CurrentUser.

In actual fact, it's not really necessary to create usernames and passwords
if that's all you're trying to do. Take a look at
http://www.mvps.org/access/api/api0008.htm at "The Access Web" for how to
determine the user's Windows Login ID.

 

[Guest]

Thanks so much, Doug!!

Add a LastUpdatedBy field to your table, and put code in the form's
BeforeUpdate event to set the value of that field to CurrentUser.

In actual fact, it's not really necessary to create usernames and passwords
if that's all you're trying to do. Take a look at
http://www.mvps.org/access/api/api0008.htm at "The Access Web" for how to
determine the user's Windows Login ID.