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)]

Re: hourglass control during execution of code ?

Per Zlatko Mati?:[color=blue]
>I would like to add some hourglass or a message t[/color]

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

[Zlatko Matic]

Re: hourglass control during execution of code ?

thank you very much :)!

"(Pete Cresswell)" <x@y.z.invali d> je napisao u poruci interesnoj
grupi:od7g71p72 ksbtvt2ddgmsaq4 bril8j210j@4ax. com...[color=blue]
> Per Zlatko Mati?:[color=green]
>>I would like to add some hourglass or a message t[/color]
>
> DoCmd.HourGlass True
> .
> .
> .
> .
> .
> DoCmd.HourGlass False
> --
> PeteCresswell[/color]

[David Lloyd]

Re: hourglass control during execution of code ?

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æ" <zlatko.matic1@ sb.t-com.hr> wrote in message
news:d58rjj$hph $1@ss405.t-com.hr...[color=blue]
> 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[/color]
was[color=blue]
> pushed.
> I would like to add some hourglass or a message that would be present on[/color]
the[color=blue]
> screen while procedure is runing. How to accomplish it ?
>
> Thanks.
>
>[/color]