how can i convert a report in access 97 to powerpoint slide

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

Guest

I have been struggling to get a access report exported into a powerpoint
slide properly. the obvious ways have not transferred the data completely
nor does it look like the report. Is there some software to use or a
download that will allow me to export a report to powerpoint? As of now the
only way i can get the report to look the same in powerpoint as it does in
access 97 is to do a print screen and crop the edges then paste it to a slide
this results in lots of steps and huge slide sizes 87kb per.. Looking for
any suggestions !! :))
 
The most elegant way would be use COM to create a slide presentation from
Access. This takes a lot of coding, but it looks good. Second best would be
to export your report to a snapshot view file and cut and paste from there.
 
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 abit 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.
 
Back
Top