Solved

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

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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…
*Adobe Acrobat 9 was used for this article. Particular steps may vary depending on software versions. 1. Create a framework of your form in Word, leaving space where you’d ultimately like the Adobe fields to appear.  (Note: I use the blank lines …
We often encounter PDF files that are pure images, that is, they do not have text characters, but instead contain only raster graphics. The most common causes of this are document scanning software and faxing software/services that create image-only…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Suggested Courses

628 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