Reports to PDF

[Jacinto]

Hello,

I'm looking into printing my Access Database reports to a
pdf file. I have acrobat distiller from Acrobat 5 and
running Access 2000.

Any help would be very much appreciated!

Jacinto

 

[M Skabialka]

When you go to File, Print, choose the Distiller as the printer.

 

[Guest]

Thanks M!

Sorry my question was not very clear. I am intending to do
this on code.

Any help would be appreciated!

 

[Mark Andrews]

You can use our code library "batch Reporting Module" but it only works with
Adobe PDFWriter and win2pdf printer drivers. Adobe PDFWriter 5 should be on
the same cd as Distiller 5.

HTH,
Mark
RPT Software
http://www.rptsoftware.com

 

[M Skabialka]

I was able to do what I need in code using information written by Keri
Hardwick on this web site:

http://www.mvps.org/access/reports/rpt0011.htm

Mich

 

[Mark Andrews]

Note that code if fine for win95/98 for newer operating systems
you will need to control PDFWriter through the registry.

Mark
RPT Software
http://www.rptsoftware.com

 

[DanG]

Mark,
How can the pdf file and path be set using the registry?
Is there sample code somewhere I could look at?

I am looking to do something similar...

Thanks,

Dan

 

[SA]

Dan:

The registry settings are outlined in both Adobe SDK and knowledge base
articles. They operate on HKCU\Software\Adobe\Acrobat PDFWriter.

You should note however, that with Acrobat 6, PDFWriter is no longer
provided so that solution may fail for clients / users that upgrade to that
version of Acrobat.

You might take a look at our PDF and Mail Library for Access which supports
both Acrobat 5 & 6 (as well as other drivers) and can make output as simple
as:

Dim objPDF as New PDFClass
With objPDF
.ReportName = "Your Report"
.OutputFile = "c:\some dir\some file.pdf"
.PDFEngine = 1
.ReportWhere = "[CustomerID] = 1234"
.PrintImage
End With

HTH

 

[Mark Andrews]

There is code floating around to do registry changes however we also try and
sell
a solution so you don't have to worry about the code required. Our batch
reporting
module is very similar to Steve's product. We sell the source code as well.

You could look through old newsgroup posts and probably find some code.
However my advise is to try our product or Steve's product, less time and a
little
money.

Mark
RPT Software
http://www.rptsoftware.com