Printing to a pdf file

[SJM]

I am currently at a site where some users have Adobe Reader/Distiller 6
installed on their PC's and I need to provide the ability to save reports as
pdf files.
Searching the internet I found a number of sites that described how to do
this, but they involved writing to the registry. As this is an soe site I am
unable to modify the registry. Without doing this I gather I cannot preset
the file name or path of the pdf file to be created. When I open the report
with the default printer set to Adobe PDF Writer, I get the Savas dialog
box. I would prefer to fully automate this process so tried to use SendKeys
commands to fill in the filename, but these did not register with the dialog
box, as the code stopped dead until the pdf file saveas dialog box was
closed. Is there anything I can do to get around this, or is it a case of
tough luck.

[Tony Toews]

"SJM" <no****@ms.com> wrote:

I am currently at a site where some users have Adobe Reader/Distiller 6
installed on their PC's and I need to provide the ability to save reports as
pdf files.
Searching the internet I found a number of sites that described how to do
this, but they involved writing to the registry. As this is an soe site I am
unable to modify the registry. Without doing this I gather I cannot preset
the file name or path of the pdf file to be created. When I open the report
with the default printer set to Adobe PDF Writer, I get the Savas dialog
box. I would prefer to fully automate this process so tried to use SendKeys
commands to fill in the filename, but these did not register with the dialog
box, as the code stopped dead until the pdf file saveas dialog box was
closed. Is there anything I can do to get around this, or is it a case of
tough luck.

There might be some links at the Creating PDF files from within Microsoft Access
http://www.granite.ab.ca/access/pdffiles.htm page. It may very well be that a
different, free product will work better for you.

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

[SJM]

thanks for reply Tony.
I briefly saw this site. I was hoping to make use of Acrobat since they had
paid for it, and installation of any non approved programs is very difficult
at this site, but I will check it out again, as it looks like my options are
rather limited.

There might be some links at the Creating PDF files from within Microsoft Access http://www.granite.ab.ca/access/pdffiles.htm page. It may very well be that a different, free product will work better for you.

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