Ukaoha Eze
asked on
INSERT INTO STATEMENT ERROR
Currentdb.Execute "INSERT INTO tblRegister(Surname,FirstN ame,Middle Name,Email )" & _
" VALUES(" & Me.txtSurname & ",'" & Me.txtFName & "','" & Me.txtMName & "','" & Me.txtEmail & "')"
The code above gives me run time error 3061: Too Few parameter: expected 1
Also, I discovered that when I typed (1) the figure (1) into the surname textbox on my form. It inserts into the table tblRegister without the error. How can I make it insert name (letter) into the surname and not a number? Thanks in advance for the answer
" VALUES(" & Me.txtSurname & ",'" & Me.txtFName & "','" & Me.txtMName & "','" & Me.txtEmail & "')"
The code above gives me run time error 3061: Too Few parameter: expected 1
Also, I discovered that when I typed (1) the figure (1) into the surname textbox on my form. It inserts into the table tblRegister without the error. How can I make it insert name (letter) into the surname and not a number? Thanks in advance for the answer
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
which comment(s) works for you? you may proceed to close this question.
please comment before we close this question.
suggested solutions resolved the issue.
ASKER