Hi guys,

Have tried looking for a solution to this problem on the net, but I've not been able to get very far. I've created a table with an OLE data type and I've also created a from that will allow users to enter information into this table. The issue is that I the INSERT statement I'm using in the VBA code is throwing this error -

"An expression you entered is the wrong data type for one of the arguments."

VB Code:
  1. sql = "INSERT INTO .... blah blah blah .... Me.TxtAttachment.Value & ");"

The sql statement itself is ok - I've specified the correct field names and table name. The problem appears to be with the Value attribute of the TxtAttachment textbox.

Any idea where I'm going wrong on this?

Thanks in advance.