Adding a Status indicator or hour Glass

[purceld2]

Hi,

Is there some way where you can indicate to the user that code is being processed i.e an Hour glass or status bar.

Thank you in advance

 

[Rabbie]

use

DoCmd.Hourglass True to turn the hourglass on

and
DoCmd.Hourglass False to turn it off

 

[gemma-the-husky]

if you know how long something will take, and you can monitor it

eg you have 80 items ot process, and you are doing these one at a time

then you can use the dotted progress bar at the bottom left of the screen

look at help on SysCmd object

 

[gemma-the-husky]

if you know how long something will take, then you can monitor it with the status bar

eg you have 80 items to process, and you are doing these one at a time, then you can use the dotted progress bar at the bottom left of the screen

look at help on SysCmd object

----------
please note that this wont work if you are just running a query that takes a long time - it works if you are running code in a loop, so that yuo can modify the status bar as the loop iterations increase