473,320 Members | 1,867 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,320 software developers and data experts.

"Calculating..." message

missinglinq
3,532 Expert 2GB
I've got someone I'm helping with an app and he has a realtime clock on his main form that runs off of the Timer Event. He reports the message "Calculating..." appearing in the lower left part of the taskbar, alternating with the control's name that the time is being written to. I've used this same code for years without seeing this phenomena, and wondered if anyone here had experienced it, and if so, if there's a way to suppress it.

I found a number of references to the problem online, ususally dealing with a combobox with a large rowsource, but all of the posts I found were unanswered.

Any ideas?
Jun 28 '07 #1
4 2753
JKing
1,206 Expert 1GB
This might sound simplistic but is the calculated time in a loop? Access will as I'm sure you know display Calculating... when it's processing a calculated field. Now if it were to be in a loop to constantly have the current time would this not cause access to be in the constant state of "Calculating..."?
Jun 28 '07 #2
missinglinq
3,532 Expert 2GB
Here's the hack:
The control holding the time is named txtOmega (I'm a watch freak!)
The Timer Interval is set to 1000.
Then the code:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Timer()
  2.     Me.txtOmega = Time 'Displays current time
  3.  End Sub
As I said, I've used this for a number of years on various apps, and have never seen the "Calculating..." message, either with this hack or on apps where calculations are taking place. Have I unknowingly set something in my Access environment that suppresses the message?
Jun 28 '07 #3
FishVal
2,653 Expert 2GB
Here's the hack:
The control holding the time is named txtOmega (I'm a watch freak!)
The Timer Interval is set to 1000.
Then the code:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Timer()
  2. Me.txtOmega = Time 'Displays current time
  3. End Sub
As I said, I've used this for a number of years on various apps, and have never seen the "Calculating..." message, either with this hack or on apps where calculations are taking place. Have I unknowingly set something in my Access environment that suppresses the message?
Hi!

Is you Me.txtOmega used anywere in expression?

I've made an empty form with the same control and it works fine.
Then I've added textbox with ControlSource "=[txtOmega]" (this usually works slow and make "Calculating..." message to appear). The message appears with every timer tick.

P.S. As far as I know your code is not likely to fire any event and to run some time consuming code. Or maybe it is not so.
Jun 28 '07 #4
missinglinq
3,532 Expert 2GB
No! What you see is exactly what is involved! I repeated your experiment and it did, indeed, result in the "Calculating..." message coming up (which is the first time I've ever seen it; I don't do financial/accounting apps with lots of calculations) but when I took that back out and only had the above code running, the message disappeared. I'm beginning to think he must have something else going on that's causing the message, and only thinks it was the clock hack.

Thanks for you time!

Linq
Jun 28 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

16
by: Bernd Hohmann | last post by:
Hi there, we're currently convert an old ISAM application to Java and DB2. Among the load of problems we found the reports which have user selections like "select all data between mm/yyyy and...
1
by: Joe Bongiardina | last post by:
What does the message "calculating...." mean in the lower left status area of a form? I have a form with no calculated, concatenated or lookup fields, yet it displays this msg. The form takes...
1
by: Simon Bailey | last post by:
I currently have a query calculating the gap in days between two dates. The fields being "DateLookedAt" and "DateResolved" plus the calculated field "TimeTaken". I am looking to add another...
3
by: Rabun | last post by:
Heres one that is giving me fits ( = = Access newbie), more than likely something simple that I blew right over . . . any help is appreciated - I have a report based on a query, with several...
2
by: VM | last post by:
How can I separate a string that looks like this: "John|Conner|34323|T3-1" so I can place John in one variable, Conner in another variable, etc...? I know you can do it by finding the...
1
by: John | last post by:
I'm trying to use the DrawText() method to draw some very long string text on the Panel with AutoScroll enabled. However, for some unknown reasons, I could not trigger the ScrollBar to show up. ...
5
by: G. Stewart | last post by:
The word "Business" in the term implies some sort of commercial aspects or connotations. But from what I can see, that is not necesserially the case at all? So what is the reasoning behind the...
10
by: Lorenzo Di Gregorio | last post by:
Hello, I've been using Python for some DES simulations because we don't need full C speed and it's so much faster for writing models. During coding I find it handy to assign a variable *unless...
6
by: jonnyboy | last post by:
Hello, I have an Access application with a number of forms. On opening one particular form, the application will sometimes appear to get stuck in a loop with 'Calculating...' in the status bar for...
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...
1
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: 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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
0
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...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.