Access Report in Powerpoint (2000/SR1)

Topic

New Reply

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.

Reply | Quote

Replies

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)

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote