Code to save report as PDF

SF · Jul 24, 2006

Hi,

I have a report and want to save in PDF. I could send this report to PDF
manualy (View the report and print to ABODE PDF (abode reader pro 6
installed).

Is there a way to use access code to export this report automatically to PDF
with one single click of button? Someone recommend to use
Application.printers but I just cannot find a way to relate report to this
command

SF

Allen Browne · Jul 24, 2006

If you are using Access 2002 or 2003, you can set the Printer object.

Alternatively, Stephen Lebans has a solution here:
http://www.lebans.com/reporttopdf.htm

SF · Jul 25, 2006

Yes, It is very useful. Thank you.

sf

Allen Browne said:
If you are using Access 2002 or 2003, you can set the Printer object.

Alternatively, Stephen Lebans has a solution here:
http://www.lebans.com/reporttopdf.htm