Multiple page Access Report on one Slide?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scoobypup - 30 Mar 2007 18:42 GMT

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.

Reply to this Message

PPTMagician - 31 Mar 2007 03:20 GMT

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.

Signature

Thanks,
Glenna Shaw
Microsoft PowerPoint MVP Team
http://www.pptmagic.com

> 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
[quoted text clipped - 6 lines]
> I can't find an answer to this problem anywhere.
> thanks.

Reply to this Message

Bill Dilworth - 31 Mar 2007 05:14 GMT

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?

Signature

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
.

> Have you tried setting the Action Settings to Object Action? I don't have
> a
[quoted text clipped - 18 lines]
>> I can't find an answer to this problem anywhere.
>> thanks.

Reply to this Message

Scoobypup - 31 Mar 2007 06:56 GMT

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.

Reply to this Message