Can I keep my progress bar on top?

[option]

Hey guys,

I'm trying to put a progress bar into my database that updates after every pass through a do loop. It works and all, but you don't see it progressing. I'm sending records from a table into an external program, performing scrapes on the data through the external software, and then storing the results back in access. Once the external app is opened, access freezes until the loop/process is complete, in which case my progress meter shows 100% (defeating its purpose). Any ideas as to how to keep focus on my progress meter so the user can watch the process?

 

[Fuse3k]

Try adding this after you change the value of the ProgressBar:

Me.ProgressBar1.Requery

 

[RuralGuy]

Your only viable option may be to make the MainForm invisible while the loop is going.

 

[RuralGuy]

You might also try setting your ProgressBar form as PopUp and then issue some DoEvents in your loop in the MainForm to give the other form some cpu time.

 

[option]

Someone had mentioned to me something called "dual events" that I have been searching on, but I can't find any relevant info. RG, is that what you're getting at?

 

[RuralGuy]

Are you referring to the DoEvents suggestion? If so, DoEvents just relenquishes the cpu to other tasks in Access (such as updating another form). It is described in VBA help.

 

[option]

THAT'S it!!! Thanks a ton!

 

[RuralGuy]

Glad I could help.