Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.
INSERT INTO STATEMENT ERROR
Currentdb.Execute "INSERT INTO tblRegister(Surname,FirstN
" 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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try this
Currentdb.Execute "INSERT INTO tblRegister(Surname,FirstName,MiddleName,Email)" & _
" VALUES('" & Me.txtSurname & "','" & Me.txtFName & "','" & Me.txtMName & "','" & Me.txtEmail & "')"
you should do this in case the user is entering single quote ' in to the text fields for better error handling.
Currentdb.Execute "INSERT INTO tblRegister(Surname,FirstName,MiddleName,Email)" & _
" VALUES('" & replace(Me.txtSurname,"'","''") & "','" & replace(Me.txtFName,"'","''") & "','" & replace(Me.txtMName,"'","''") & "','" & replace(Me.txtEmail,"'","''") & "')"
Premium Content
You need an Expert Office subscription to comment.Start Free Trial