HourGlass doesn't display

I'm having a problem with the hourglas not displaying. I have a button on a form that opens another form. The 2nd form is quite large and takes a while to load - so I wan the hourglass to display to let the user know it's busy. I have:

docmd.hourglass true
docmd.openform......
docmd.hourglass false

however - the hourglasss is delayed and doesn't display for quite a few seconds - giving the impression to the user that nothing is happening.

Any ideas?
LVL 5
cekmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BrianWrenCommented:
docmd.hourglass true
DoEvents
docmd.openform......
docmd.hourglass false
DoEvents
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cekmanAuthor Commented:
I could have swore that I tried that before. It seems to help - but the hourglass isn't solid. It flashes. This may be enough of a help though. I'll try it a while....

Thanks
CEKMAN
0
phil2freeCommented:
cekman,

Could you try turning off echo and turning it back on after the form is loaded, this should help with the flashing:

docmd.Hourglass true
doevents
docmd.echo false
docmd.openform blah
docmd.echo true
docmd.hourglass false

Error handling is a must though.  If something goes wrong while echo is off, then you won't even know it.

Phil
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

asedevCommented:
try this:

'display the hour glass
Screen.MousePointer = 11


'reset to normal (default) mouse pointer
Screen.MousePointer = 0

i recommend using a good error handling cause the cursor will stay in "hourglass" mode (only in access) until it gets reset!

alexander
0
cekmanAuthor Commented:
Thanks to everyone who commented! Nothing seemed to work exactly the way I wanted it to. But now I'm thinking that the flashing occurs because the form I'm opening is doing a lot of processing in the load/open routines. Therefore - it gets past the docmd.openform line - and turns off the hourglass - but it has a bunch more 'processing' to do before the form is actually displayed.

I tried the screen.mouse method - but I'm worried about it getting 'stuck' on  - and it didn't help with the flashing.

I'll try a couple of more things - but I'm a 'little' better than before.

CEKMAN
0
BrianWrenCommented:
Try putting

DoCmd.HourGlass True

as the first line of the Form_Open event, and

DoCmd.HourGlass False

as the last line of both the Load and Close events...

Perhaps the form is gaining control of the cursor shape, and so you would make the form agree with what had been previously set.

Brian
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.