Export report to PDF

  • Thread starter Thread starter Jai
  • Start date Start date
J

Jai

Hello,

I am using Microsoft Access 97 and Adobe acrobat 5.0.
From Access I am generating PDF files of my reports using Adobe distiller
printer driver. The PDF is getting generated but the hyperlinks are not
working.
Does anybody has a solution for this. I don't want to buy any new PDF
converters as I already have Adobe acrobat 5.0.

Thanks in advance,
Jai.
 
Jai:

Acrobat 5's Distiller program will not automatically create Acrobat
hyperlinks from urls contained in a document. The only way to do this with
Acrobat 5 is to open the PDF in Acrobat and choose to locate hyperlinks.

That said, our PDF and Mail Library, PDF Pro Plus edition, will allow you to
automate output of your PDF files from your Access reports and to
automatically locate and add the hyperlinks into the PDF file. Its simple
to use, with code like that shown below. You'll find it on our web.

HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

'--------begin code----------

Dim objPDF As New PDFClass
Dim objMerge As New MergePDFClass
Dim arrMerge() As String
With objPDF
.PDFEngine = 2 'Use Distiller
.ReportName = "Your Report"
.OutputFile = "c:\some dir\some file.pdf"
.PrintImage
End With

With objMerge
.AddWebLinks = True
.MergePDFs "c:\some dir\some file.pdf", arrMerge() 'an empty array not
merging files
End With
 
Back
Top