to have the user name who enter the data within the form

[mana]

Hello,

i have form that i attached to you,
i want to have in (text box where mona is written) to have the name of the user name who enters data in this form
but i don't know how to do it?
the user is in another table as users
i also attached the data from this text box.
can you help me pelase
thanks

 

[BlueIshDan]

I came up with this, but I'm not sure if there are other more effective ways of retrieving it.

Public Function GetUserName() As String
    GetUserName = Nz(Environ("USERNAME"), vbNullString)
End Function

 

[mana]

but this is the web access database
are you sure about it?

 

[MSAccessRookie]

but this is the web access database
are you sure about it?

BlueIshDan's idea works in a Company Network situation, and does not apply to normal web based systems. Your idea will work, but leaves open the possibility that a user could select an incorrect name.

I assume that your system (as with any good web based system) verifies the identity of the user via some sort of login screen before it allows the user to continue to any other parts of the system, and that process could record and save the approved identity for use by the other parts of the system. in this way, a combo box picker would not be needed.

-- Rookie

 

[BlueIshDan]

Oh sorry, I don't even know what web based access is hahahaha!

 

[mana]

But I don't know where to write this?
Because I saw there is a client function
Does it work with web as well?