Link to home
Start Free TrialLog in
Avatar of jmw666
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.  
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

See here:
http://www.mvps.org/access/reports/rpt0009.htm

The DefaultPrt.zip file contains code to change/retrieve the default printer.
ASKER CERTIFIED SOLUTION
Avatar of kemp_a
kemp_a

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You do though, need to have A2K2 or later to have the Printers collection available.
Avatar of jmw666
jmw666

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".