How to force followhyperlink to open in firefox?

[gymcshoe via AccessMonster.com]

Using the FollowHyperlink command, how do I force Access to open the link in
Firefox?

So far I have:

Private Sub MyListBox_AfterUpdate()
Application.FollowHyperlink Me!MyListBox.Column(1)
End Sub


Thanks

 

[Graham Mandeno]

Hi gymcshoe

FollowHyperlink will use the default program for the type of data in the
hyperlink, so:

FollowHyperlink "C:\Data\MyReport.doc"
will open MS Word (or the application associated with .doc files)

FollowHyperlink http://www.google.com
will open the default web browser (associated with the hhtp protocol)

If FF is your default web browser, then it will be used. But if another
browser, say IE, is the default, then FF will not be used.

You could use Shell instead:

sBrowser="C:\Program Files\Some Path\FireFox.exe"
Shell sBrowser & " " & Me!MyListBox.Column(1)