If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a PDF file from multiple reports
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. -- Kepior Senso Fumor |
#2
|
|||
|
|||
Creating a PDF file from multiple reports
On Wed, 28 Jan 2009 09:34:25 -0800, AndrewDB
wrote: Perhaps you could create a new report, and put the 5 reports on it as subreports. -Tom. Microsoft Access MVP 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. |
#3
|
|||
|
|||
Creating a PDF file from multiple reports
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 -- Kepior Senso Fumor "Tom van Stiphout" wrote: On Wed, 28 Jan 2009 09:34:25 -0800, AndrewDB wrote: Perhaps you could create a new report, and put the 5 reports on it as subreports. -Tom. Microsoft Access MVP 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. |
Thread Tools | |
Display Modes | |
|
|