Hi guys would really appreciate some help here.
I've created a database and I'm trying to make a log-in screen for it. I've currently got a table named "tbl_SystemUsers"
For the Log In form, I've got Username (Combo10) and Password (Text 2) fields. Every time I click the log in button I get error 424 (object not found)
My exact script for the click of Log In (Command12) is:
When I hover the mouse over tbl_SystemUsers, it says that is empty.
Any help would be appreciated, bit of a newb in this area so any help would be fantastic.
Thanks
I've created a database and I'm trying to make a log-in screen for it. I've currently got a table named "tbl_SystemUsers"
For the Log In form, I've got Username (Combo10) and Password (Text 2) fields. Every time I click the log in button I get error 424 (object not found)
My exact script for the click of Log In (Command12) is:
Code:
Private Sub Command12_Click()
'Check value of password in tblSystemUsers to see if this
'matches value chosen in combo box
If Text2.Value = DLookup("[Password]", tbl_SystemUsers, "[UserID]=" & UserName.Value) Then
UserID = UserName.Value
'Close logon form and open splash screen
DoCmd.Close acForm, "frm_LogIn", acSaveNo
DoCmd.OpenForm "frm_StartUp"
Else
MsgBox "Password Invalid. Please Try Again", vbOKOnly, "Invalid Entry!"
Text2.SetFocus
End If
End Sub
When I hover the mouse over tbl_SystemUsers, it says that is empty.
Any help would be appreciated, bit of a newb in this area so any help would be fantastic.
Thanks