export reports access as pdf file

  • Thread starter Thread starter geelhuis
  • Start date Start date
G

geelhuis

does some knowes what i have to do?

i have 250 different reports. to print them i send manually to my
pdfcuter writer. i want to do it with a maco or code. i don't know
nothing about codes....

thanks!
 
Geelhuis,

In design view of each report, go to File|Page Setup menu. On the Page tab,
select Specific Printer, and then set it to your cutepdf print driver.
(These instructions will be different if you are using Access 2007).

Then simply use an OpenReport action in your macro, and the report will be
output to PDF.
 
Geelhuis,

In design view of eachreport, go to File|Page Setup menu.  On the Page tab,
select Specific Printer, and then set it to your cutepdfprintdriver.
(These instructions will be different if you are usingAccess2007).

Then simply use an OpenReport action in your macro, and thereportwill be
output toPDF.
Click to expand...

thanks Steve. but i have already done that. but when the macro prints
to the pdf cuter he (or she?) is asking for the name en the place of
the output pdf. ofcourse the name is the name of the report and with
the first report pint i tell the system that he has to save the file
in a specific directory. but for all the other 249 reports i still
have to tell him that he must save in this directory... it is not a
big job to do, but is would be nice to automate this job..

thanks!
 
Geelhuis,

I'm sorry, I don't know how to do this. Not with a macro, anyway. I do not
have experience with the Cutie. I have used PDF995, which gives options to
automatically specifiy output path and file names. Maybe the Cutie does
too?

Otherwise, if you check out Stephen Lebans's sample at
http://www.lebans.com/reporttopdf.htm you will see that it is possible to do
this using VBA, but it is not a trivial task, you will have to work at it.
 
For the path, you could try the "SendKeys" action in the macro.

I have used this before to automatically overwrite file in the past by
simply sending the key "Y" when the prompt appears. Don't know if this will
work for you, but it's worth a try.

I stand ready to be shot down by real experts.
 
if you are using access 2007 there is a free add in available from microsoft
to export into pdf files which is available at

https://www.microsoft.com/downloads...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

then in your macro you could use the output to action select the format and
also a default file name and location something like this

="c:\location\" & [reportID]& ".pdf"

then all u wud need to do is add this to a button, and with 1 click
everything is done with no further input required.

I hope that this helps

regards

Dave
 
Back
Top