Desperately Need HELP Automating Report to PDF Writer!! 2

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

 

[JoeMiller]

Try this web page:

Reports: Save a report's output as a PDF file

http://www.mvps.org/access/reports/rpt0011.htm

Joe Miller
joe.miller@flotech.net

 

[DCBBB]

Thanks, Joe! I couldn't even begin to decipher what is going on with all that complex code, but I plugged it in and it actually worked!! Now I am lookin' like a hero!

 

[AccessQuestion]

If you still have the solution could you please send this to me. Your help would be greatly appreciated.

 

[86FXR]

I would also like a copy of the code, if at all possible. That particular link

http://www.mvps.org/access/reports/rpt0011.htm

is no longer available. Our sales staff would like to send out quotes from an Access report, and since they are continually sending quotes, it would be extremely helpful. Thanks

Laura
laura@american-telesis.net

 

[SgtJarrow]

Check out faq703-2533. I posted this FAq and it is exactly what you are trying to do, spelled out fairly easily. Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com