Things freeze up while recordset processes

[LonnieJohnson]

I have form that runs a process using DAO recordsets. I have built a progress bar on the form. This progress bar has worked with other recordset processing. This particular process (updates) takes a long time and freezes up the screen. I don't see the results of the progress bar until it's done.

Can anyone give me some advice as to how I can see the process while the updates are being made?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[RoyVidar]

I'd say not to update the progress bar per each iteration, but, at some intervals:

[tt]if mycounter mod 100 = 0 then
' update progress bar
DoEvents
end if[/tt]

Be aware that when using DoEvents, the system will process other events also (such as buttons/menus that are clicked in the mean time), so you'll probably need to disable such possibilities while the process goes on.

Roy-Vidar

 

[LonnieJohnson]

Thanks.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[LonnieJohnson]

This was actually resolved by a suggestion to use Me.Repaint with each iteration of the progress bar's increment.

Now I have another problem with it. When I go to another program such as word or I E Explorer and go back to Access the screen is frozen at the point where I left and can not see the updates.

Any suggestions as to why and what I can do to rectify it?


ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[LonnieJohnson]

No need. I was using Me.Repaint instead of DoEvents. Actually I needed both. I'm ok now.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!