PHV, I have since stepped through line by line and the line(s) that throw the error are the
Application.TempVars.Add "CurrentUserName", DLookup("EmpName", "tblEmployees", "[EmpID]=" & Me.txtEmpLogin.Value)
Application.TempVars.Add "CurrentUserType", DLookup("EmpType", "tblEmployees"...
Im not sure as the error message is too vague.
There are multiple places where it could be happening. Its most likely one of the dlookups which involves the txtemplogin field. This one has me stumped, prior to me changing the if statements checking txtemplogin and txtpassword have been...
the expression you entered as a query produced this error: 'jasonp'.
jasonp being the username entered into the txtEmpLogin field.
Private Sub cmdLogin_Click()
Dim User As String
Dim UserName As String
Dim UserLevel As Integer
Dim TempPass As String
Dim ID As Integer
Dim EmpLogin As String
Dim...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.