Solved

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

Posted on 2006-07-13
3
837 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
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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Update 21-May-2015: I temporarily removed the source code and the code snippets to make major changes to the program. Regards, Joe A recent question here at Experts Exchange piqued my interest, so I decided to provide a thorough solution and publ…
This article is in response to a question here (http://www.experts-exchange.com/Other/URLs/Q_28283850.html) at Experts Exchange. The Original Poster has a scanned signature and wants to make the background transparent so that the signature may be pl…
In this third video of the Xpdf series, we discuss and demonstrate the PDFtoText utility, which converts PDF files into plain text files. Download and install the software.: You may have already downloaded and installed the Xpdf tools while watching…
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 …

831 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