By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,155 Members | 2,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,155 IT Pros & Developers. It's quick & easy.

Controlsource or Other Display While Totals Calculating?

P: n/a
Wondering if anyone has any suggestions for this.

Sometimes in the form reports my users run, a data sheet subform on a
main form, with totals in text boxes with calculated controlsources
(=sum(whatever)), the records returned are large. By "large" I mean
that there is a significant lag time before the totals get calculated
and display.

Lag time and what constitutes "large" varies with the user's PC
hardware/configuration.

Has anyone been able to have a successful approach which might display
"Calculating..." or something letting the user know to "hang on a moment
...." in the text boxes while there is that blank space?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
May 2 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Tim Marshall wrote:
Sometimes in the form reports my users run, a data sheet subform on a
main form, with totals in text boxes with calculated controlsources
(=sum(whatever)), the records returned are large


That should be "NUMBERS OF RECORDS RETURNED IS LARGE."

Sorry.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
May 2 '06 #2

P: n/a
Tim Marshall wrote:
Wondering if anyone has any suggestions for this.

Sometimes in the form reports my users run, a data sheet subform on a
main form, with totals in text boxes with calculated controlsources
(=sum(whatever)), the records returned are large. By "large" I mean
that there is a significant lag time before the totals get calculated
and display.

Lag time and what constitutes "large" varies with the user's PC
hardware/configuration.

Has anyone been able to have a successful approach which might display
"Calculating..." or something letting the user know to "hang on a moment
..." in the text boxes while there is that blank space?


That is exactly what I do often by using SourceObject to swap out the
entire subform:

SubformPurchaseReq.SourceObject = "frmSubPurchaseReqStatus"

The replacement subform says simply:

Updating, please wait ...

in large red letters.

An added benefit is for the case where the subform is bound to a local
table. When the subform is swapped out, there is no chance of a
conflict when making changes to the formerly bound table using
recordsets or queries.

James A. Fortune
CD********@FortuneJames.com

May 2 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.