Hperlink to Powerpoint

[damian]

I'm attempting to run a Powerpoint presentation from a hyperlink in Microsoft Access. I've successfully created hyperlinks to other Office files but Powerpoint refuses to advance any slideshow when I link to it in this way.

I used the following code which enables the user to select files from a combo box, click on a button and hey presto!

'Application.FollowHyperlink Me.Combo41, , True, True'

The Powerpoint presentation runs perfectly when I start it from a conventional shortcut.

Any ideas???

 

[Agnostiker]

Because your' using a combo, maybe you have to reference the column the hyperlink is in.

Try this, hope it will help:

Private Sub Combo41_DblClick(Cancel As Integer) 
'or that event you like to use

    FollowHyperlink HyperlinkPart(Me.Combo41.Column(X), acAddress), .....
    ' X will be your column number

End Sub

That function 'HyperlinkPart' you will need if the adress is stored in a HyperlinkField. If it's stored in a TextField, leave it away.


Ciao.

Agnostiker

 

[damian]

Thanks for the reply, but I've successfully created hyperlinks to other office documents.

Why is there a problem with advancing a Powerpoint show when following such a link (I can view the first slide but then it doesn't progress the presentation.)

 

[Agnostiker]

Ooops, sorry!
See me ashamed...
(I really have to built up my english skills!)

And how, if you don't use the 'FollowHyperlink' and launch it from VBA? The same stumbling?

I beg your pardon

Agnostiker

 

[ghudson]

Does your powerpoint file extension end in .PPT or .PPS ?

It has to be saved as a .PPS file if you want the file to auto advance [if the timing is correctly set to auto advance each slide].