how do I track who entered a record in Access

[Guest]

Hi,

I've got a database used by several people, and I need a way to
automatically mark who added and/or changed a record.

Is there a way to do this other than making them enter some kind of ID? I
really need something that will work in the background. It could key from
computer name, network username, anything like that. Just some way to tell
who made or changed the entry last.

It's mostly one form that I need to track. I don't need it on everything. I
thought I'd read somewhere a way to code for something like this.

Thanks!

 

[Allen Browne]

You can get the user's login name using this code:
http://www.mvps.org/access/api/api0008.htm
or the computer name with this code:
http://www.mvps.org/access/api/api0009.htm

Assign it to the desired field in the BeforeUpdate event procedure of your
form.