473,327 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Controlsource or Other Display While Totals Calculating?

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
2 2269
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: The Bit Bandit | last post by:
Hopefully someone can help me create a query that I'm having some trouble with. I have three tables: invoices, invoicedetails, invoicepayments The fields are: invoices -------- InvoiceNo
3
by: Shelli Carol | last post by:
Good day, I have: 1) A table with numbered fields (1, 2, 3, etc.) 2) A form text box, whose ControlSource property contains an expression. This expression returns a number. If I just...
4
by: George Steward | last post by:
I have written an Access database to track the accounts of a small trader which works successfully. The customer has now asked me to include an additional feature which is described as follows: ...
14
by: Alan | last post by:
Hi everyone! I'm trying to produce a periodic financial report on projects from various departments. My database is set up with the tables tblDepartment, tblProjects, tblPeriods, and tblBudgets...
3
by: google | last post by:
I'm developing an application for use within my company in Access 2003. I'm new to '03, the application I did for my former employer was in '97. The two applications have similar functionality...
1
by: owz | last post by:
This is what im trying 2 get Sales Figures for 2006 in £000's Sales staff name 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Max Min Total John Smith 24 30 15 17 30 15 86...
3
rcollins
by: rcollins | last post by:
I ahve a database that I put together to keep track of the office supplies. We input what has been purchased and what goes out. When I run a report, usually it is just for a month, but I have a...
14
by: OldBirdman | last post by:
I have a textbox on a continuous form that I want to display a calculated value. I have set the ControlSource Property = & "~" & . I would like to have my user be able to correct this value, and...
1
by: Alexio | last post by:
I have two similar function that need to be combined. Individually they both work however combined one over rides the other. The code is attached below and an attachment is included for data...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.