473,324 Members | 2,567 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,324 software developers and data experts.

Access forever "calculating...."

The facts, M'am: Access 2007/'03 file on Windows XP in an enterprise setting; developed by self-taught hack (me).

Now then: all was sweetness and light through v 9. I mean, naturally, I'd had several nervous breakdowns trying to conform to arcane object models associated with Access 2007, and the intolerable slowness of Windows in a corporate setting. That said, some reworks were employed in later versions and now...

...every time I open the code window, stuff is happening. There's that "....blah()...running" message on the titlebar (or whatever the hell you call it) of the code window, on and off, on and off, on and off. And that flipping hourglass. And in the "status window" (depends on what you mean by "status", I guess), always "Calculating...Calculating...Calculating...".

I wait my turn to click on some button and then wait for things that used to happen right away, to get done in deciseconds.

Oh, and this other thing: now when I click in the code window, let's say in the form code, the form opens in design mode. Not only does waiting for that happen take enough time to cause me to lose whatever flash of inspiration motivated me to open the code window to begin with, it did NOT occur up through v.9.

Lots of changes were made, and I'm trying to avoid undoing and redoing them one-by-one to figure out that I left a space out of an error handler or some stupid thing like that. I'm wondering if anyone has any experience with this type of "behavior."

Thanks in advance.

~blah
Jan 26 '12 #1
2 2091
Killer42
8,435 Expert 8TB
Just came across this post; sorry to see you never received an answer. I hope you sorted out the problem.

In future, I'd recommend using our Access/VBA forum as that's where all MS Access gurus hang out.
Apr 22 '12 #2
thx...must have gotten it worked out...

oh, yeah -- removed some "requery" statements to keep things from churning away.
May 7 '12 #3

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

Similar topics

43
by: steve | last post by:
I am quite frustrated with php’s include, as I have spent a ton of time on it already... anyone can tell me why it was designed like this (or something I don’t get)? The path in include is...
2
by: steve | last post by:
Hi, I need to do conditional script "include", but like to pull the code from db instead of a file. How do I do that? Reason: I like to implement some complex regex logic, and make it table...
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...
8
by: Ulysse | last post by:
Hello, I need to clean the string like this : string = """ bonne mentalit&eacute; mec!:) \n <br>bon pour info moi je suis un serial posteur arceleur dictateur ^^* \n ...
2
by: Angus | last post by:
I am trying to change the selection in Javascript - but this HTML element is not a standard option control. On the web page it looks like a dropdown list - and you click on the right hand down...
4
missinglinq
by: missinglinq | last post by:
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...
1
by: manchin2 | last post by:
Hi, Can anybody please provide the information about "&quot" and its use, if possible please provide an example. ...
4
by: thaytu888888 | last post by:
Here is my codes in aspx page: <td colspan="2" class="main_menu" runat="server" onclick='toggleDisplay(<%#Eval("description")%>);'><%#Eval("description")%></td> Here is in "View source": ...
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...
2
by: JohnRFeldman | last post by:
This is a question relating to Access 2000/2002, which the Province of Ontario is still using. I have a query based on a join between an ODBC linked SQL Server table and an Access table. The...
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: 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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
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.