How to get logged-in user s name in Access vba

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

User · Answer

Try this   Function UserNameWindows   As String      UserName   Environ  USERNAME   End Function

User · Answer

In a Form  Create a text box  with in text box properties select data tab   Default value  CurrentUser     Current source  select table field name   It will display current user log on name in text box   label as well as saves the user name in the table field

User · Answer

Public Declare Function GetUserName Lib  advapi32 dll       Alias  GetUserNameA   ByVal lpBuffer As String  nSize As Long  As Long         Dim strLen As Long Dim strtmp As String   256 Dim strUserName As String  strLen   255 GetUserName strtmp  strLen strUserName   Trim  TrimNull strtmp     Turns out question has been asked before  How can I get the currently logged-in windows user in Access VBA

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

Examples related to ms-access

Examples related to vba