message to wait

[samotek via AccessMonster.com]

is there any simple code to show some figure as sandwatch or something while
my main code is running?

 

[David C. Holley]

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.

 

[Lance McGonigal]

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.

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.

 

[Daryl S]

By sandwatch, if you mean the hourglass, then you can turn that on before
your code runs and off when it is done:

DoCmd.Hourglass = True 'turn cursor into hourglass
DoCmd.Hourglass = False 'turn cursor back to normal