Convert multiple reports to one PDF

[utstrat03]

Is there a to convert multiple reports to one PDF with VBA? I have a large amount of pdfs to produce around 4000. One of my other large problems I can not download any tools to help with this. I am using access 2010 and I have Adobe PDF Writer installed.

[June7]

Review
https://www.accessforums.net/access/...pdf-25574.html
https://www.accessforums.net/import-...ges-25042.html

[utstrat03]

Review
https://www.accessforums.net/access/...pdf-25574.html
https://www.accessforums.net/import-...ges-25042.html

Thanks for the info. I have never made references to another application like well other than Outlook. Is there a good information source on learning the concepts used in the link to the code that was given?

[utstrat03]

I have not used code like this before. Is there a good source of information to learn how to make code like this. I like to learn how to fish not just be handed a fish.

[June7]

I don't know any references. I assembled that code after days of searching and finding bits and pieces here and there.

[utstrat03]

Do you have to load a library of commands for Acrobat for this to work?

[June7]

Yes, need VBA reference to Adobe Acrobat X.0 Type Library.