Desperately Need HELP Automating Report to PDF Writer!!

[DCBBB]

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!!!

 

[VogonPoet]

I was having the same problem and purchased a third-party utility for $25. It is put out by ATTAC Consulting Group (

http://ourworld.compuserve.com/homepages/attac-cg/ACGFile.htm).

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