Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access form - hyperlink - open powerpoint show?

Status
Not open for further replies.

Donkeygirl

Technical User
Nov 30, 2000
52
US
I created a powerpoint show, which acts as a help file to an Access application. When you open the app, there is a menu, and a help hyperlink at the bottom. It is linked to the power point pps file.
I saved the ppt as a pps, and when I did, I had set the show to open/run in full window. When I double click the pps in its directory, it opens in full window.
When I use the hyperlink in the Access app, it opens in a powerpoint window, showing the ugly powerpoint filename, a toolbar with address and such. I dont want all of that.
How can I get the hyperlink to open the pps the right way?
Please help. I am supposed to present this to my boss.
Thanks.


Donkeygirl,
Kickin' the crap out of Access
 
Instead of using a hyperlink, use the following code attached to a command button:

Private Sub SomeButtonName_Click()

Dim oApp As Object

Set oApp = CreateObject("Powerpoint.Application")
oApp.Visible = True
oApp.Presentations.Open FileName:="Full path to yr helpfile"

End Sub

Then PPT opens in its own window.
 
wooohooo Thanks! Donkeygirl,
Kickin' the crap out of Access
 
spoke too soon, lol. Now it opens right, but on everyslide I have an image (exit) which is for the user to be able to leave it, putting them back at the application. Problem is when they click it, the show closes, but the powerpoint shell is left up.
Can that be set to close too?
I would love to use the macro recorder, but wonder if it would run through closing it
haha. Donkeygirl,
Kickin' the crap out of Access
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top