Display messages

[Guest]

I have a form that calculates and writes/appends to a database. It could
take up to an hour as the data could be very large. I would like to display
what process is running so the user see's that the application has not locked
up.

I have a label that I am setting as each process is run but for some reason
it does not display on the form.

For instance, as the routine which updates the tariff schedule is running,
my label should read "Updating Tariff Schedule", and then when calculating
the duty it would change to "Calculating Tariff Duty". The code is simple.
As I get to the next process I have me.lblProcessLable = "Updating Tariff
Schedule". Then the next process the label changes.

Am I going about this the wrong way?

Any advice is much appreciated!

Thanks so much!

Janis in Minne-SNOW-ta

 

[Guest]

You might want to use the DoEvents function "Yields execution so that the
operating system can process other events" or a Me.Repaint "The Repaint
method completes any pending screen updates for a specified form" placed just
after setting the label caption.

Alternatively i have used the DoCmd.Echo True, "Some message text..." in the
past. This displays a message at the bottom left hand corner of the MS
Access window.

 

[Guest]

Thank you VERY much - will try!!!

Janis

You might want to use the DoEvents function "Yields execution so that the
operating system can process other events" or a Me.Repaint "The Repaint
method completes any pending screen updates for a specified form" placed just
after setting the label caption.

Alternatively i have used the DoCmd.Echo True, "Some message text..." in the
past. This displays a message at the bottom left hand corner of the MS
Access window.