Re: Export report as PDF

From: Cheryl Fischer (cherylfischer_at_NOSPAMmsn.com)
Date: 03/31/04


Date: Wed, 31 Mar 2004 09:22:47 -0600

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 Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
"SA" <~fake.address@nspm.com> wrote in message
news:eKXmDCzFEHA.2656@TK2MSFTNGP09.phx.gbl...
> 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" <cherylfischer@NOSPAMmsn.com> wrote in message
> news:u0pPlTxFEHA.740@tk2msftngp13.phx.gbl...
> > 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" <anonymous@discussions.microsoft.com> wrote in message
> > news:55F4F811-C6E2-4BF2-9B78-9E62A0008EF2@microsoft.com...
> > > 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
> > 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" <anonymous@discussions.microsoft.com> wrote in message
> > >      news:AB448CDA-CF07-45C7-9F88-B9B7401F9C34@microsoft.com...
> > >      > I need to export reports as PDF files, but I do not know how.
> Can
> > someone
> > >      please help me?
> > >
> > >
> > >
> >
> >
>
>


Relevant Pages

  • Re: Report formatting Disappears on Some Items when Output to PDF in Code
    ... Now use my code to putput your Report to PDF. ... It does print in Snapshot format - all perfectly. ... I set my default settings on my printer (Legal and Landscape were the ...
    (comp.databases.ms-access)
  • Re: Export report as PDF
    ... landscape in design will it output a landscape PDF with PDFWriter (or ... Even if the report is set to landscape in ... Thats' one reason that our PDF and Mail Library for Access provides the ... Google search on PDF drivers to see others. ...
    (microsoft.public.access.externaldata)
  • Re: Report formatting Disappears on Some Items when Output to PDF in Code
    ... Now use my code to putput your Report to PDF. ... I set my default settings on my printer (Legal and Landscape were the ...
    (comp.databases.ms-access)
  • Re: Export to PDF
    ... >built in facility to output PDF files or to set a file ... >target driver you are using the VBA code you can add to ... >Dim objPDF as New PDFClass ... >> I am able to set the report to default to my pdf ...
    (microsoft.public.access.reports)
  • Re: Landscape!!
    ... If I print a PDF it seems to ... pages face up) have a tendency to rotate landscape pages the "wrong" way; ... lot on the printer driver: the original driver for my old DeskJet 820Cse ... rotated landscape pages the wrong way; an updated driver got it right. ...
    (microsoft.public.word.docmanagement)