Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    ReporttoPDF (Access2003 sp2)

    I have just started to use this function by Stephen Lebans and i find that it creates te PDF file correctly but it leaves an Adobe Reader instance open. Can this be closed or not even opened at all?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ReporttoPDF (Access2003 sp2)

    The function that you use to convert an Access report to a PDF file has the following definition:

    Public Function ConvertReportToPDF( _
    Optional RptName As String = "", _
    Optional SnapshotName As String = "", _
    Optional OutputPDFname As String = "", _
    Optional ShowSaveFileDialog As Boolean = False, _
    Optional StartPDFViewer As Boolean = True, _
    Optional CompressionLevel As Long = 0, _
    Optional PasswordOwner As String = "", _
    Optional PasswordOpen As String = "", _
    Optional PasswordRestrictions As Long = 0, _
    Optional PDFNoFontEmbedding As Long = 0 _
    ) As Boolean

    As you can see it has an optional argument StartPDFViewer that is True by default.
    If you specify True for this argument or omit it, the PDF file will be opened in the application associated with .pdf files (Adobe Reader on your computer).
    If you don't want the PDF file to be opened, you must specify False for the StartPDFViewer argument.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: ReporttoPDF (Access2003 sp2)

    Hi Hans,
    Thanks for your super quick response.
    Sorry for that, i thought i had read and understood what all the arguments meant.

    It works fine thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •