Detecting user?

[Ecron]

Hello.

So, I have a logon form with a combo box for user name and a text box for the password. When they hit login, the user is then looked up and the password verified and if it's good they're taken to a specific screen that gives them specific options. What i want to know is how to hold the value of the user throughout their entire session? The reason for this being, to keep track of what data they enter mainly.

Any help would be much appreciated!

Thanks!

 

[ColinEssex]

You can pull the users network name by using

Environ("username")

Col

 

[Ecron]

i'll use that. it seems a bit easier.

thanks!

 

[jkl0]

Or you could put the User into a global variable.
Or put in a hidden textbox on a form that stays open all of the time, and then check the textbox whenever you need to.

 

[The_Doc_Man]

If you are not using Workgroup Security, you might be doing yourself a grave disservice. Using Workgroup Security, the current user is .... get ready for it.... CurrentUser()

If you are not using workgroup security, it is, of course, your call - but you have re-invented a very big wheel if that is the case. Unless, of course, your security comes from a non-Access backend server, in which case your approach is right after all.