Converting a Report in Access to PDF

pts.
Tags:
Access
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

<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>

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Randym
    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.
    1,740 pointsBadges:
    report
  • Tjones
    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!
    180 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following