Outputting Reports into PDF file

[phong.lee]

Hello all,

I was wondering if someone can assist me in outputting 6 reports into
a pdf file? I created a macro that generates the 6 reports and right
now it's saved as a snapshot on my drive. Any ideals or sample will
be greatly appreciated.

[Chuck Grimsby]

Install PDF Creator (Freeware) from
http://www.pdfforge.org/products/pdfcreator

This installs a PDF Print Driver onto your computer. Then, just print
to that.

There are a number of options in the program for automating the output,
if you want to use it in a situation where you are running a number of
reports.

ph*******@gmail .com wrote:

Hello all,

I was wondering if someone can assist me in outputting 6 reports into
a pdf file? I created a macro that generates the 6 reports and right
now it's saved as a snapshot on my drive. Any ideals or sample will
be greatly appreciated.

[phong.lee]

On Sep 11, 5:58 pm, Chuck Grimsby <c_grim...@worl dnet.att.net.in valid>
wrote:

Install PDF Creator (Freeware) fromhttp://www.pdfforge.or g/products/pdfcreator

This installs a PDF Print Driver onto your computer. Then, just print
to that.

There are a number of options in the program for automating the output,
if you want to use it in a situation where you are running a number of
reports.

phong....@gmail .com wrote:

Hello all,

I was wondering if someone can assist me in outputting 6 reports into
a pdf file? I created a macro that generates the 6 reports and right
now it's saved as a snapshot on my drive. Any ideals or sample will
be greatly appreciated.- Hide quoted text -

- Show quoted text -

Thanks, i was looking for some kind of vb script or some sample of
the vb script.

[Stuart McCall]

<ph*******@gmai l.comwrote in message
news:11******** **************@ e34g2000pro.goo glegroups.com.. .

Hello all,

I was wondering if someone can assist me in outputting 6 reports into
a pdf file? I created a macro that generates the 6 reports and right
now it's saved as a snapshot on my drive. Any ideals or sample will
be greatly appreciated.

I recommend you give Stephen Lebans' utility a try. Worked perfect 1st time
for me..

http://www.lebans.com/reporttopdf.htm

[Chuck Grimsby]

Once you've set up the report to work with the PDFCreator printer, all
you need to do is:

DoCmd.OpenRepor t strReportName, acViewNormal

Or just run your Macro.

Or are you perhaps trying to do something other then what you stated in
your question?

ph*******@gmail .com wrote:

On Sep 11, 5:58 pm, Chuck Grimsby <c_grim...@worl dnet.att.net.in valid>
wrote:

>Install PDF Creator (Freeware) fromhttp://www.pdfforge.or g/products/pdfcreator

This installs a PDF Print Driver onto your computer. Then, just print
to that.

There are a number of options in the program for automating the output,
if you want to use it in a situation where you are running a number of
reports.

phong....@gmai l.com wrote:

>>Hello all,
I was wondering if someone can assist me in outputting 6 reports into
a pdf file? I created a macro that generates the 6 reports and right
now it's saved as a snapshot on my drive. Any ideals or sample will
be greatly appreciated.- Hide quoted text -

- Show quoted text -

Thanks, i was looking for some kind of vb script or some sample of
the vb script.

[John]

Hello Phong.

In addition to the other suggestions you have received there is
another option if you have Access 2007. You can download and install
the Microsoft PDF add-in from the following URL:

http://www.microsoft.com/downloads/d...displaylang=en

This will allow you to save any Access report, form, query, etc. in
PDF form and its free. It works with the other Office 2007
applications too--e.g., Word, Excel.

John