How to get logged-in user's name in Access vba? [duplicate]

Question

Possible Duplicate:
Is there a way for MS Access to grab the current Active Directory user?

I want to get the name of the logged-in User via vba in access. What is the best way to do this?

---

Duplicates of this question:

• Is there a way for MS Access to grab the current Active Directory user?
• Using VB6, how do I get the current user and domain on Windows XP?
• How can I get the currently logged-in windows user in Access VBA?
• Excel 2007 VBA and WMI - Current DOMAIN\USER

Answer 1

Try this:

Function UserNameWindows() As String      UserName = Environ("USERNAME") End Function