Export report as PDF

  • Thread starter Thread starter Guest
  • Start date Start date
The easiest way to do this is locate and download one of the many available
PDF drivers. (I use PDF995 available from: http://www.pdf995.com ) Do a
Google search on PDF drivers to see others.

These drivers install as if they were printers and you can select the PDF
driver when the report is open in Preview by selecting File|Print from the
menu.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Ben said:
I need to export reports as PDF files, but I do not know how. Can someone
Click to expand...
please help me?
 
Ben said:
I need to export reports as PDF files, but I do not know how. Can someone please help me?
Click to expand...
You need to get the PDFdrivers that will allow you to PRINT the report.
After the software is installed, you will see that you have a new
printer, a PDFwriter printer.
In your report you select the PDFwriter and print to it. This will
create the PDF file you want.


Ron
 
Thank you

I do have PDF writer. I was able to save it as PDF in Portrait orientation. But when I tried to save a report to PDF as Landscape, the report does not look right at all. Is there an easy way to fix this, besides click on View and select Rotate View Clockwise in Adobe Reader

Thank you

----- Cheryl Fischer wrote: ----

The easiest way to do this is locate and download one of the many availabl
PDF drivers. (I use PDF995 available from: http://www.pdf995.com ) Do
Google search on PDF drivers to see others

These drivers install as if they were printers and you can select the PD
driver when the report is open in Preview by selecting File|Print from th
menu

-

Cheryl Fischer, MVP Microsoft Acces
Law/Sys Associates, Houston, T


Ben said:
I need to export reports as PDF files, but I do not know how. Can someon
Click to expand...
please help me
 
If the Access report is designed with its Page Setup properties for
landscape, it will be written to a PDF file in landscape. At least that is
how PDF995 does it for me.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Ben said:
Thank you.

I do have PDF writer. I was able to save it as PDF in Portrait
Click to expand...
orientation. But when I tried to save a report to PDF as Landscape, the
report does not look right at all. Is there an easy way to fix this,
besides click on View and select Rotate View Clockwise in Adobe Reader?
 
Cheryl:

From our experience, its not necessarily true that setting the report to
landscape in design will it output a landscape PDF with PDFWriter (or
distiller or other drivers for that matter) when the report printed from a
preview or simply sent to print. Even if the report is set to landscape in
design, unless PDFWriter is set to the be the specific printer for the
report, the report can revert to portrait when its printed from preview and
from time to time when its simply printed out. (its a driver issue.)

Thats' one reason that our PDF and Mail Library for Access provides the
ability to set report orientation and paper size when outputting a pdf from
an Access report as in:

Dim objPDF as New PDFClass
With objPDF
.ReportName = "My Landscape Report"
.OutputFile = "c:\some dir\some file.pdf
.AdvancedRptProp True, 2 'Set to landscape orientation
.PDFEngine = 1 'PDFWriter
.PrintImage
End With

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

Cheryl Fischer said:
If the Access report is designed with its Page Setup properties for
landscape, it will be written to a PDF file in landscape. At least that is
how PDF995 does it for me.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX



orientation. But when I tried to save a report to PDF as Landscape, the
report does not look right at all. Is there an easy way to fix this,
besides click on View and select Rotate View Clockwise in Adobe Reader?
Click to expand...
http://www.pdf995.com )
 
Steve,

Thanks for posting your comments. My suggestion to the original poster was
based on my own experience, which has not produced a failure using the
driver I mentioned.

I will certainly keep your comments in mind for the future (I already own
your product and purchased a 5-seat license for a client about a year ago -
so 'yer preachin' to the choir!).
 
Cheryl

How do I set PDF995 as a default printer by using VBA or something in MS Access

Thank you for your help

Be

----- Cheryl Fischer wrote: ----

If the Access report is designed with its Page Setup properties fo
landscape, it will be written to a PDF file in landscape. At least that i
how PDF995 does it for me

-

Cheryl Fischer, MVP Microsoft Acces
Law/Sys Associates, Houston, T


Ben said:
Thank you
Click to expand...
orientation. But when I tried to save a report to PDF as Landscape, th
report does not look right at all. Is there an easy way to fix this
besides click on View and select Rotate View Clockwise in Adobe Reader
 
Back
Top