By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Outputting Reports into PDF file

P: n/a
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.

Sep 11 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a

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.
Sep 11 '07 #2

P: n/a
On Sep 11, 5:58 pm, Chuck Grimsby <c_grim...@worldnet.att.net.invalid>
wrote:
Install PDF Creator (Freeware) fromhttp://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.

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.

Sep 11 '07 #3

P: n/a
<ph*******@gmail.comwrote in message
news:11**********************@e34g2000pro.googlegr oups.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

Sep 11 '07 #4

P: n/a

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

DoCmd.OpenReport 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...@worldnet.att.net.invalid>
wrote:
>Install PDF Creator (Freeware) fromhttp://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.

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.
Sep 12 '07 #5

P: n/a
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

Sep 13 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.