Create Log In and Password Page

[AmandaBurlingham]

Hi, any help with this would be appreciated as i am not sure what to even search for in help. I have created a log in page which will eventually open on load, it has a drop down field with user names where the user can select their name and then i require individual passwords. Is this possible. I would like various forms completed with an 'updated by' box each time something is changed sO i don't want user() to be the name on computer. Hope some of this makes sense!!!

 

[SimonB1978]

Hi,

Do every user log on their computer with a different login name? If so you could use Environ$("Username") to get the login they used. Then create a table with those logins and their full names to be displayed. The table can also be used to control access to the database (or specific objects).

Thanks,

Simon B.

 

[AmandaBurlingham]

I did think of that but unfortunately people often use other work stations. What i reallly want, and i did try the
Forms![frmLogin]!txtUser etc etc but having no joy, i just need a log in page that opens when the database starts (Done) and then either a box to type in name and password, (like windows) or a drop down list with user names and then pop up box to type password. When someone has logged in i then want any boxes in my forms that says "last Updated..." to be changed everytime something is edited by the person logged in. Does this make any sense? I think it should be easy and maybe i am making it more complicated than need be!! i am such a novice!!

 

[shadow9449]

Please refrain from posting the same question more than once

Thank you

 

[speakers_86]

This is doable. I can post some code for it later. I am not at my computer right now. But here is a good reference. In the combobox, make sure you bring the employeeid as a hidden field. And when the user clicks submit, set the status of that form to hidden, then you may reference the employeeID in your last updated by fields.

 

[AmandaBurlingham]

Thank you Shadow9449, it was not intentional to post the question twice!!!

Thank you Speakers, i will have a look and let you know how i get on!!

 

[AmandaBurlingham]

got the log in and password to work all great thanks!!!!