473,395 Members | 1,679 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,395 software developers and data experts.

Excessive Calculations Please Help

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
1 1576
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Newbie | last post by:
I currently have a set of simple calculations to determine square footage and multuply that by a dollar amount per foot. I use form fields that are filled in by the user, and then the Submit...
5
by: ptass | last post by:
If i create a simple windows form .exe then launch it via a href, ( simple one touch deployment ), why does the .net framework/iis search in multiple places and for multiple files derived from the...
11
by: lduperval | last post by:
Hi, I`m trying to do date calculations in three types of time zones: local, GMT and specified. The issue I am facing is that I need to be able to specify a date in the proper time zone, and I`m...
22
by: Frinton | last post by:
Hi, I am trying to do some calculations on large numbers (ie 7,768,489,957,892,578,474,792,094 / 12,280) and no matter what I do it doesn't get it quite right. Its always somewhere between 10...
3
by: acecraig100 | last post by:
I am fairly new to Javascript. I have a form that users fill out to enter an animal to exhibit at a fair. Because we have no way of knowing, how many animals a user may enter, I created a table...
17
by: panjap | last post by:
Hello, Please may someone help with a problem as i am struggling on using Microsoft Acess to manipulate data and crete a system which creates orders for a shop as part of my project. i really would...
5
by: Kuldeep | last post by:
Hi All, Platform: Visual Studio 2005 Language: C#.NET Could you please help me find a pretty good component which can act as an Add-In to Visual Studio 2005 to carry out "Scientific...
9
by: matthew.newsome | last post by:
I have two fields on a query, one is a count and one is either Red, Amber or Green So my results are Red 5 Amber 7 Green 2 I need to calculate the count of Reds (5) by a...
1
by: Grubsy4u | last post by:
Grubsy4u Newbie 7 Posts October 5th, 2007 11:31 AM #1 Report calculations --------------------------------------------------------------------------------
9
Catalyst159
by: Catalyst159 | last post by:
I have a form which is used to calculate residential Floor Area Ratio (FAR). The form is structured into seven parts as follows: Part A: Maximum FAR and Floor Area: Part B: Gross Floor Area of...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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...
0
tracyyun
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...

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.