Access 2007 and PDFs Question

[brimes]

Soon we will be migrating from A2003 to A2007 (but don't have A2007 from our infrastructure people yet).

We have been using ACG's PDF Pro Plus with A2003.
http://www.groupacg.com/acgpdf.htm

Most of our PDF stuff is simple, but one program uses their PDF Merge feature which concatenates multiple PDF reports into one PDF. Will the PDF feature in Access do this?

(I suppose sub-reports would be one solution but wonder if there is a better way)

Thanks

 

[ajetrumpet]

just a thought.

I believe the newest version of Adobe Acrobat does the merge thing too.

 

[boblarson]

Will the PDF feature in Access do this?

No, it will not.

 

[brimes]

Adam,

Can you control Acrobat programmatically from Access? If so, are there samples somewhere?

Thanks,

Brooks

just a thought.

I believe the newest version of Adobe Acrobat does the merge thing too.

 

[ajetrumpet]

Adam,

Can you control Acrobat programmatically from Access? If so, are there samples somewhere?

Thanks,

Brooks

i'm pretty sure you can brooks, but I don't know of any samples. You'll have to check the references in the VB editor too. I believe Acrobat is in there. If it is, then the answer is yes.

 

[tthuene]

No, you can not manipulate Adobe Acrobat from Access, you would have to use Java to do that.
While I believe you would be better to concatenate various reports first, and export them to PDF, I had a lot of success with PDFCreator in an Access 2003 database (there is no PDF support in 2003).
You would invoke a PDF Creator session using Active X, set it to "WAIT", and then print into it. Works actually qutie nicely. You can even mix access reports and word files or previously generated PDF files.
You will find various tutorial files about PDF Creator and VBA Active X on the web, no need to add one here.

 

[boblarson]

No, you can not manipulate Adobe Acrobat from Access, you would have to use Java to do that.

Incorrect answer. In fact, we do some Acrobat manipulation directly from Access and merge pdf's and add bookmarks to the merged documents. But that is only by having the full version of Acrobat installed.

 

[sxschech]

Here is a link with sample code how to do it, although it talks about Excel, I have been using it in Access to merge various pdf files together. However, as Bob pointed out, you will need the full version of Adobe Acrobat not Acrobat Reader.

http://www.khk.net/wordpress/2009/03/04/adobe-acrobat-and-vba-an-introduction/