Code to save report as PDF

[SF]

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]

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]

Yes, It is very useful. Thank you.

sf

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