troubleshooting Question

Anyway to print a MS Access report using PDFMAKERAPILib?

Avatar of stephenlecomptejr
stephenlecomptejrFlag for United States of America asked on
Microsoft Access
12 Comments1 Solution4135 ViewsLast Modified:
I have Adobe 7.0 Professional and trying to print an MS Access report using PDFMAKERAPILib?  (PDFMaker API 1.0 Type Library)

When I do:  

Dim pdf As PDFMakerApp
pdf.  <---- intellisense comes up as ...   CreatePDF,  CreatePDFFromMultipleFiles, CreatePDFFromObject, GetSupportedApp

I'm guessing I need to use CreatePDFFromObject but the values are showing as:

Function CreatePDFFromObject(srcFilePath As String, pdfFilePath As String, bstrObjectName As String, lObjectType As Long, [pSettings], [bConvertSilent], [bShowProgress], [bConvertAsync], [pClientHandle]) As Long

Any ideas how I may use this to print an Access object like a report?

This is the full function:

Private Sub Print_Report(sName As String)
  DoCmd.OpenReport sName, acViewPreview
  Dim pdf As PDFMakerApp
  pdf.CreatePDFFromObject("C:\Program Files\Adobe\Acrobat\acrobat.exe", "C:\WORK", sName, 1)

End Sub

Please no comments or posting on purchasing or downloading company or self-made PDF type programs that do this already.  I'm in a position where I wouldn't be able to install any dlls because of current network install restrictions.  I have to use what I have available.

Thanks in advance.

Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros