Disable status bar wording on form during OnTimer event?

[Andrew Fergus]

Is there a way to disable the status bar showing the word "Calculating . . . " every time an OnTimer Event does a requery?

I have a real time clock on a form and I used the following code :

Private Sub Form_Timer()
   DoCmd.Requery "Clock"
End Sub

This refreshes the clock every second (I used a 1000 millisecond setting) to give a real time, I realise this is resource hungry and will scale it back to once a minute for the more heavy duty forms.

However, every time it does the requery, my status bar at the bottom of the screen changes from the value I have set on the control (usually "enter such and such") to "Calculating . . ." and then it reverts back to the control value again. It does this every refresh, i.e once every second. I tried to stop the flashing "Calculating . . ." in the status bar by turning off the Echo in the VB code using the DoCmd.Echo command, but that didn't work and caused other problems.

Are there any suggestions as to how to get this to stop flashing"Calculating . . " without disabling the status bar?

TIA, Andrew.

 

[Gates Is Antichrist]

try http://groups-beta.google.com/group/comp.databases.ms-access/browse_frm/thread/31cadeaaffefd64e/

 

[Andrew Fergus]

Thanks for the pointer. The suggestion:

 "Application.Echo False, ""

was as effective as my docmd.echo (i.e. ineffective) and the other suggestion :

ReturnVal = SysCmd(SYSCMD_SETSTATUS," ")

disabled the status bar - which will be useful when I have to run multiple queries behind the scenes. Thanks for the pointer anyway and I might have to resort to a requery once every 15-30 seconds.
Andrew