Code to export report to PDF automatically?

[Joseph Greenberg]

What DoCmd code can I use to export a report directly to PDF, optimized for
printing, and have it prompt me for a new PDF name each time? Or if that is
complicated, always print to the same PDF name and location? Does the
end-user system need Acrobat installed for this to work? Do they need Access
2007? Thanks.

 

[Gina Whipp]

Joseph,

Have a look at... http://www.lebans.com/reporttopdf.htm I have used this
to print reports to PDF. You can set this up to get the name of the report
from a field on your form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Kerry Sllivan]

You may use docmd.output to

You have to give the output file a name but you may do it in a loop and
change the name or have it prompt you for the name

Kerry