Login form

[Jessika]

I have created a table as TBLEMPLOYEE with two fields EmpID -Autonmber PK, EmpUserName and Password which I have changed the input mask as password- Two usernames were entered in the table for the password
Username Password
Jessika jessi
Roshan ronny

Now I want the login to accept only these thw usernames, how can i do this? I've read some posts but nothinh seems tpo work

Please advise

 

[speakers_86]

Just use a combo box that pulls usernames from your table.

 

[Jessika]

Yes, but how do I do so that the user can use only the required password and the system rejects the mistyped password ..A number of try also should be allowd to the user. Should it be on a standalone form.. I mean i create the form from the design view. I insert a combo box and do the lookup in the tableemployee where i choose only the user name,..Then i can insertr a textbox where the user must type in the password..but how can the form track the username and password from table employee ..Please advise


Thanks

Jessika

 

[nanscombe]

I did an example of something similar for someone a little while ago.


See if this gives you some ideas.