User identification

[Nick]

I have a database on an internal network and I want to
show user identity whenever a record is changed. Is there
any way to do this?

Cheers

Nick

 

[Tony C]

Last week, I posted a reply to a similar problem.. Search
the Workgroups for "DetermineNetworkSettings". Hopefully
my piece on that issue will be able to assist you.

Tony C.

 

[Cheryl Fischer]

Nick,

If you have implemented Access' built-in security, you can use CurrentUser
to get the user name; otherwise, use the code that is available at the
Access Web: http://www.mvps.org/access/api/api0008.htm

Then, you can use code like the following in your Form's BeforeUpdate event
to record the user name in a control on your form which should be bound to a
field in the form's recordsource:

' If using built-in security:
Me!UpdatedBy = CurrentUser

' Without built-in security:
Me!UpdatedBy = fOSUserName


hth,

 

[Nick]

I have searched all the workgroups but can't find your
work. Would you be able to post it for me.

Cheers
Nick

 

[Immanuel Sibero]

Hi Nick,

Did you see Cheryl's response? Doesnt get any better than that.

Immanuel Sibero

 

[Cheryl Fischer]

Thanks, Immanuel!