W
Wes Derhak
Hi
I need help with a custom login screen. The following tables and fields are
what I have to work with as I'm new to MS Access;
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
I need help with a custom login screen. The following tables and fields are
what I have to work with as I'm new to MS Access;
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