Print files stored in an OLE field

[Brad Harris]

Is there a simple way to print files stored in an OLE field using the Windows associated programs? So if it is a .doc, it will open Word, print it and close. PDF opens Acrobat Reader, prints and closes, etc.

It would be just like right clicking on a file in Windows Explorer & hitting Print. I just need to do it on files stored in an OLE field. My goal is to hit one button, have an Access report print and then print the attachments associated with that record.

Is it possible?

[ChrisO]

Let’s reverse the questions: -

Is it possible?
Yes.
The process would start with understanding http://allapi.mentalis.org/apilist/ShellExecute.shtml

Is there a simple way to print files stored in an OLE field using the Windows associated programs?
That would depend on what you call simple.
OLE fields can store BLOBS and that would require more code.