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

Excessive Calculations Please Help

P: n/a
AP
I have a form with a subform. when I navigate through the records using
a combo box to jump to a particular record on the main form,
"calculating..." appears in the status bar and there is at least one
control with a flashing value (that looks like the form is looping
through records) sometimes, if I roll the mouse over the flashing
control, the status bar quickly switches to 'Form View', but sometimes,
it continues for a bit. Any code that is lauchned from the form during
this 'calculating' period will cause other procedures to bomb, but if
you wait for 'Form View' to appear it will all work as planned? Any
ideas?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
There could be several things causing this.

Suggestions to trace it, in this order, until you get it:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. If this is Access 2002 or 2003, and there are any subforms, make sure the
fields named in the LinkChildFields property are represented by text boxes
in the subform.

3. Temporarily remove any conditional formatting in the form, or its
subforms.

4. Set the SubdatasheetName property to No for all tables used in this form
or its subforms.

5. Temporarily comment out any code in the form's Current event.

6. Drop any calculated controls off the form (or out of its source query.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AP" <ap******@thompsongroup.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
I have a form with a subform. when I navigate through the records using
a combo box to jump to a particular record on the main form,
"calculating..." appears in the status bar and there is at least one
control with a flashing value (that looks like the form is looping
through records) sometimes, if I roll the mouse over the flashing
control, the status bar quickly switches to 'Form View', but sometimes,
it continues for a bit. Any code that is lauchned from the form during
this 'calculating' period will cause other procedures to bomb, but if
you wait for 'Form View' to appear it will all work as planned? Any
ideas?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.