By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,055 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Access forever "calculating...."

P: 9
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.

Jan 26 '12 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,434
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

P: 9
thx...must have gotten it worked out...

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

Post your reply

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