Avoid "Save" Dialog box when printing Access Report to Adobe PDF
Posted on 2006-07-13
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.