Avatar of BruceYounggreen
BruceYounggreen

asked on 

How do I open a Firefox browser window, and only a Firefox browser window, from within Access 2003 using VBA?

My company has a web page that not only works best, but on some platforms works only, with Firefox. My access 2003 project needs to access that web page but the code I'm using opens Microsoft IE by default. How do I access that page with Firefox, no matter what default browser is set on any given PC? It needs to be a user-interactive browser page, not just data retrieval from the web page, so just opening a browser window is all I need.

Code:
Dim urlData as String
Dim urlHTTP as String
Dim DataList as String
Dim browser as SHDocVw.InternetExplorer        'This is probably where I need to start changing my code?
Dim objVph, objBrowserPage as DataObject
...
DataList = {search term... calculated earlier}
Set browser = New SHDocVw.InternetExplorer
urlData = "http://.../processRequest?HTMLVersion=5.0&loc=en_US&tracknum=" & DataList
browser.navigate (urlData)
browser.resizable = True
browser.Visible = True
...
Microsoft AccessWeb Browsers

Avatar of undefined
Last Comment
Scott McDaniel (EE MVE )
SOLUTION
Avatar of Lucas
Lucas
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo