Working with PDF Files

[VogonPoet]

I'm printing a large number of Access reports to PDF files. I want to combine the separate files into one PDF file and create bookmarks. Any ideas. Also, has anyone seen a third party utility that makes accessing Acrobat easy for the Access/VB programmer.

 

[lameid]

Assuming you don't care about page numbers, you could make all your reports subreports in a new report and 'print' it.

 

[pcdaveh]

Question. Can you lead me to a source of documentation on how to save an Access report in PDF Format? I've been wanting to do that for ages...

 

[VogonPoet]

I don't have the name of the company any more, but I purchased a third party utility for $25 (and it works great). The utility is a class module in an MDE file. All you have to do is set a reference to the file and your able to output a report with code something like this:

With objPDF
.ImageType = "PDF"
.PDFNoShowPropDlg = True
.ReportName = "Report name"
.outputfile ="Path and File name"
.printimage
End With

I found the company by spending about an hour surfing the web.

 

[VogonPoet]

Thanks for the subform idea, but unfortunately it won't work in this situation.

I'm generating approximately 30 reports several times for each of several lines of business/region combinations. I have code that loops through and runs each report for each lob/region. I would like to combine the 120 reports into 1 PDF and be able to programmatically create the bookmarks (with appropriate parent bookmarks for the lob/regions).

 

[genomon]

Try going to ctrlp.com and get free download 5D PDF. I am in the same boat and was given this address by a buddy...
Good luck!

 

[VogonPoet]

Thanks for the tip.

 

[genomon]

Sorry Vogon!
After posting that last I tried the website only to find it merged with another and the free download no longer available! I DID find the same software package for sale ($120 USD) at hardsoft.com. Guess I slept too long on that one - sorry!