Runtime error 2471 occurs.
Is it because of LoginID?
Cause LoginID is a text not number
strSql = "update tblUser set txtPassword = """ & Me.TxtNew & """, dteChanged = #" & Date & "# where LoginID = " & Me.cboUser & "'"
and
Me.TxtHint = "For demo purposes " & Me.cboUser.Column(1) & "'s old...
Yes, text.
But the button stil not functioning. I put the incorrect old password (with my new password) and the button detects but when I insert correct old password (with new password), the button is not detecting.
Any idea?
Hello there,
I have an issue here where I cannot run my command button in VB Access. There is no error stated but the button just wont function.
Here is the code:
Private Sub Command14_Click()
Dim strOldPassword As String
Dim strSQL As String
strOldPassword = DLookup("[password]"...