Report to PDF in Adobe 8

[JA]

I located some code online to save a report to a PDF file. Works fine,
except I am prompted for a location to save the file to. Is there any way
to disable this? I need to run hundreds of reports automatically without
user intervantion.

 

[Tony Toews [MVP]]

I located some code online to save a report to a PDF file. Works fine,
except I am prompted for a location to save the file to. Is there any way
to disable this? I need to run hundreds of reports automatically without
user intervantion.

Do you really want to use Adobe Acrobat? It's quite expensive on a
per user basis and is very much overkill. There are free solutions
available. Either way though you'll find some relevant links at
Creating PDF files from within Microsoft Access
http://www.granite.ab.ca/access/pdffiles.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/