Merge 15 access reports into 1 pdf file vba (1 Viewer)

aman · Aug 17, 2017

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 · Aug 17, 2017

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

Ranman256 · Aug 17, 2017

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 · Aug 17, 2017

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 · Aug 17, 2017

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

Merge 15 access reports into 1 pdf file vba (1 Viewer)

aman

Registered User.

Ranman256

Well-known member

Ranman256

Well-known member

sxschech

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread