System User ID

• lindss01

  SSCrazy

  Points: 2264

  More actions

  September 30, 2005 at 6:59 am

  #166284

  In Visual Basic for Applications in Access how can one obtain the name of the user who is logged on to Windows?  I am not using Access security but I would like to pick up the user id of the person logged on to the PC.

   

  Thanks

  Steve

• Cory Perkins

  SSChasing Mays

  Points: 638

  More actions

  September 30, 2005 at 10:07 am

  #594366

  I think you have to use a windows API function to get the username. Here is the API declaration and a little function to return the windows username.

  Declare Function GetUserNameA Lib "advapi32.dll" (ByVal lpBuffer As String, nSize As Long) As Long

  Public Function GetUserName() As String

  Dim UserName As String * 255

  GetUserNameA UserName, 255

  GetUserName = Left$(UserName, InStr(UserName, Chr$(0)) - 1)

  End Function

  Hope this helps.

• Jeroen van Kessel

  Grasshopper

  Points: 18

  More actions

  October 3, 2005 at 3:48 pm

  #594695

  environ("USERNAME")