need help with a login form

[Wes Derhak]

Hi

I need help with a custom login screen. The following tables and fields are
what I have to work with;

Table Field

Staff Info SN (Staff Number) (Primary Key)
Name
Int
First

Account Info SN
UserID
Password


I have created four forms "Login", "Add Staff", "Wardroom" and "Account
Info". The Add Staff & Account Info are for inputting new staff only. What I
need to do is have the "Login" command button verify the userid and password
from the "Account Info" and if successful it will then open a form called
Wardroom and to that staff's record

The Wardroom form has several subforms which allows them to input
information only into their records

Any help is appreciate!
Wes

 

[Guest]

Check this link on "How to create a User Login Form in Microsoft Access"

http://www.databasedev.co.uk/login.html