Merge 15 access reports into 1 pdf file vba

[aman]

Hi Guys

I have about 15 reports and I want to combine them into 1 report. I don't want to create 15 sub reports into 1 report but thinking of a possibility to create 1 pdf file that will combine hem.

Any help will be much appreciated .

Thanks

 

[Ranman256]

thats how you do it....
make 15 sub reports.

 

[Ranman256]

thats how you do it....
make 15 sub reports.

Its not difficult. Make your 15 reports, then make 1 more blank report and place 15 subrpt boxes in the blank report.

 

[sxschech]

Are you saying you have 15 reports already created and want to combine them into one pdf, if you have full version of acrobat, there is vba code that can combine multiple files, or if it is a one time thing, you can combine them directly in acrobat by dragging and dropping the pages into the "master" pdf document.

Post number 2:
https://access-programmers.co.uk/forums/showthread.php?t=249514&highlight=combine+pdf

Another option:
pdftk can do a lot of things with pdf files. They have a free version which includes a command line interface that can be used in vba.

https://www.pdflabs.com/t/pdftk/

 

[arnelgp]

If you are using Adobe http://www.vbaexpress.com/forum/showthread.php?47310-Need-code-to-merge-PDF-files-in-a-folder-using-adobe-acrobat-X