Question concerning Access' new Attachment field

everobin

New member
Joined
Aug 20, 2008
Messages
1
Programming Experience
1-3
I'm trying to create a listbox where I list out the attachment for a particular record but then also enable the user to double-click and open up the attachment directly from the listbox. Writing out the contents to the listbox is easy enough but I'm having a problem getting the complex data object (in my case, a docx) to be accessible through the double-click.

Through Access VBA I know you can use the Recordset2/Field2 combo to get at the complex datatype stored in the Attachment field but I can't seem to find a comparable solution in my Windows Forms App. The closest thing I could find was the Recordset2/Field2 explanation offered by MS:

Access Team Blog : Using VBA code to open a file stored in the new Access 2007 Attachment field

I can't implement this because Recordset2/Field2 aren't part of the DAO reference in VB.


Any ideas?
 

Latest posts

Back
Top