Change the mouse icon

[arunakumari02]

I have to change the mouse icon to hour glass when the code is running in MS-Access. Once it is done it should change back to the arrow.

Any hints on it.

Thanks

 

[DCrake]

DoCmd.Hourglass True

... your code

DoCmd.HourGlass False

 

[missinglinq]

Since Access doesn't wait for Command1 to complete before running Command2 you may have to use DoEvents to allow the code in the middle to complete before turning the HourGlass off.

DoCmd.Hourglass True

'your code here

DoEvents

DoCmd.HourGlass False