Greetings,

I am considered a freshman when it comes to vba, so having said.  I have a situation where I need to convert multiple Microsoft Access Reports (about 6) into one PDF file with bookmarks using vba in Access.  I am using Office 2007 and Acrobat 9.  Acrobat 9 has a great add in that converts multiple Access reports into one PDF file, however I need to figure out how to automate this using vba.  My earlier attempt at using Send Keys to access the add in was not efficient.  Can anyone shed some advice on the best way to achieve this objective.  I am familiar with Vba, but have never tried to access the PDF distiller or application using code.

Any advice would be greatly appreciated.

Thanks in advance.

Thank you for the response.

I am not familiar with your product can your product be used in a way that would assist in my objective?

Hi,

Good to hear.  I have done quite a bit of research regarding my objective and have come across various applications that are similar in nature to your product.  However, what may differentiate them from yours in my mind is by one question.  You mentioned your product comes with ActiveX component add-on with sample VBA code that will convert a report to a PDF file... along with other capabilities.  I am interested in converting/merging "multiple reports" into one PDF file, not multiple PDF files into one PDF file.  Since Access already has built in VBA capabilites to convert one report to PDF it does not have Office com references to convert multiple reports to one PDF.  Does your product have this capability?

Thanks again for your help.

Hi Michel -

Kind of an old thread but I thought I'd jump in here since I have a detailed question on the same topic. 

We're trying to use PDFR V 2.2.6 (both Pro and the Active X via code) to merge 2 PDFs created with the Access PDF printer, but hit an error (in Pro it's that "One of the Files in the Merge List is missing, locked or encrypted").  When we try the merge with 2 PDFs created with PDFR it works fine.  We've tracked down the problem - it's that Access creates PDF version 1.5 files while PDFR creates PDF version 1.4 (when we use Acrobat to convert the Access 1.5 files to 1.4 then we can merge them with PDFR just fine). 

So my question: how to we get PDFR to work with PDF version 1.5?  Will 2.2.8 do that?  Or is it a function of the Ghostscript version? or something else?

Hope all is well!

thanks -
Rick N.

Hi Michel -

Thanks - hope that didn't take too much of your weekend!  The new versions (both PDFR Pro interactively and the ActiveX via code) work fine to merge the PDFs created with Access.  It's clear that you're correct: it's not the PDF version (1.4 vs. 1.5) that was causing the problem as we thought.

We've gotten a bit confused with version numbering and upgrading, so I want to check that with you.  I finally understand that it's the Capture.exe version that displays in the UI (now 2.2.13), so that helps some.  Our client currently has:

Capture.exe - 2.2.6
PDF_reDirect.exe - 2.2.6
PDFR_Printer_Cmds.exe - 2.2.5
ActiveX_PDF_Pro.dll - 2.2.8
(they're all actually 4 digits like 2.2.0.6 but I'm adjusting for what I assume is the normal VB version weirdness)

When we run the upgrade (which I realize is for 2.2.8 to 2.2.13) we get:
Capture.exe - 2.2.13
PDF_reDirect.exe - 2.2.6
PDFR_Printer_Cmds.exe - 2.2.5
(leaving ActiveX out of this since it's a separate issue)

But when we run the full 2.2.13 install, we get:
Capture.exe - 2.2.13
PDF_reDirect.exe - 2.2.6
PDFR_Printer_Cmds.exe - 2.2.8

So should we run the full install to get the more recent PDFR_Printer_Cmds.exe?

Also, I noticed that the production PDF_reDirect.exe v2.2.6 has a file date of 7/6/08 6:30 PM, while after a full 2.2 13 install the file is dated 8/4/08 10:06 PM.  Should we be concerned about that?

thanks -
Rick

Hi Michel - That sounds good.  And thanks for the info on the version reporting; it's often helpful to understand more of the details.  thanks - Rick