Hide the Hourglass Icon while it's running

[noboffinme]

Hi

I need to run a couple of small procedures to update numeric values on a form.

I don't want the users to see a flicker of an Hourglass while it does this.

I've checked on some syntax like the below, but the Icons keep appearing.

Here's a code example;

Private Sub Question_Click()
DoCmd.Hourglass False
Forms!frm_main.Question_No = Me.Question_No
Forms!frm_main.main_question_id = Me.Question_ID

Here are some examples I have found;

DoCmd.HourGlass False

DoCmd.HourGlass(0)

I still see a flicker of the Hourglass as it runs though. & I need it to stay as a the normal cursor icon.

 

[ghudson]

IMO: The hour glass lets the user know that the system is busy processing and also prevents the user from clicking anything. Displaying the normal mouse pointer in your situation gives the false illusion that the user is free to continue and click on something in your form.

 

[Trevor G]

I agree that you should use the hour glass, but see if the following helps you, perhaps you could display a label stating something is happening before it is safe to continue.

Look at this procedure and reverse the hourglass, it is using the echo command

Public Sub EchoOff()

' Open the Employees form minimized.
Application.Echo False
DoCmd.Hourglass True
DoCmd.OpenForm "Employees", acNormal
DoCmd.Minimize
Application.Echo True
DoCmd.Hourglass False

End Sub

 

[ghudson]

I on purposely did not mention the Echo method. If you use it, ensure you have the Application.Echo True line in the exit event of your error trapping. If you do not and the user experiences a runtime error, their screen will be frozen and the user will have to kill [ctrl alt del] the database to close it.

Echo Method [Access 2003 VBA Language Reference]

 

[boblarson]

Sometimes you can't avoid the hourglass because it can be a WINDOWS generated one. Just thought I'd mention that.

 

[noboffinme]

Thanks to all for your input,

I've tried this code but I still get the hourglass & I did suspect that it's a Windows thing (as boblarson mentioned) that is more difficult to turn off.

As this is a 'nice to have' feature only, I'll try to deal with it another way.

This hourglass was only appearing for millisecond so I thought it would be something the user didn't need to see while the updating occurred. Cheers