Monday, January 21, 2008

DoCmd.HourGlass Method in MS Access

In MS Access, when a macro action takes a long time to run, you can use DoCmd.HourGlass to change your mouse pointer to an image of an hourglass or any icon that you like, by using the code as below:

DoCmd.HourGlass True

or

DoCmd.HourGlass False

It has the following argument: True/False, or 0/-1.

2 comments:

DrGreg1408 on November 25, 2009 at 7:39 AM said...

You mention that you can use the Hourglass method to show any icon you want, but you don't give any examples or tell how to show any other icon than the hourglass. I'd like to know how to show something other than the hourglass if this can be done.

july on November 25, 2009 at 9:13 AM said...

Hi, for example,
Screen.MousePointer = 1 'Standard Cursor
Screen.MousePointer = 3 ' I Beam
Screen.MousePointer = 7 'Double Arrow Vertical
Screen.MousePointer = 9 'Double Arrow Horizontal
Screen.MousePointer = 11 'HourGlass

 

Get paid for your opinions! Click on the banner above to join Planet Pulse. Its totally free to sign up, and you can earn UNLIMITED. Find out more by visiting PLANET PULSE.
July Code Blog Copyright © 2010 Blogger Template Designed by Bie Blogger Template