Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150

    Unanswered: Access Report to PDF

    Is there a way to easily export an Access Report to PDF. I know there are PDF printers I can use but I want to change the file name programatically and then attach it to an email without any user intervention.

    Does anyone know of a ActiveX control, Access Add-on or something similar?

    Thanks
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    sorry not the reply

    just for me to be notified when there is an answer

    i have the same query
    qha_vn

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    the joy of PDF is that the PDFreader is free so anyone can read your reports.

    ...the joy of SNP is that the SNPreader is free so anyone can read your reports AND access handles SNP.

    A comes with SNP capability. Non-A folk can get a reader at:
    www.microsoft.com/accessdev/prodinfo/snapdl.htm



    izy

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    ooops, forgot to mention that SNP is faster & smaller too! izy

  5. #5
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    also pdf csnnot be read as an ole object with in an access object as jpegs, bmps and the like

    we have an access imaging front end and just shell to acrobat reader

  6. #6
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    Thank You for your replies.

    The reason I want to use PDF instead of SNP is because Acrobat Reader is almost standard nowadays whereas SNP is not. I have developed applications in VB.NET using Crystal Reports and exporting them as PDF. All our clients are used to receiving PDF Files from us.

    I need to do this project in Access so that the user can work with the tables and write their own queries.

    I Guess the only other solution is to add a Crystal Report Viewer into Access and exporting the file that way. A bit more code but what the heck.

    I just thought their would be a simpler solution.
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  7. #7
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    do not get discouraged about pdf - I shell out to it from access to retrieve images, whose paths are stored in access.
    It does the job

Posting Permissions

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