You can create a form that is displayed when the code starts executing and
which is then hidden when its finished. At certain points throughout the
code you can update your users by adding a label to the form whose caption
you then update as in..

[Forms]![frmAdvisory]![lblAdvisoryText].Caption "Working on Step (2) of
(5)..."
[Forms]![frmAdvisory].Repaint

Calling the .Repaint method of the form is neccessary to show the new
caption.

"samotek via AccessMonster.com" <u15330@uwe> wrote in message
news:a660fee377164@uwe...
> is there any simple code to show some figure as sandwatch or something
> while
> my main code is running?
>
> --
> Message posted via http://www.accessmonster.com
>

I use a table similar to the windows log and show it on my menu. When
code starts, stops or err I make an entry. I have a timer on the form
that refreshes every 5 sec. Works great for batch jobs and basic
functions.

"David C. Holley" <David.C.Holley> wrote:
> You can create a form that is displayed when the code starts executing
> and
> which is then hidden when its finished. At certain points throughout
> the
> code you can update your users by adding a label to the form whose
> caption
> you then update as in..
>
> [Forms]![frmAdvisory]![lblAdvisoryText].Caption "Working on Step (2)
> of
> (5)..."
> [Forms]![frmAdvisory].Repaint
>
> Calling the .Repaint method of the form is neccessary to show the new
> caption.
>
> "samotek via AccessMonster.com" <u15330@uwe> wrote in message
> news:a660fee377164@uwe...
> > is there any simple code to show some figure as sandwatch or
> > something
> > while
> > my main code is running?
> >
> > --
> > Message posted via http://www.accessmonster.com
> >
>
>
>