VBA login code for access

[adrenalynn06]

dose anyone know how i can create login form were the user can enter login name and password??

any idea on vba code??

 

[Ed2020]

In what application? Excel? Access?

Ed Metcalfe.

Please do not feed the trolls.....

 

[Ed2020]

Doh! Sorry, should have read your post more carefully.

Assuming you want each user to have their own user name and password:

Create a two field table containing UserName and Password fields.

Create a form with a combobox for the user name and a textbox for the password.

Create a button with the following code behind it:

Private Sub cmdCheckPassword_Click()
If Me.txtPassword.Value = DLookup("Password", "tblUsers", "UserName=" & """" & Me.cboUserName.Value & """") Then
'Password correct, open system's main form
Else
'Password incorrect, deny access.
End If
End Sub

Ed Metcalfe.

Please do not feed the trolls.....