Saving a report as a pdf automatically

[ChuckW]

Hello,

I have a PDF writer called cutePDF as a default printer on one of our
servers. This is the same server that has my Access database on it. I want
to create a macro which will run a report and then save it as a pdf to a
certain location. This will happen once a week at the same time. By using
the OpenReport step in a macro I can open it. I also have it set to print to
the cutePDF writer in this step as well. The next step is to confirm that I
want to print or save it as a PDF file to a certain location. If I click
Enter then this is the same thing as save. The next step is that it asks me
if I want to overwrite the existing file which I do. From a keyboard
standpoint I actually have to do a tab and then enter to save it. Basically
I want to create a macro which will save the report as a PDF. The report
will have the same name and location and be done every Sunday. I then will
schedule as a task to do automatically. How do I get the macro to do all of
these
things?

Thanks,

 

[Peter R. Fletcher]

With some difficulty! See my response on a similar subject to
"Williams", a few threads up.

Hello,

I have a PDF writer called cutePDF as a default printer on one of our
servers. This is the same server that has my Access database on it. I want
to create a macro which will run a report and then save it as a pdf to a
certain location. This will happen once a week at the same time. By using
the OpenReport step in a macro I can open it. I also have it set to print to
the cutePDF writer in this step as well. The next step is to confirm that I
want to print or save it as a PDF file to a certain location. If I click
Enter then this is the same thing as save. The next step is that it asks me
if I want to overwrite the existing file which I do. From a keyboard
standpoint I actually have to do a tab and then enter to save it. Basically
I want to create a macro which will save the report as a PDF. The report
will have the same name and location and be done every Sunday. I then will
schedule as a task to do automatically. How do I get the macro to do all of
these
things?

Thanks,

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[SA]

The "free" PDF printer drivers like cute pdf you can't control so you can't
automate output. However, with some very modestly inexpensive drivers like
Win2PDF (www.daneprairie.com) or Zeon's DocuCom PDF Printer
(www.pdfwizard.com) you can automate them. Our PDF and Mail Library works
with both these drivers and allows you to automate output of a PDF file from
an Access report and then e-mail using outlook or outlook express (notes and
GW as well). You'll find our PDF and Mail Library for Access in the
Developer Tools section of our web.