Microsoft Web Browser

[EAB1977]

All,

For one of my queries that takes a long time to run, I'd like to be
able to add a aminated GIF to my form to let the user know that the
query is executing behind the scenes. Other ideas, like a progress
bar, aren't feasable due to the fact you can't really get what state
or how far the query has ran.

I have researched this and I've seen where people recommend to use the
Microsoft Web Browser ActiveX control. They also recommend using the
Navigate method.

When I add this to my form, I get WebBrowser6 as a object. When I try
to bring up the Navigate method, I don't see it using Intellesense. Is
there something I am doing wrong? Or do others recommend using some
other method?

I'd like to use this on Form_Load.

 

[Douglas J. Steele]

Intellisense doesn't always work with ActiveX controls.

If Me!WebBrower6.Navigate "path to file" doesn't work, try
Me!WebBrower6.Object.Navigate "path to file"

 

[Jeff Boyce]

Out of curiousity, are you (is your query) trying to load all the records
'behind' the form? If so, why?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[EAB1977]

Jeff,

No, I am not. I use a query in VBA to revtrieve records so later on
(in my code) I can manipulate them in a Excel spreadsheet that
generates graphs.

I have noticed that when the execution line comes to opening the form
with the web browser control, it stops the execution of the code. If I
step through the code, I don't see this behavior happening. I'm using
Access 2007

Here's part of my code within the module:

'This macro needs to run to distingusih HAVI testing from regular
testing
'Macro: macDoFirst
DoCmd.OpenForm "frmProcessing"
DoCmd.RunMacro "macDoFirst"

frmProcessing code:

Option Compare Database

Private Sub Form_Load()
Me.WebBrowser6.Navigate "C:\indicator.gif" 'animated GIF
End Sub

Private Sub WebBrowser6_DownloadComplete()
Me.WebBrowser6.Document.Body.Scroll = "no"
End Sub

I'm not sure why the code stops just after it loads the GIF...puzzling.

 

[Jeff Boyce]

Sorry, no direct experience there... hopefully another newsgroup reader can
shed light.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[EAB1977]

Jeff,

Apon looking at the documentation about the Web Browser ActiveX
control, it appears that the image is in a consistant busy state...at
least that is what I interpurt(sp) as what the documentation states.
It also states that other events fire when the Navigate method is
used. Right now, I haven't had the time nor expereince to dig into
this deeper.

Kinda the dagger for a self-taught VBA coder!

Eric