Can I get user from windows ?

Does anyone know ? Can I get the logged in user name from windows/windows NT , or smtg in VB ? directly with code (for use in MS Access forms / VB) ?

Code:

---

Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
Private Sub Form_Load()
    Dim strUserName As String
    strUserName = String(100, Chr$(0))
    GetUserName strUserName, 100
    strUserName = Left$(strUserName, InStr(strUserName, Chr$(0)) - 1)

    MsgBox "Hello " + strUserName
End Sub

---

There is an API function (see Platform SDK)

The function is:

GetUserName

Also there is an example provided.

I am not sure about MS Access but using VB but you shoud have no problems using it from VB.

the fonction environ give lot of thing

by example:

for i=0 to 30
msgbox environ(i)
next i

what your asking: environ("username")

Hope this help.

Fardoche:cool:

Let's keep it simple. In this little routine you can return the Username, Operating System, Path and the Computer Name.

==========================================================

Private Sub cmdGetInfo_Click()

Dim strPath As String
Dim strUserName As String
Dim strCompName As String
Dim strOpSystem As String

lblPath.WordWrap = True

strPath = Environ("Path")
strUserName = Environ("UserName")
strCompName = Environ("ComputerName")
strOpSystem = Environ("OS")

lblPath = strPath
lblUserName = strUserName & " ---- " & strCompName
lblOpSystem = strOpSystem
End Sub

==========================================================

NetWiz

type SET at a command line, and you will see all the things you can ask environ for..