Browser window inside Access form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a tabular form in which a command button opens a web page on the
Internet (not my site) based on the record that is active and opens an Access
form.

Can I open the form with the Internet Explorer window appearing as something
like a subform? There won't be any linked child/master fields, just a window
on the form from which the user can peruse information.

It it's possible, how?

Thanks,
Roxie Aho
roxiea at usinternet.com
 
Roxie Aho said:
I have a tabular form in which a command button opens a web page on
the Internet (not my site) based on the record that is active and
opens an Access form.

Can I open the form with the Internet Explorer window appearing as
something like a subform? There won't be any linked child/master
fields, just a window on the form from which the user can peruse
information.

It it's possible, how?

Thanks,
Roxie Aho
roxiea at usinternet.com
Click to expand...

There's a Microsoft Web Browser ActiveX control that you can add to your
form. You'll find it if you click the "More Controls..." button in the
control toolbox in form design view, or by clicking menu items Insert ->
ActiveX Control...

I haven't done much with this control but test it out. It has a
Navigate method -- and maybe a "Navigate2" method, IIRC -- that you can
use to make it display a particular URL. You should be able to find out
a lot more about it by googling.
 
Duffey said:
Roxie,

Can you tell me what VBA code you use to make the controil work? Thanks!

Mike
Click to expand...

I named the Microsoft Web Browser myBrowser. In the On Open event for the
form, I used this code:

Dim objIE As SHDocVw.InternetExplorer
Dim strURL As String
strURL = "http://finance.yahoo.com/q/bs?s=" & Me.Ticker
Set objIE = Me.myBrowser.Object
objIE.Navigate strURL

If you mean the code to open the web page in my original message, the code
is different. Post back and I'll send it.

Hope this helps.
Roxie Aho
roxiea at usinternet.com
 
Roxio,

I have tried and tried to get SctiveX to work with my Access 2003, but I jus
can't. I tried to put a MapPoint and a Web Browser control in there and it
just does nothing. I have downloaded a sample database that successfully uses
a MapPoint control, but I seem to be unable to write either myself. If you
have ANY suggestions for me, I would be indebted to you. Thanks.
 
Duffey said:
Roxio,

I have tried and tried to get SctiveX to work with my Access 2003, but I jus
can't. I tried to put a MapPoint and a Web Browser control in there and it
just does nothing. I have downloaded a sample database that successfully uses
a MapPoint control, but I seem to be unable to write either myself. If you
have ANY suggestions for me, I would be indebted to you. Thanks.
Click to expand...
Do you have a reference to Microsoft Internet Controls (shdocvw.dll)?

I doubt that I'll be in your debt. My knowledge is pretty sketchy.

Roxie Aho
roxiea at usinternet.com
 
Back
Top