Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Access Report in Powerpoint (2000/SR1)

    I have a report that I have created in Access that I want to paste onto a Powerpoint slide. How do I do that? Thanks.

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

    Re: Access Report in Powerpoint (2000/SR1)

    Why a report? A report is page-oriented, and probably wouldn't fit comfortably on a Powerpoint slide. I don't think there is a standard way of doing this. Creating a screenshot and pasting that as a picture might be the easiest way.
    (Perhaps exporting the report to a snapshot file and inserting that on a slide will work; I haven't tried that)

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Access Report in Powerpoint (2000/SR1)

    Hi Hans,

    I figured that I would create a snapshot and then just insert it onto the slide but that didn't work out. It doesn't fit very well.

    I wanted to use a report, because I can format it and group things the way that I want. The other thing that I can do is to just cut and paste the query that the report is based on, onto the slide but it just doesn't look as nice.

    I thought it would be something real easy to do but I always seem to get fooled. Thansk for the help.

  4. #4
    Lounger
    Join Date
    Jan 2003
    Location
    Herndon, Virginia, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Report in Powerpoint (2000/SR1)

    This is a problem I've been wrestling with for a while and there isn't really any good answer. We've tried snapshot, but it doesn't work well, as you've found out. Acrobat, unfortunately is worse -- it can be inserted as an object you can double-click to open, but can't be viewed directly. Taking screenshots and pasting the images in works, but it's a pain if you have a lot of pages, and it frequently doesn't look as good. Copying the query results into Excel and then copying them from there into PowerPoint also works, but the formatting isn't as nice and/or takes a while to prepare.

    What we've ended up doing in one case is coding (via automation) moving the data into Excel, formatting it there (especially making charts) and then pasting it into PowerPoint. This required a lot of effort, but was necessary for the project. Depending on how much this will get used, it might be worthwhile to look into automation.

    Brent

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Report in Powerpoint (2000/SR1)

    In a similar case to this when having to generate monthly reports in PowerPoint, we used MSQuery to get the data into Excel and then linked the Excel tables/graphs into PowerPoint. This worked quite well. We also used code in PowerPoint to break the links to Excel so that the presentation could be opened without it asking about the links.

    HTH

    Peter

  6. #6
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Access Report in Powerpoint (2000/SR1)

    I stumble upon an answer to this and thought that somebody else might benefit. It isn't elegant but it works.

    I found that if I save the report as a Snapshot file, then while it is open and sized, by zooming, to fit the screen, you can insert it onto a PP slide. Go to Insert, Object then click "Create from File". This will bring up a browse window, find you file and then click OK. For some reason, if it isn't open, you only get part of the page, but if the whole thing is showing, it will put the whole item on the slide. It also has a border but if you use the cropping tool, you can get rid of that and then re-size it to fit your slide. Hope this helps somebody else. Thanks.

Posting Permissions

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