Send data to a table from a form by a submit button

[ludovic_44]

Hi All



I have an issue with my form where i have a submit button
My table name is tblReverse
field are as per attached

When i click on the submit button to send the data to a table, it gives me an error as per attached

Is there a problem with my code:
CurrentDb.Execute "insert into tblreverse(txtRequestedBy,dtRequestedDate,txtPrevB illTo,txtOrderNo,txtInvoiceNo,txtLicenceNo,txtInst ruction,attAttachment,mmRemarks)" & _
"values(""," & Me.ccReq & ",'" & Me.ccDate & "','" & _
Me.ccPrev & ",'" & Me.ccOrder & ",'" & Me.ccInvoice & ",'" & Me.ccLic & ",'" & Me.ccInst & ",'" & Me.ccAtt & ",'" & Me.ccRem & "')"

Im new in VBA and i cant understand these code which i get from google

Can you please help me ,

Thanking you


Attachment 18044Attachment 18045Attachment 18045& ",'" & Me.ccRem & "')"

[pbaldy]

Use a variable for the SQL and this method to see how it's coming out.

http://www.baldyweb.com/ImmediateWindow.htm

offhand, your use of delimiters is inconsistent and may not be correct for each data type. Basically date values use #, text values ' and numeric values no delimiter.

[ludovic_44]

HI
I did what you told me, i google, but still i have another error now:

Run-time error '3134':
Syntax error in INSERT INTO statement

I changed my code to :
CurrentDb.Execute "insert into tblreverse(txtRequestedBy,dtRequestedDate,txtPrevB illTo,txtOrderNo,txtInvoiceNo,txtLicenceNo,txtInst ruction,attAttachment,mmRemarks)" & _
"values(" & Me.ccReq & ", # & Me.ccDate & #, " & _
Me.ccPrev & ", " & Me.ccOrder & ", " & Me.ccInvoice & ", " & Me.ccLic & ", " & Me.ccInst & ", " & Me.ccAtt & ", " & Me.ccRem & ")"

I really cant figure it out where lies the issue
Can you please have a look

Thanking you

[June7]

Missing quote marks. The delimiters are literal text and need to be within the quote marks, along with the comma.

"values(" & Me.ccReq & ", #" & Me.ccDate & "#, " & _

If any of those fields are text type, the value parameters need apostrophe delimiters.

Why are you using Execute to create record in table? Why not a bound form for data entry?

[pbaldy]

I'll step out of the way.