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  2770  JKing 1,206
Recognized Expert Top Contributor
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?
FishVal 2,653
Recognized Expert Specialist
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 mm/yyyy".
Means: if the user enters "10/2004 - 10/2005" everything between
"2004-10-01" and "2004-10-31" is selected.
|
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 forever to open and I'm wondering what it's "calculating" and
if that's the
bottleneck.
Thanks.
|
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 field to my report (or does this have to
be created in the query?) that calculates the average of all the data
in the "Time Taken" field.
SQL code or some tips would be much appreciated.
|
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 columns I need to work with.
Values in the cols are " Over " and " Under", as text values. The query is
for a start / end date, my count of records returned will be variable
depending on the runtime dates entered.
I need to count the number of "...
|
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 special char ('|' in this case) and
calculating the size of the string, but there should be a faster way.
Thanks,
| | |
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.
Here is the simplicied section of drawing code:
private void panel_Paint(object sender,
System.Windows.Forms.PaintEventArgs e)
{
panel.AutoScroll = true;
|
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 term?
Stupid question, I know ... and quite irrelevant in many ways ... but
I really would like to know!
|
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 it has been
already assigned*: I've found that this is often referred to as "once"
assigment.
The best I could come up with in Python is:
|
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 some time. This is a problem when using the database on a server, since it seems to be running the same query over and over again.
There is one form in particular I have a particular problem with. Both its form and subform are opened using WHERE...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
