Display messages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janis in Minnesota - 02 Feb 2006 15:31 GMT

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

Reply to this Message

Andrew Tapp - 02 Feb 2006 15:55 GMT

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.

> 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
[quoted text clipped - 17 lines]
>
> Janis in Minne-SNOW-ta :)

Reply to this Message

Janis in Minnesota - 02 Feb 2006 17:01 GMT

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
[quoted text clipped - 26 lines]
> >
> > Janis in Minne-SNOW-ta :)

Reply to this Message