Solved

Avoid "Save" Dialog box when printing Access Report to Adobe PDF

Posted on 2006-07-13
3
839 Views
Last Modified: 2012-05-05
I asked this question in the MS Access forum, but wasn't sure if it's more suited to this forum, so I'll ask it here as well:

Is there a way to bypass the "Save" dialog box when performing the following command for an Access Report:

Set Application.Printer = Application.Printers("Adobe PDF")

DoCmd.OpenReport "r_ByPerson", acViewNormal, , , , strSQL

Set printer back to original printer

The functionality works fine to generate the PDF from the Access Report, however the user is 1st required to save the document.  I'd like to bypass/avoid forcing the user to save the document such that the the report is automatically opened in Adobe (Only user's with Acrobat Professional will be using this feature).  Then, once in Adobe, the user can opt to save the document manually (File->Save) if they chose.

Thanks!
0
Comment
Question by:bkapla1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 44

Accepted Solution

by:
Karl Heinz Kremer earned 500 total points
ID: 17101275
Download the "Distiller API Reference" from Adobe's web site: http://partners.adobe.com/public/developer/acrobat/sdk/index_doc.html#api (you may need to register for a free web account). On pages 19 and 20 it describes how to turn off the prompt for the filename. You have to create a register key with the file name.

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update 21-May-2015: I temporarily removed the source code to make major changes to the program. Regards, Joe In a previous Experts Exchange article, How To Rename-Move a Batch of PDF Files Based on Contents of the Files (http://www.experts-exchan…
Inserting page numbers in Portable Document Files not only enhances manageability but also makes them look professional. With numbered pages, the file appears more organized and it becomes easier to search for a particular page. The size and the vol…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question