Hourglass & Status Bar in Access 2007

[ShellWorker]

I'm in the process of converting a bunch of my company's Access 2000 databases to Access 2007.

One thing I've noticed that is going to be a HUGE problem for my users is that the hourglass and status bar do not stay on continuously from start to finish when pressing a command button that runs a macro with a lot of OpenQueries.

Some of my macros have as many as 30 OpenQueries and take as long as 45 minutes to complete. In Access 2000 the hourglass stayed on throughout the process and the status bar appeared while each of the queries was running. In Access 2007 the new circle cursor turns periodically and in between you just see the pointer cursor. So the user has no idea what’s happening. It looks as if his screen is frozen.

I tried turning the hourglass "ON" as the first step of my macro, but that didn't help.

Any ideas?

 

[HiTechCoach]

Not sure how to keep the hourglass visible. I will have to do some testing with 2007.

In cases where the process will take more that a few minutes, I normally use a progress form with either bar and/or a status message that informs the user on what is going on.