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

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!
bkapla1Asked:
Who is Participating?
 
Karl Heinz KremerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.