jmw666
asked on
Covert or print Access report to PDF format, and put the output pdf files to a specified fold? Points will increase.
Currently I have few hundreds Access reports need to print to pdf and stored in a specified fold. Before I run print module, I have to manually change default print to pdf writer. Specified fold was set through Acrobat.
Any VBA can perform such operation directly in Access? Points will be 4 times more if the answer is practical.
Any VBA can perform such operation directly in Access? Points will be 4 times more if the answer is practical.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You do though, need to have A2K2 or later to have the Printers collection available.
ASKER
Kemp,
Many thanks. Your code works. Further to my question, can you give me the codes for putting the output pdf files to a specified fold? Eg"C:\Adorb PDF output".
Many thanks. Your code works. Further to my question, can you give me the codes for putting the output pdf files to a specified fold? Eg"C:\Adorb PDF output".
http://www.mvps.org/access/reports/rpt0009.htm
The DefaultPrt.zip file contains code to change/retrieve the default printer.