Multiple page Access Report on one Slide?

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

Guest

I have a multi-page Access report (as a .snp file) linked on a single
PowerPoint Slide (using Active-X control). When showing the presentation, the
slide shows the reports first page only. How can I get the presentation to
change the pages of the report before going on to the next slide? I only have
one slide available to show this report so multiple slides is not an option.
Is there some special setting I am missing? Can this be done in code to
maybe trap the next slide event and cancel it until the report is on the last
page?
I can't find an answer to this problem anywhere.
thanks.
 
Have you tried setting the Action Settings to Object Action? I don't have a
..snp file to try it, but you should have an option for Open and/or Edit. If
you set the action setting, you should be able to click on it and activate
the contents of the object.
 
What I would probably do is save out the pages of the report to graphics
files and insert the graphics as "pages". Then by using some clever trigger
animations, you can flip through the pages on a single slide.

Just out of curiosity, why does all this have to be on a single slide? Is
there a significant difference between 20 pages of reports on 1 slide and 20
slides of single page reports?

--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..
 
The presentation is shown during a bi-monthly leadership meeting to the
"higher-ups". Each shop is responsible for certain information on a slide in
the presentation. Currently, a report is generated in Access containing the
information to be shown on the slide. Each person in charge of their shops
slide has to manually update the information on their slide based upon the
information in the report. The slides are formatted so multiple pages of data
from the report (which can vary in length) can fit onto one slide.
The report also cannot be changed.
I was trying to find a way to cut down on the time it takes each of these
shops to update this slideshow to where they just export their report to a
specified location and overwrite the previous linked .snp (or other) file
hence updating their slide.

Currently I can click twice on the report on the slide and use the arrow
keys to navigate through the pages. Then I have to click off of the report in
order to proceed to the next slide. I would like to make it so no matter if
the presenter uses the mouse or the enter/space keys, they will be forced
through the reports pages before the next slide can be shown.

I hope this helps to better clarify what it is I would like to be able to
do and why other, simpler methods will not work for me. I also thank you for
your assistance.
 
Back
Top