Saving Access reports as PDF files

[Carol]

How do I do this? I have used DoCmd.OutputTo, acOutputReport but I do not
seem able to specify a format that will open the report in pdf.

Thanks!

 

[Rick Brandt]

How do I do this? I have used DoCmd.OutputTo, acOutputReport but I do not
seem able to specify a format that will open the report in pdf.

You would have to install PDF writer software. Most of these act as virtual
printers. You print your report specifying the PDF writer as the printer. The
PDF software will prompt you for a file name and location and then create the
file at that location.

There are numerous free PDF writers, but these have somewhat limited
capabilities to be controlled from code.

 

[tina]

to save a report as a PDF file, print the report using a PDF printer driver.

hth

 

[Larry Linson]

How do I do this? I have used DoCmd.OutputTo, acOutputReport but I do not
seem able to specify a format that will open the report in pdf.

Take a look at MVP Stephen Lebans free download... ReportToPDF... at
http://www.lebans.com/reporttopdf.htm.

I've had such good luck with a very out-of-date copy of Adobe Acrobat,
originally bought from a surplus software dealer, and even then
not-current-version, that I've never bothered to update.

Larry Linson
Microsoft Access MVP