Question Setting passwords in Access [Please help]

[shirley]

I am creating a library database now and I have a big problem!!!
I created a splashscreen with two 'Enter' command buttons; one is for the students to enter the borrow form, and another one is for the teachers to enter the switchboard. I want to restrict students from entering the teachers' area by setting password if anyone wants to enter to the teachers' area, but I don't know how to do it.

Thankyou for helping!!!!

 

[HiTechCoach]

You can use something like:

If InputBox("Please enter password:") = "MySecretPassword" Then
  DoCmd.OpenForm ...
Else
  MsgBox "Please go away!"
End If

If you want to use the "Password Input" mask (xxxxxx), then use a Dialog Form instead of the InputBox.

Also:
HOWTO: ACC: Create a Password Protected Form or Report

 

[shirley]

Thankyou for answering, it is really helpful!!
I have realised another problem, how can I restrict students to edit/ change the code, because I have only restricted them from entering the switchboard, but they will be able to change the code, details in tables queries, etc.

THANKYOU!!