Vba code to transfer attachment to a table

[ludovic_44]

HI All,



I have a form with 8 textboxes which users input and transfer all these data to a table when pressed on a button(VBA Code)

Below is the vba code i used, which works perfectly

CurrentDb.Execute "INSERT INTO tblreverse(txtRequestedBy,dtRequestedDate,txtPrevB illTo,txtOrderNo,txtInvoiceNo,txtLicenceNo,txtInst ruction,mmremarks) " & _
"values('" & Me.ccReq & "', #" & Format(Me.ccDate, "yyyy/mm/dd") & "#, '" & _
Me.ccPrev & "', '" & Me.ccOrder & "', '" & Me.ccInvoice & "', '" & Me.ccLic & "', '" & Me.ccInst & "','" & Me.ccRem & "')"

In the table tblreverse, i have also a field name which is "attAttachment".
What i'm trying is to insert a textbox in my form names ccAtt and when click on the button, the attachment goes to the table.

Here;s how i put the code

CurrentDb.Execute "INSERT INTO tblreverse(txtRequestedBy,dtRequestedDate,txtPrevB illTo,txtOrderNo,txtInvoiceNo,txtLicenceNo,txtInst ruction,mmremarks,attAttachment) " & _
"values('" & Me.ccReq & "', #" & Format(Me.ccDate, "yyyy/mm/dd") & "#, '" & _
Me.ccPrev & "', '" & Me.ccOrder & "', '" & Me.ccInvoice & "', '" & Me.ccLic & "', '" & Me.ccInst & "','" & Me.ccRem & "','" & Me.ccAtt & "')"

But it does not function

Can you please show me how to figure this out

Thanking you

Ludovic

[June7]

This is UNBOUND form?

Attachment field is a type of multi-value field. Requires special handling. Review:

https://www.accessforums.net/program...vba-21259.html

https://social.msdn.microsoft.com/Fo...orum=accessdev