Solved Calculate into inbound textbox (1 Viewer)

[tihmir]

Hi all,
I have subform with query "qrySubform". On the Form footer I have unbound textboxes for my fields,
that have the following expresstions - =Count([field1]) or =Sum([field2]).
Unfortunately, these expressions are very slow to load values into my unbound textboxes.
Do you have any idea how else I can arrange things to calculate the values into my unbound textboxes?

 

[Ranman256]

That IS how you do it.

 

[bob fitz]

Unfortunately, these expressions are very slow to load values into my unbound textboxes.

How slow is slow?

 

[tihmir]

That IS how you do it.

what is your proposal?

How slow is slow?

It is about a few minutes...

 

[bob fitz]

It is about a few minutes...

How many records?

 

[tihmir]

How many records?

11 409

 

[bob fitz]

11 409

Can you post a copy of the db

 

[tihmir]

Can you post a copy of the db

Unfortunately, my base is in Cyrillic and will not be readable

 

[tihmir]

I figured out what the problem is with the very slow calculation of the values into the textboxes.
The problem is that on the main Form I have unbound textbox with name "txtTime", which shows me the current time. On main Form I have event procedure "On Time" with the code:

Private Sub Form_Timer()
    Me.txtTime.Value = Format(Time, "HH:mm:ss")
End Sub

When i delete this procedure everything works fine but otherwise the calculation of values is very slow. Also when trying to type VBA it blocks me.

 

[Minty]

Form timer events should be paused when you are developing, they are a nightmare.

Try changing it to only update every minute and remove the seconds display, or remove it completely, pretty much everyone has a clock showing in windows anyway!

 

[tihmir]

Form timer events should be paused when you are developing, they are a nightmare.

Try changing it to only update every minute and remove the seconds display, or remove it completely, pretty much everyone has a clock showing in windows anyway!

Тhank you all for the answers and help!