Capture UserName with UserID?

[WinDancer]

I found and used a thread here to capture the UserID that works perfectly.

Is there a way to capture the user's name?

Thanks,
Dave

 

[ghudson]

The Environ function is the way to go. For a quick test try these...

MsgBox Environ("UserDomain")
MsgBox Environ("UserName")
MsgBox Environ("ComputerName")

Check out this thread for a function that will list all Environ variables your computers operating system will provide... Get Current User Name and Computer Name

 

[WinDancer]

I already have all those, and they work fine.

My UserID is EVAE235. That works fine.

My Name is Dave Evans. This is what I am after.

Is there a way to pick this up like the other info?

Thanks again,
Dave

 

[ghudson]

You can grab the users full name [First Last] using the API at Dev's site. It works as posted. For a quick test just add this function to the module.

Function TestGetFullNameOfLoggedUser()
    MsgBox fGetFullNameOfLoggedUser
    'MsgBox fGetFullNameOfLoggedUser(Environ("UserName")) 'either should work
End Function

Here is the link to the API... API: Get full name of the user currently logged in to the system

Just copy the entire page of code into a new module and add the function I listed above to test it.

 

[mohsinhq]

does this work with access 97?

just tried it and gives a blank message box?

 

[ghudson]

The answer was near the top of the code @
API: Get full name of the user currently logged in to the system

Please note that this function is only available under Windows NT/Windows 2000.

Windows XP is based off of Windows NT so it does work with Windows XP.