Capturing Windows User Name

[Steve W.]

Is there a way to capture a user's Windows User Name from inside the VB code?
I want to save it to field to show which user made a change to a record.
I'm using Access 2007, sometimes on Window XP; sometimes Vista.

 

[Graham Mandeno]

Hi Steve

See here: http://www.mvps.org/access/api/api0008.htm

 

[Allen_N]

You can do almost anything you want with Windows. However, the difficulty is
highly variable.

I can do it in Delphi, but I haven't tried it in Windows. It's an API call.
(In Delphi it's a "wrapper" for a Windows API function.)

Search "GetUserName" in Help, the fora, or even Google. (I find Google is a
lot better than the Help in Office 2007, which sucks.)

Anyway, somebody out there has the recipe you want, but it may be more
complex than you were hoping.

 

[egerds]

environ("username") for login
http://www.mvps.org/access/api/api0066.htm for actual display name

 

[Douglas J. Steele]

I always cringe when I see people recommending Environ("UserName") to
capture the login id, given how trivial it is to reset its value. Far safer
is to use http://www.mvps.org/access/api/api0008.htm and capture it
correctly.