Refreshing the Meter

[philbullock1223]

In Access 2010, I've used the status bar SysCmd functions acSysCmdInitMeter, acSysCmdUpdateMeter, and acSysCmdClearStatus. While looping through commands and displaying the status bar, at some point Access seems to lose focus and the status bar stops updating (or freezes) until the job is done. On short processes, it works just fine. I tried adding a repaint with no success.

Has anybody else seen this behavior? And if you have a solution better than repaint (doesn't always work, but unless that's the only one), what is it?

Someone has suggested DoEvents as-in adding "Application.DoEvents()" inside the loop... but I don't understand this. Application.DoEvents() gives me an error and I don't know what it is.

 

[llkhoutx]

I've encountered this issue, but have not found a perfect solkution. I do a control-break to stop th code the a shift-F8 to continue executing the code and the status bar updates. Not perfect, but it works. Maybe some smart guy will oost a better solution.