David McAfee
davidmcafee at gmail.com
Thu Feb 16 13:24:42 CST 2012
If have a new user that loves to double/triple click buttons. One procedure takes a few seconds to run. I set the focus to the previous text box and display an hourglass as such: Me.txtSN.SetFocus DoCmd.Hourglass True 'Do a bunch of stuff here DoCmd.Hourglass False I'd like to wrap an IF statement around it such as: If Hourglass =False Me.txtSN.SetFocus DoCmd.Hourglass True 'Do a bunch of stuff here DoCmd.Hourglass False End if Does anyone know of the correct call? I guess I can set a hidden field to 1 and check that if needed, but I'd like to see if I can detect the hourglass first. I've also thought of sending signal out the USB port that will active a solenoid that would send a fly swatter towards the users face, slapping them, but I might get in trouble for that one. Any thoughts? Thanks much, David