How to output multiple reports to a single PDF

[lccrews]

My question is simple, but I'm pretty sure the solution is not. I'm a beginner but I'm willing to learn. I'd like to print the following reports to a single PDF. Is this possible in Access 2016Data Analytics - Formulation - MBR.zip?
1. rpt_MBR_Summary


2. rpt_MBR_Weighing
3. rpt_MBR_Blending
4. rpt_MBR_Compressing
5. rpt_MBR_Coating
6. rpt_MBR_ContinuousCoating

[aytee111]

This link provides two methods you could use:
https://social.msdn.microsoft.com/Fo...orum=accessdev

[lccrews]

According to your link, there is no method in the current API to output multiple reports into one PDF. I only saw a way to output one report to PDF via VBA. I cannot use subreports because the reports are too long.

[aytee111]

According to your link, there is no method in the current API to output multiple reports into one PDF

Let us know if you find a way.

I cannot use subreports because the reports are too long.

Can you elaborate? Is there a maximum size of the output file, or what are you referring to?

[lccrews]

My reports are near the max limit of one report. When I insert them as subreports, the windows are fairly large. There would be enough room for maybe 2 subreports out of the 6 I need to print to file.

I'll keep hunting and post here if I do

[aytee111]

In all my years I have never had to consider the maximum size of anything (except the database file). I guess you are nearing one of these (it would be interesting to know which one):
https://support.office.com/en-us/art...9-ea9dff1fa854

[lccrews]

Feel free to look at my database. The reports do reach a maximum of 22.75" occasionally. rpt_MBR_Blending is a prime example.

[ssanfu]

I have a PDF print driver that I use to create PDFs named Primo PDF that has an option to append to an existing PDF (although I have never tried it).

So print the first report, then append the next 5 reports to the PDF. Might be an option..... and did I say it is free???

(not Nitro Pro --- $$$)