Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Export Report to PDF Format (2K2)

    Is there a process by which I can convert an Access report to the PDF format?
    I would greatly appreciate any feedback in response to this question.
    Easy Access

  2. #2
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export Report to PDF Format (2K2)

    I think you need to get an Adobe Distiller type of product so that you can 'print' to a PDF format. There may be some shareware products out there. I had bought one call Nitro PDF for about $50 a while back. Now I see it advertised for $100.

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

    Re: Export Report to PDF Format (2K2)

    If you already have a convert-to-PDF application, you can probably print a report to the PDF "printer".

    If you don't, see Stephen Lebans' ReportToPDF.

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

    Re: Export Report to PDF Format (2K2)

    Could you use this instead of PDF995?

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

    Re: Export Report to PDF Format (2K2)

    I haven't tried it myself. If you do, please report the results.

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Export Report to PDF Format (2K2)

    Patt

    I have just been trying out Bull Zip that I found in the "Software Finds and Wants" forum. This is free and has no advertising.

    Configuring for automatic saving is not as straightforward as with PDF995 as you need to edit a settings file, but it works OK.
    Regards
    John



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

    Re: Export Report to PDF Format (2K2)

    Thanks John I will look into that. btw, where do you find "Software Finds and Wants"?

    When you say "you need to edit a settings file", you only have to do that once don't you?

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

    Re: Export Report to PDF Format (2K2)

    Software Finds and Wants is a forum on Woody's Lounge. You can get there from the Main Index.

  9. #9
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Export Report to PDF Format (2K2)

    Yes you only have to edit the settings file once.

    For a default installation you do not have to edit it all, but if you want files to be automatically saved without being asked for a filename etc, you need to edit the setings.
    Regards
    John



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

    Re: Export Report to PDF Format (2K2)

    Thanks Hans and John

  11. #11
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Export Report to PDF Format (2K2)

    Thanks to all for the responses you gave. I have downloaded Stephen Lebans' Report to PDF Function and it works great.

    I would like to know if anyone is willing to assist me with the following process using the Convert to PDF function from Stephen Lebans
    Easy Access

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

    Re: Export Report to PDF Format (2K2)

    Stephen Lebans' ConvertReportToPDF function lets you specify the path and filename of the PDF file, so 2-4 are easy.
    For 5a-c, search this forum for Attachments.Add, you'll find examples of creating an e-mail with an attachment.

  13. #13
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Export Report to PDF Format (2K2)

    Which part of the function do I attached to the command button on the toolbar to initiate the conversion on the report I have open?
    Easy Access

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

    Re: Export Report to PDF Format (2K2)

    Create a new module.
    Place the following code into it:

    Function ConvertActiveReport()
    On Error GoTo ErrHandler
    ConvertReportToPDF RptName:=Screen.ActiveReport.Name, _
    OutputPDFname:="yourpathandnamehere", _
    StartPDFViewer:=False
    Exit Function
    ErrHandler:
    MsgBox Err.Description, vbExclamation
    End Function

    Display your report toolbar.
    Select Tools | Customize...
    Right-click the Convert to PDF button.
    Select Properties from the popup menu.
    Enter the following expression in the On Action property:

    =ConvertActiveReport()

    OK your way out.

  15. #15
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export Report to PDF Format (2K2)

    Hans,

    I am trying this out and struggle to see the on action event?

    Where is this =ConvertActiveReport() supposed to go? On the form button or int he report? Sorry for being thick
    Best Regards,

    Luke

Page 1 of 2 12 LastLast

Posting Permissions

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