User identification

  • Thread starter Thread starter Nick
  • Start date Start date
N

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
 
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.
 
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,
 
I have searched all the workgroups but can't find your
work. Would you be able to post it for me.

Cheers
Nick
 
Hi Nick,

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

Immanuel Sibero
 
Back
Top