Get Actual Windows Username

[RedWing]

Hi there,

I'm trying to get the windows user name shown on the start menu via VBA which is proving to be troublesome. Pretty much every function I've found on the net finds the username which the account was created with, which doesn't change if the user changes the name for that account via the User Accounts console, all of these functions report that name and not the one on the start menu.

Looked at all the potential solutions given here: http://bytes.com/topic/access/answer...ogged-username, http://www.vbforums.com/showthread.p...ndows-Username, http://www.vbaexpress.com/kb/getarticle.php?kb_id=768.

Some of these range from simply using Environ to very complex API functions, but they never return what I need!

Can anyone help me out? Thanks.

[JBeaucaire]

This command gives me the name I see on my Start Menu:

Please Login or Register  to view this content.

This one gives me the name of my computer:

Please Login or Register  to view this content.

[RedWing]

Hi there,

Thanks for your reply. Does Environ still give you the name on the start menu if you change that name via the User Accounts Console? Environ will work for me until I change the name, after that it always returns what it first was.