Access Reports to different file format

[mar_t]

Hi,



I need a VBA code that will export my access reports to different file format (.xls,.PDF, .doc). For now, I want to convert my report to PDF. Would appreciate if you could help me on this one. Thank you.

[pbaldy]

Prior to 2007 there was no native way to export to PDF. Many of us use:

http://www.lebans.com/reporttopdf.htm

[mar_t]

Noted.
We have a Jaws PDF Creater driver installed on our computers, is it possible to automate (using VBA) this option to save my access report to PDF? I was thinking of creating command button and it will display the pdf save window (w/ file name and path). Don't know how to do it. Help.

[pkstormy]

When I was working with pdf files, I would set the default printer to the adobe writer, it would then produce the save file prompt when I went to print. See the code repository for code on changing the printer: https://www.accessforums.net/code-re...nter-7745.html

Otherwise there is code on several websites for saving to a pdf file.