Create PDF from Access Report WITHOUT Opening Adobe Acrobat Professional
Posted on 2011-10-03
I have successfully managed to create a PDF report from an MS Access 2010 database report. It works GREAT and I plan to use it in a process that will generate a hundred or so reports (certificates for conference attendees). However... I have run into one glitch that I cannot seem to get around.
Whenever I create a pdf report via the VBA code, it opens Adobe Acrobat Professional. I can't figure out a way to turn off the setting that tells it to open after creating the pdf. Talk about annoying. Closing the Access report is simple. But closing the Adobe app (or even better... creating the PDF without opening Acrobat) is proving to be a royal pain in the asterisk.
Appreciate any help you can provide.