i have a query that is driving me crazy.
Table Name is USERS and the structure of my table is this:
UserId - AutoNumber
FirstName - text
LastName - text
UserName - text
Password - text
Level - Text
Active - Yes/No
im trying to update with this query:
DoCmd.RunSQL "UPDATE USERS SET FirstName = '" & Me.Fname.Value & "', LastName = '" & Me.Lname.Value & "', UserName = '" & Me.uname.Value & "', Password = '" & Me.pass.Value & "', Level = '" & Me.cboType.Value & "', Active = " & Me.Active.Value & " WHERE UserID = " & Me.cboUser.Value & ";"
and getting errors. ive been trying for the last hour. please render some assistance.
Table Name is USERS and the structure of my table is this:
UserId - AutoNumber
FirstName - text
LastName - text
UserName - text
Password - text
Level - Text
Active - Yes/No
im trying to update with this query:
DoCmd.RunSQL "UPDATE USERS SET FirstName = '" & Me.Fname.Value & "', LastName = '" & Me.Lname.Value & "', UserName = '" & Me.uname.Value & "', Password = '" & Me.pass.Value & "', Level = '" & Me.cboType.Value & "', Active = " & Me.Active.Value & " WHERE UserID = " & Me.cboUser.Value & ";"
and getting errors. ive been trying for the last hour. please render some assistance.