DoCmd.Hourglass (Access)

The Hourglass method carries out the Hourglass action in Visual Basic.

You can use the Hourglass method to change the mouse pointer to an image of an hourglass (or another icon you've chosen) while a procedure is running. This method can provide a visual indication that the procedure is running. This is especially useful when a procedure takes a long time to run. You often use this method if you've turned echo off by using the Echo method. When echo is off, Microsoft Access suspends screen updates until the macro is finished. Access automatically resets the HourglassOn argument to False when the procedure finishes running.

Hourglass (HourglassOn)

HourglassOn: Use True (1) to display the hourglass icon (or another icon you've chosen). Use False (0) to display the normal mouse pointer.

DoCmd.Hourglass HourglassOn:=True