Creating a PDF file from multiple reports

[AndrewDB]

I have a small Access DB where I capture accident claim information and then
run 5 reports which contain the data layered over a background image of the
actual claim form (1 report per page). This is simple enough and works well
when I print it. I need to email this to headoffice by combining these
reports into 1, changing it into a single PDF file and then mailing it. I can
do this for each individual report by printing the report to Adobe PDF
through VBA but cannot find any information on how to combine the reports
using VBA. Help will be appreciated.

 

[Tom van Stiphout]

On Wed, 28 Jan 2009 09:34:25 -0800, AndrewDB

Perhaps you could create a new report, and put the 5 reports on it as
subreports.

-Tom.
Microsoft Access MVP

 

[AndrewDB]

Hi Tom. That's a possibility I haven't considered. I will definately try it.
Just one question: Considering that the report is then loading 5 linked jpg
images at once will it still be within the limitations of the memory
overhead? Will let you know