Automate Printing of OLE Fields

  • Thread starter Thread starter Jamie Peters
  • Start date Start date
J

Jamie Peters

I have table with OLE Fields. I am inserting .pdf files.
I wish to print the pdf files automatically using code in
a report.

I have tried the following under the Sub Detail_Format;
Me.Attachment_2.Action = acOLEActivate

Where Attachment_2 refers to the bound object frame in the
report.

Adobe reader opens but displays the error "There was an
error processing the page. A file error has occurred"
 
Acrobat reader doesn't support any programming via VBA,
you need Acrobat full version for this. A better way might
be to store your files as paths rather than OLE's that way
you can open the PDF as an object using Acrobat and print
that way.

Be warned however Acrobat is not a clearly documented as
VBA, it can be done but does program in a different way.
 
Back
Top