Problem with Dlookup on my project

[dylgue]

Hello,

I try to resolve the problem myself, but I don't.

I found a code on the web to know which person use an access application, and I try to modify a part for my utilisation.

' Nouvel utilisateur
        Set loUser = New clLDBUser
        loUser.ComputerName = TrimNull(StrConv(lBuffer1, vbUnicode))
            ' Test l'utilisateur en fonction du ComputerName
        loUser.UserName = DLookup("[Utilisateur]", "Users", "[Poste]=" & loUser.ComputerName)
        loUser.NumConnection = lNbUser

When I run the application, the field "UserName" is complete by "Admin" for every users but I want to know the name of the person who use the PC.

So I make a table "Users" with 2 row : '[Poste]' and '[Utilisateur]'. With this table, I can found who match with the good Computer.

But I don't understand how I can use the variable loUser.ComputerName on my Dlookup function.



When I try to compare '[Poste]=' with a String, I found the name, but with the variable it's notificate me "error '91' " or " The value xxx create an error" where xxx = the loUser.ComputerName


If someone could help me ?

Thank you by advance.

[isladogs]

Use these: Environ("UserName") and Environ("ComputerName")

You can store both items in a table when users start your application .... together with login date/time if you want

[ranman256]

or on a form. Then i use the form values for queries.

[isladogs]

The reason I mentioned a table is so you can have a user login history.
If you don't need that just use a form as ranman suggested.

[dylgue]

Thank you all ! It works