kcwallace
11-12-2002, 05:56 PM
Is there a way to automatically print an Access report as a PDF to an specific location through code with out any user intervention?
P.S. I have Adobe Acrobat 5.0.
P.S. I have Adobe Acrobat 5.0.
Access Reportkcwallace 11-12-2002, 05:56 PM Is there a way to automatically print an Access report as a PDF to an specific location through code with out any user intervention? P.S. I have Adobe Acrobat 5.0. Aquila 11-13-2002, 07:52 AM Yes there is. heres the steps to do it. 1. get the current default printer save it in a variable 2. set the default printer to be acrobat 3. print the report to acrobat as a postscript file save it somewhere like a temp directory use the function Dim pdf As New PdfDistiller pdf.FileToPDF strFileName, strOutputFile, "C:\PDFMaker\default.joboptions" set pdf = nothing 4. delete your postscript file and your good. kcwallace 11-13-2002, 04:04 PM Thank You very much Malkadon 11-15-2002, 10:51 AM How do you get access to save out a postscript file without prompting for a file name? |
EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum