Code too quick. Information on form not shown

Question

Hi 

I have av complex form on a Tab. Takes about 10 seconds to update. I want to give the user a hint of that fact. My idea was to open a form giving that information. But the code runs too quickly. The information form opens but there is not enough time to show the information (two sentences). Result is - the Tab form uses 10 seconds to update, then the text on the information form is shown.

Any tips how to solve this?

Select Case Me.Flik0.Value
    Case 1:
        If Me.[Alla tankar underformulär].Form.RecordSource = "" Then
           DoCmd.OpenForm "ProduktionUppdaterarStatus", acNormal
           Me.[Alla tankar underformulär].Form.RecordSource = QRY1
        End If

---

Best // Peter Forss Stockholm and Sigtuna GMT +1.00

Answer 1

I have av complex form on a Tab. Takes about 10 seconds to update. I want to give the user a hint of that fact. My idea was to open a form giving that information. But the code runs too quickly. The information form opens but there is not enough time to show the information (two sentences). Result is - the Tab form uses 10 seconds to update, then the text on the information form is shown.

Any tips how to solve this?

Hi Peter,

Did you try to open a form in Dialog-mode with the "patience" messafe at the start of the action, that is closed at the end of the action?

Just for curiosity, are there other possibilities to reduce the update time by making the form a little simpler? I mean, you could split the complex form in a couple of less complex forms, that are opened when necessary?

Imb.

Answer 2

Hi Peter,

Did you really mean 10 seconds, or 10 minutes? Just curious since 10 seconds doesn't seem a lot to wait for the form to load.

Answer 3

It is 10 sec DB :-)

---

Best // Peter Forss Stockholm and Sigtuna GMT +1.00

Answer 4

I tried to open form in Dialog-mode. It worked fine.

But I wanted to give the user a hint meanwhile the form in the background is updating.

The form is a Status page showing the action taken and action waiting in a brewery. Its complex. I might do it in another way in the future. Today "the Status" checks many conditions and parameters and run many queries.

The form looks like below:

---

Best // Peter Forss Stockholm and Sigtuna GMT +1.00

Answer 5

I tried to open form in Dialog-mode. It worked fine.

But I wanted to give the user a hint meanwhile the form in the background is updating.

The form is a Status page showing the action taken and action waiting in a brewery. Its complex. I might do it in another way in the future. Today "the Status" checks many conditions and parameters and run many queries.

Hi Peter,

I see now that I did not give you the right advice.

It would be better to open a pop-up form with the wait message at the start of the Load event of your complex form. At the end of the Load event the message form is closed again.

Perhaps you can open the message form at the beginning of the Open event. That all depends on what is in the Open or Load events.

Imb.

Answer 6

I tried both Open and Load. Doesn't work as I want.

So Dialog-mode will be the solution.

---

Best // Peter Forss Stockholm and Sigtuna GMT +1.00