Get user login name 8

[Darrylles]

Hi all,

I've seen this solution in Tek-Tips, but I just cannot find it via 'search', I've saved the solution somewhere but can't find that either - lol.

What do I need to get the Windows user login name from within MS Access (via VB)?

This is for Win 2k and 98, but either will be appreciated (one will lead to the other).

Kind regards,

Darrylle





"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[RITec]

hdgirl,

What operating system are you using? and what version of access?

Ritec

 

[psemianonymous]

This statement is false:

The problem with using global variables is, well, they're global. I.E., the variable will be loaded with the name of the latest user of the database.

Global variables stored in a code module, e.g.
Public String g_strUserName
are loaded per instance of Access and are totally independent. You are confusing global variables, stored in VBA code modules (or main memory, if we get technical) with globals stored on database tables.

Globals stored in a code module start up with a zero-equivalent value. For Strings, it is the empty string, vbNullString, so it's somewhat easy to test whether the global has been properly set before or not.

 

[BobJacksonNCI]

foolio12,

Thanks for your clarification... (Note pinking of face)

And, thanks for participating in Tek-Tips.

Bob