Automate printing reports to PDF

[sanditaylor]

Hi There,
I'm quite new to access & to VB. I'm working with a database which
through a form, you can generate a pdf report (using pdf995). Choose
the report from a dropdown box, and then click 'View Report'.
Every month I need to generate about 30 different reports and so was
wondering if there was something I could do to automate this process?
Any ideas would be greatly appreciated.

Cheers

[Steve Jorgensen]

On 8 Dec 2005 20:03:36 -0800, sa*********@gmail.com wrote:

Hi There,
I'm quite new to access & to VB. I'm working with a database which
through a form, you can generate a pdf report (using pdf995). Choose
the report from a dropdown box, and then click 'View Report'.
Every month I need to generate about 30 different reports and so was
wondering if there was something I could do to automate this process?
Any ideas would be greatly appreciated.

Cheers

I haven't done it myself, but I had a client who successfully used pdf995 for
report export automation. As I recall, they wrote settings files from Access
to tell pdf995 what to do, then just used OpenReport to "print".

[Douglas J. Steele]

Stephen Lebans has a new product out that will generate PDFs without
requiring any other product.

Take a look at http://www.lebans.com/reporttopdf.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<sa*********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hi There,
I'm quite new to access & to VB. I'm working with a database which
through a form, you can generate a pdf report (using pdf995). Choose
the report from a dropdown box, and then click 'View Report'.
Every month I need to generate about 30 different reports and so was
wondering if there was something I could do to automate this process?
Any ideas would be greatly appreciated.

Cheers