Converting a Report in Access to PDF
Hi
Does anyone know the VB code used to convert a report in access to ADOBE PDF format and E-Mail it automatically? i can do so manually but it would far easier if i could just click on one button while in the form.
Thank you
Software/Hardware used:
Software/Hardware used:
ASKED:
January 31, 2006 11:41 AM
UPDATED:
May 3, 2012 12:36 PM
Answer Wiki:
<b>Advanced All to PDF 5.0</b> is a fast and affordable PDF conversion tool to help you batch convert Word documents, PowerPoint presentations, Excel Spreadsheets to PDF files quickly and accurately.
The original contents including formatting and layouts are exactly retained in the converted PDF files. The conversion allows you to add PDF properties to the output PDF file, like author, passwords, allowed actions, etc.
Moreover, Batch conversion and partial conversion are supported, which make your conversion more efficient.
<b><a href="http://www.advancedpdfconverter.com/products/alltopdf.html">http://www.advancedpdfconverter.com/products/alltopdf.html</a></b>
To see all answers submitted to the Answer Wiki: View Answer History.
I am not sure if Access can create PDF formats directly.
I have created snapshot files using the OutputTo method. So maybe you could do PDF the same way. If you can, it is not documented to my knowledge. With snapshot, the format would be “Snapshot Format”. This has worked really well for me. If people don’t have the snapshot viewer, it can be downloaded free from Microsoft.
First you need a program installed on your workstation that can create PDFs, either a purchased program like Adobe Acrobat or PDF Creator, or a free solution like PDF995 (http://www.pdf995.com/). Either solution will give you a new printer object that will let you print from any application to a PDF file. Then, like CharlesJC said, you can record a macro that will select the PDF printer and print to a PDF file.
The only drawback of the PDF995 solution is that whenever you print to their PDF printer, they also open up a browser window to their website. Basically, this is a nag screen urging you to buy their product. Bothersome, but hey, its free!