Login and password

[Barb]

How do I go about creating a form with Name and Password.
Then IF password is corect(I have them listed in the
little table)button at the bottom of the form would
activate.
I'm trying to filter results by name of the employee, but
I need to insert a password.

Please help
Barb

 

[Chris]

First thing I'd recommend is taking a look at security.
If this data is sensitive, then I wouldn't recommend this
method.


Otherwise,

Table: tblPassword
UserName: Text(50)
Password: Text(50)


On your form, have the button Enabled property set to
false.

Assuming you have a button to login, and txtName,
txtPassword controls:

Private Sub cmdLogin_Click()
If DCount("UserName","tblPassword","UserName = '" &
txtName & "' AND Password = '" & txtPassword & "'") > 0
Then

cmdEmployee.Enabled = True

Else

cmdEmployee.Enabled = False

End If




Chris

 

[barb]

Thanks Chris

Data is not really sensitive, what you gave me was
exactly what I needed.

Thank you
Barb