Hello, i have a database that is Access as front end, sql server as backend. I want to have a field called "EnterBy", when the user login the computer, it can automatically display his name on the "EnterBy". How can I do that? Thanks.
You can create a form during the initial login into the db, that form would eventually become invisible and you could always refer to its username field when you enter the data.
Second option is to use a Windows' current local user information and automatically input it into the form as the user is entering the information. I have both of these in place
since different versions of access and different windows versions might produce different results, you can try iterating through the variables of environ to see if one of them produces ur result (if the above doesn't work)
for i = 1 to 100
the environ array gives a whole list of information bout the computer, network, etc..