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?
4 2753
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..."?
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: -
Private Sub Form_Timer()
-
Me.txtOmega = Time 'Displays current time
-
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?
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: -
Private Sub Form_Timer()
-
Me.txtOmega = Time 'Displays current time
-
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.
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
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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.
...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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
| |