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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FollowHyperLink to IE or FireFox 2

Status
Not open for further replies.
Apr 23, 2002
39
US
Hello all,

I have a Access DB and want to add code that opens a hyperlink. So far, this works:

Application.FollowHyperlink "http:\\ , True

However, users want an Option Group with either "Internet Explorer" or "FireFox". Depending on what they are doing and the URL they are attempting to access, they need to quickly be able to open the URL with either browser.

We had an APP written in .NET that did this, but the guy who wrote it quit and insisted the company stop using it.

Thanks,
Don in Phoenix
 
Something like this? I just wraped [tt]Shell()[/tt] in a UDF:
Code:
Function OpenWebpage(Earl as String, InFireFox as Boolean) As Double
If InFireFox Then
  OpenWebpage = Shell(""C:\Program Files\Mozilla Firefox\firefox.exe " & Earl)
Else
  OpenWebpage = Shell("C:\Program Files\Internet Explorer\iexplore.exe " & Earl)
End If
End Sub

Hope this helps,
CMP
[small]I know it's URL, but being Friday...[/small]

(GMT-07:00) Mountain Time (US & Canada)
 
<quoting>.. but the guy who wrote it quit and insisted the company stop using it.</quoting>
If in the US, he needs to go back and read the law books just a *little* more. Anything created while under the employement of another entity, person, other organization or institution is the property of said entity. Trust me, the copyright laws in the US are NOT what one would think they are and some hard scrutiny is needed if one thinks the line has been crossed.

And no, VBA/.NET/C/etc code cannot be copyrighted - period, but the application it makes up can be.

Just fyi.

-----------
Regards,
Zack Barresse
 
Thanks CMP, always easier than I think it.

Zack, you are right, but my boss didn't want the hassle, and the app wouldn't be able to be supported. Instead he asked me to build the same functionality into our Access app.
 
Cool beans. I just mentioned it because I've seen a few people get railroaded by false information, and that's just not right.

Good luck to ya though! :)

-----------
Regards,
Zack Barresse
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top