I need help automating a report which needs to end up on a network drive in PDF format. I can open the report manually and send to the PDF writer, but with 50+ reports, this is too time consuming. When I try to automate this in code using the DoCmd.OutputTo command, Access doesn't recognize the .pdf file format (it accepts .rtf, .xls, and others, but not .pdf). I've thought of using DoCmd.PrintOut, but can't seem to automate it past the printer pop up (each file needs a unique name based on an ID#). Please help! Thanks!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Desperately Need HELP Automating Report to PDF Writer!!
- Thread starter DCBBB
- Start date
I was having the same problem and purchased a third-party utility for $25. It is put out by ATTAC Consulting Group ( I've been using it for 3 or 4 months now and it works perfectly.
If you need any help implementing it give me a holler.
michaelhodes@managedcare.com
Good Luck
If you need any help implementing it give me a holler.
michaelhodes@managedcare.com
Good Luck
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question