Web Browser on Access Form 1

[hc98br]

Hi, I'm trying to embed a web browser into a form in access, the basic priciples have worked, I've added a "Microsoft Web Browser" active x control, called it ie and used the following code to load a page:

ie.Naviagate "[URL unfurl="true"]http://www.msn.com"[/URL]

All good, but I want to know when the page has loaded. I've checked the readystate property, starts at 1, when the page is loaded is 4 - great - but if it loop until 4, Access just locks up, doesn't even load the page!

Heres my code:

ie.Naviagate "[URL unfurl="true"]http://www.msn.com"[/URL]
While ie.ReadyState <> 4: Wend
MsgBox "Loaded!"

BTW, I'm using Access 2007 in Vista.


Any help would be most appreciated - thanks,


Ben.

http://www.ben-robinson.com

 

[PHV]

You may try this:
While ie.ReadyState <> 4
DoEvents
Wend

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hc98br]

Thanks for your response, unfortunately - same - instant lockup!?!

http://www.ben-robinson.com

 

[JoeAtWork]

It's been a while since I've used the WebBrowser control. However, I suspect you should use an event of the control to detect when the page has loaded. From 2 minutes of research, I've come up with the NavigateComplete2 event:

http://msdn2.microsoft.com/en-us/library/aa768334.aspx

 

[hc98br]

Many thanks - that forced me to look harder at that, I had come dangerously close to it - but hadn't quite understood (not really done very much vba stuff!!)

As a result I found the drop downs at the top of the vb editor, which showed me all the available event - in actual fact, I found DocumentComplete worked better!


Cheers


Ben.

http://www.ben-robinson.com