Form Password

[Gus Torres]

I want to open an "Enter Password" window for numerous individuals where
each of them will enter their own password before they open the Form. Can
someone help me with some advice. Thanks

 

[Steve Schapel]

Gus,

Is it possible to make a table where you list all the valid passwords
for the authorised individuals? If so, you could use code similar to
this on the password form...
If DCount("*","Passwords","[Password]='" & Me.txtPassword & "'") = 0 Then
MsgBox "Invalid password"
Else
DoCmd.Close acForm Me.Name
DoCmd.OpenForm "TheForm"
End If

 

[Gus Torres]

Steve, Yes I could make a table with all of the names and assigned
passwords. I will try to use the information provided. Thanks for all the
help.
Gus

Gus,

Is it possible to make a table where you list all the valid passwords
for the authorised individuals? If so, you could use code similar to
this on the password form...
If DCount("*","Passwords","[Password]='" & Me.txtPassword & "'") = 0
Then
MsgBox "Invalid password"
Else
DoCmd.Close acForm Me.Name
DoCmd.OpenForm "TheForm"
End If