Access forever "calculating...."

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • blah DeBlah
    New Member
    • Jan 2012
    • 9

    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()...r unning" 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...C alculating...".

    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
    Last edited by blah DeBlah; Jan 26 '12, 12:49 PM. Reason: i'm stickler for words.
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    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.

    Comment

    • blah DeBlah
      New Member
      • Jan 2012
      • 9

      #3
      thx...must have gotten it worked out...

      oh, yeah -- removed some "requery" statements to keep things from churning away.

      Comment

      Working...