Quit Powerpoint While returning to Access Database

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

Guest

I can open a powerpoint from Access database through hyperlinks. At the end
of the presentation, I have another hyperlinks that takes me back to the
database. I would like to quit powerpoint when I return to the database. Is
there a VBA script that I can use that would return me to access database and
at the same time quit powerpoint? Any help would be greatly appreciated.

Thanks
 
You do not need VBA. A simple Action Setting (close show) on an object can
close the PowerPoint presentation. If you have saved the presentation as a
PowerPoint Show (pps extension) then the Access database will appear when
the presentation closes over it.

Note however that neither Action settings nor VBA work when using the
viewer.

--
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
..
 
You do not need VBA. A simple Action Setting (close show) on an object can
close the PowerPoint presentation. If you have saved the presentation as a
PowerPoint Show (pps extension) then the Access database will appear when
the presentation closes over it.

Note however that neither Action settings nor VBA work when using the
viewer.
Click to expand...

Dude. What've you fed your poor viewer? ;-)

Action settings that link to other files are a problem, but the basics seem to
work, including End Show.
 
Hi Bill,
Thanks for the quick response. I tried your suggestion but powerpoint does
not quit completely. It does take me back to Access. When I checked the
Action setting it was not retained by Powerpoint even though I saved it.
I will give you a little background of what I am trying to accomplish. I
developed an Access database for my department and I also created a user
guide in powerpoint. When users are in Access they can click a link and go
to powerpoint. When they are done, they can come back to Access. So I would
like to quit powerpoint completely when they return to Access. I thougth a
VBA script would complish this.
I hope I have given you enough information to understand my situation and be
able to help.

Thanks.
 
OK, now I've gotta check my home system out.

Action settings work on viewer here from work, but they were ignored from
home. Hmmm. I'll need to check this out now.

Bill D.
 
Rename your .PPT to .PPS and give the user a button in the PPT/PPS with an End
Show action setting.

ShellExecute the PPS and you should be good to go.
 
Hi Steve,
Thanks for the information. I made the changes you suggested. I however,
do not know how to ShellExecute PPS. I will appreciate it If you can tell me
how to do that.

Thanks,
 
Hi Steve,
Thanks for the information. I made the changes you suggested. I however,
do not know how to ShellExecute PPS. I will appreciate it If you can tell me
how to do that.
Click to expand...

To keep it simple, try launching the PPS the same way as you were previously
launching the PPT. That may be all you need to worry about.
 
Back
Top