hourglass control during execution of code ?

[Zlatko Matiæ]

I have a procedure that takes certain time to finish. It is triggered by
pushing botton, but a user can't see whether the procedure started or not,
because Access starts showing hourglass cca 20 seconds after the button was
pushed.
I would like to add some hourglass or a message that would be present on the
screen while procedure is runing. How to accomplish it ?

Thanks.

[(Pete Cresswell)]

Per Zlatko Mati?:

I would like to add some hourglass or a message t

DoCmd.HourGlass True
..
..
..
..
..
DoCmd.HourGlass False
--
PeteCresswell

[Zlatko Matic]

thank you very much :)!

"(Pete Cresswell)" <[e-mail]> je napisao u poruci interesnoj
grupi:od********************************@4ax.com.. .

Per Zlatko Mati?:

I would like to add some hourglass or a message t

DoCmd.HourGlass True
.
.
.
.
.
DoCmd.HourGlass False
--
PeteCresswell

[David Lloyd]

Zlatko:

You will also want to make sure that you turn off the hourglass in any error
handling in your code. If you do not do this and your code encounters an
error before in gets to the line where you turn off the hourglass, the
hourglass will remain visible.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Zlatko Matiæ" <zl***********@sb.t-com.hr> wrote in message
news:d5**********@ss405.t-com.hr...

I have a procedure that takes certain time to finish. It is triggered by
pushing botton, but a user can't see whether the procedure started or not,
because Access starts showing hourglass cca 20 seconds after the button was pushed.
I would like to add some hourglass or a message that would be present on the screen while procedure is runing. How to accomplish it ?

Thanks.