Results 1 to 12 of 12
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    pdf inserted into access report (2003)

    Is it possible to insert a pdf file into an Access report? I have tried and not succeeded - all I get is an icon. In the design mode I can double click on the icon and it opens up the pdf file. In the report all I see is the icon. I may be asking the impossible??

    Thanks,

    itconc

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

    Re: pdf inserted into access report (2003)

    It is possible, but since a report is not interactive, you'll only see the first page of the PDF file. Do it like this:

    - Open the report in design view.
    - Select Insert | Object... or insert an Unbound Object Frame from the Toolbox. A dialog will appear.
    - Click 'Insert from file', then click Browse...
    - Locate the PDF file, then click OK twice.

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pdf inserted into access report (2003)

    I did that and all I get is the unbound object frame with the pdf icon.
    Thanks,

    itconc

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

    Re: pdf inserted into access report (2003)

    Do you have Adobe Reader installed (or the full Adobe Acrobat)? The OLE Class property of the unbound object frame on my PC is Adobe Acrobat 7.0, and the Class property is AcroExch.Document.7. I assume that this requires Adobe Reader or Acrobat to be installed.

  5. #5
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pdf inserted into access report (2003)

    I have Adobe Standard version 6. We all have Adobe reader version 7.

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

    Re: pdf inserted into access report (2003)

    I'm afraid I have no explanation or solution for you. As an alternative, you could put a hyperlink to the .pdf files on a form, so that the users can open it directly from the database.

  7. #7
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pdf inserted into access report (2003)

    Thank you for your help! At least I know I have tried all.
    This forum is such a life saver. Thanks to in you particular Hans, and all the other administrators!

    itconc

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

    Re: pdf inserted into access report (2003)

    I was working on a new PC in the office, and noticed that a PDF file was inserted as a "package" icon on a report. Turned out that Adobe Reader hadn't been installed yet on this PC. Once I installed it, PDF files displayed correctly when inserted in a report. Perhaps you need to reinstall Adobe Reader - a new version has just been released anyway, see <post:=654,093>post 654,093</post:>, so this might be a good opportunity.

  9. #9
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pdf inserted into access report (2003)

    Thanks, Hans. We will try that and let you know about the results.

  10. #10
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pdf inserted into access report (2003)

    We have finally tried this. The new version of Adobe Reader took care of the issue in that we can now see the first page of the report - as you mentioned correctly. Reports are not interactive!!!
    Thanks for your help!

    itconc

  11. #11
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pdf inserted into access report (2003)

    Sorry, Hans - this should have gone to you:
    We have finally tried this. The new version of Adobe Reader took care of the issue in that we can now see the first page of the report - as you mentioned correctly. Reports are not interactive!!!
    Thanks for your help!

    itconc

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

    Re: pdf inserted into access report (2003)

    That's OK - I read all replies anyway, whether they're directed at me or not! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

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