Merge 3 MS Access reports and save to a different location in a PDF format

[jasonbro]

I have MS Access 2010 whre I have built a report that filters on a specific form record that I am currently viewing. There are 3 reports with multiple pages. I would like to merge all 3 reports into 1 PDF and saved to a different location each time. MS 2010 comes with a way to save to a PDF, I also have ScanPort Creat installed as a printer for creating PDFs.

Creating a subreport would not work for me because of the size of the reports. Is there a VBA code that will allow me to print or save all reports to one PDF?

 

[sxschech]

Here is a link for code that will merge multiple PDF reports into one pdf file.

http://www.tek-tips.com/viewthread.cfm?qid=1648313

 

[jasonbro]

I do not have Adobe Acrobat. I use Nuance's Paper Port 14 with comes with a PDF creator.

 

[dhookom]

Did you search the support site for Nuance's Paper Port 14? Chances are fairly slim that anyone replying hear would have much information about that particular product.

Duane
Hook'D on Access
MS Access MVP