How do I output an Access report as PowerPoint slides?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to run a report in Access but have the output as PowerPoint
slides. I have managed to print the report as jpg files and then
programatically add them to a PowerPoint presentation, but this is cumbersone
and requires me to buy the software that outputs the report to jpg files.
 
There is a detailed article and a couple of KB articles on the MS site
dealing with publishing reports to Snapshot format where the reports
will be updated on a regular basis.


Less complex, would be to embedd the Snapshot ActiveX control, one on
each Slide of your presentation. Setup each control to point to the
propert page of your report.


Another alernative would be to use the ReportUtilities on my site to
publish your Report to a series of Enhanced Metafiles(EMF's), one for
each page of your report. The result is the same as exporting to
Snapshot format. EMF's are directly insertable onto your Slide and are
fully scaleable/resolution independant. You could automate the process
completely with a bit of VBA code.
http://www.lebans.com/ReportUtilities.htm

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Adam M said:
I would like to run a report in Access but have the output as PowerPoint
slides. I have managed to print the report as jpg files and then
programatically add them to a PowerPoint presentation, but this is cumbersone
and requires me to buy the software that outputs the report to jpg
Click to expand...
files.
 
Thanks for the suggestions. I really appreciate your help.

At first I did go down the road of embedding the Snapshot ActiveX control on
the PowerPoint slides, but couldn't find the way to change the zoom property
of the report - so I gave up. Would you be able to point me in the right
direction for being able to maniplulate the control's properties please?
 
Hey Stephen,
I really appreciate your ReportUtilities. I'm using with Access03 on WinXP
SP2. I've noticed that saving as a .wmf seems to yield consistently unusable
files. They will not open, i.e. MSpaint will grind but never display. I
have tried saving .wmf with at least one other application and it displayed
fine. Any thoughts?

Again, appreciate your help.
 
What I ended up doing was printing the report to PDF, using Acrobat Standard
6.0 to convert each page of the PDF into a jpeg file and then inserting each
jpeg image into a new PowerPoint slide. Of course I had to do a bit of
searching through the Acrobat documentation to find the functions I needed.
 
Back
Top