open a pdf stored as an ole object

[khumbo]

hey guys,

i have a help file which i stored as a pdf in a table as an ole object. Does anyone know how to open it up from the table?

thanks

[June7]

Do you want to open the file in Adobe Reader or Acrobat or view the PDF embedded on form?

Does this help
http://www.pcreview.co.uk/forums/re-...-t2924668.html
http://www.dbforums.com/microsoft-ac...bject-vba.html

[khumbo]

thanks for the reply. I would like to view it in Adobe Reader.

[June7]

I just reread your op and caught that you want to open from the table. Only way I can see that happening is to right click on the field > Package Object > Activate Contents. This opens a popup - click Open.

[khumbo]

sorry i just realized i might have not been very specific. I have a help button on the ribbon and when i click it i want to open up the pdf file which is stored in a table as an ole object.

[June7]

I doubt code could address table directly. However, bind a form to the table and code can reference the current record. I created a bound OLE control and a button on a form. This code in button Click event works:

Me.OLEBound94.Action = acOLEActivate

The ribbon button would probably have to call a public function.