Hi all,
I'm searching fulltime for days now, and I don't find the solution, so I'm
thinking this is more a bug :(
If i use following code in form&subforms:
Me.Parent![PeopleBase].Requery
Then sometimes (after 5, 6 or 20 times) i get an endless loop with 100% cpu
utilization (in the status bar you can see the note 'Calculating' !)
Some people put this code into the OnCurrent event and other say that this
is the cause. I tested the code everywhere (onclick, on change, etc...) and
still the same err occurs. Did err handling to fetch this loop but nothing.
I'm 100% sure that this line of code is giving me the loop problems. (Some
people reported that there was no problem in access97 and that it all
started with version 2000!)
If i search the net for this then you will find some 1000 msg reporting this
problem. I run through the most of them to find some solution, but nothing
did help yet.
Please, someone smarter then me, please help me with this, I can see it
anymore!
Thnx world.
ps: For your info, I'm using Access2000 eng on a Win2k eng sp4 platform (all
patches installed)
3  2856 
Hi all again,
ITS A BUG!!!! http://support.microsoft.com/default...b;en-us;288374
Does someone has got good resolution for this ?
Thnx in advance
"John F." <jo**@clearmymi nd.com> wrote in message
news:3f******** **************@ reader1.news.sk ynet.be... Hi all,
I'm searching fulltime for days now, and I don't find the solution, so I'm
thinking this is more a bug :(
If i use following code in form&subforms:
Me.Parent![PeopleBase].Requery
Then sometimes (after 5, 6 or 20 times) i get an endless loop with 100%
cpu utilization (in the status bar you can see the note 'Calculating' !)
Some people put this code into the OnCurrent event and other say that this
is the cause. I tested the code everywhere (onclick, on change, etc...)
and still the same err occurs. Did err handling to fetch this loop but
nothing. I'm 100% sure that this line of code is giving me the loop problems. (Some
people reported that there was no problem in access97 and that it all
started with version 2000!)
If i search the net for this then you will find some 1000 msg reporting
this problem. I run through the most of them to find some solution, but nothing
did help yet.
Please, someone smarter then me, please help me with this, I can see it
anymore!
Thnx world.
ps: For your info, I'm using Access2000 eng on a Win2k eng sp4 platform
(all patches installed)
The link you provided gave the (perhaps unhelpful) solution of firing this
code from a diferent event, when you tried using diferent events to fire the
code did you delete the line of code from the OnCurrent event (just
checking)?
If so, perhaps you coud use a global variable and the Timer function to
produce code that will not refresh if it is within a certain amount of time
from a previous refresh?
--
Michael Hopwood (Phobos)
"John F." <jo**@clearmymi nd.com> wrote in message
news:3f******** *************** @reader3.news.s kynet.be... Hi all again,
ITS A BUG!!!!
http://support.microsoft.com/default...b;en-us;288374
Does someone has got good resolution for this ?
Thnx in advance
"John F." <jo**@clearmymi nd.com> wrote in message
news:3f******** **************@ reader1.news.sk ynet.be... Hi all,
I'm searching fulltime for days now, and I don't find the solution, so
I'm thinking this is more a bug :(
If i use following code in form&subforms:
Me.Parent![PeopleBase].Requery
Then sometimes (after 5, 6 or 20 times) i get an endless loop with 100%
cpu utilization (in the status bar you can see the note 'Calculating' !)
Some people put this code into the OnCurrent event and other say that
this is the cause. I tested the code everywhere (onclick, on change, etc...)
and still the same err occurs. Did err handling to fetch this loop but
nothing. I'm 100% sure that this line of code is giving me the loop problems.
(Some people reported that there was no problem in access97 and that it all
started with version 2000!)
If i search the net for this then you will find some 1000 msg reporting
this problem. I run through the most of them to find some solution, but
nothing did help yet.
Please, someone smarter then me, please help me with this, I can see it
anymore!
Thnx world.
ps: For your info, I'm using Access2000 eng on a Win2k eng sp4 platform
(all patches installed)
Hi Michael,
I did delete the code in the OnCurrent event when i was trying it on other
places. I even place it in a button, to fire it at own will. The weird thing
is that it I found out that it only happens when there was a previous delete
function fired on the table that gives a warning like : "The record cannot
be deleted or changed because table 'xxxx' includes related records.". If
you do then a Requery on the subforms then its bingo :( 100% cpu loop.
I'm using Access 2000, but the art stated acc2002, so I think this is a big
bug for years now.
I'm trying now to use the OnCurrent to fire some code that will fetch the
current record Key id and change the subform DataSourceQuery and refresh the
subform. I don't know about this, but its a shot I can do. If I have some
code i will post it here.
I don't want to use the timer function because it has nothing to do with "an
event1 that triggers event2 that triggers back event1.", because I use
buttons I only click ones, just for testing. I know, everybody is talking
about this back trigger, but i'm 100% sure this is not true.
For me, the Requery function just sucks, and is no good. Just a function to
stay away from. If it only happens 2 times on 10 then you know what I mean.
Hoop someone got some replacement code for this.
Cya all.
Thnx Michael,
JF
"Michael Hopwood" <la******@spamm ers.co.uk> wrote in message
news:J6******** ************@br ightview.com... The link you provided gave the (perhaps unhelpful) solution of firing this
code from a diferent event, when you tried using diferent events to fire
the code did you delete the line of code from the OnCurrent event (just
checking)?
If so, perhaps you coud use a global variable and the Timer function to
produce code that will not refresh if it is within a certain amount of
time from a previous refresh?
--
Michael Hopwood (Phobos)
"John F." <jo**@clearmymi nd.com> wrote in message
news:3f******** *************** @reader3.news.s kynet.be... Hi all again,
ITS A BUG!!!!
http://support.microsoft.com/default...b;en-us;288374
Does someone has got good resolution for this ?
Thnx in advance
"John F." <jo**@clearmymi nd.com> wrote in message
news:3f******** **************@ reader1.news.sk ynet.be... Hi all,
I'm searching fulltime for days now, and I don't find the solution, so I'm thinking this is more a bug :(
If i use following code in form&subforms:
Me.Parent![PeopleBase].Requery
Then sometimes (after 5, 6 or 20 times) i get an endless loop with
100% cpu utilization (in the status bar you can see the note 'Calculating' !)
Some people put this code into the OnCurrent event and other say that this is the cause. I tested the code everywhere (onclick, on change,
etc...) and still the same err occurs. Did err handling to fetch this loop but
nothing. I'm 100% sure that this line of code is giving me the loop problems. (Some people reported that there was no problem in access97 and that it all
started with version 2000!)
If i search the net for this then you will find some 1000 msg
reporting this problem. I run through the most of them to find some solution, but nothing did help yet.
Please, someone smarter then me, please help me with this, I can see
it anymore!
Thnx world.
ps: For your info, I'm using Access2000 eng on a Win2k eng sp4
platform (all patches installed)
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Drew |
last post by:
I am trying to build a small app that shows a Course Title from the
database, then displays a dropdown full of categories for the user to choose
one...
I thought a loop would be the best way to accomplish this, but since the
dropdown is dynamic, I am having problems. Can someone help me out here?
Here is my code,
For i = 1 to Num
|
by: Bev in TX |
last post by:
We are using Visual Studio .NET 2003. When using that compiler, the
following example code goes into an endless loop in the "while" loop when the
/Og optimization option is used:
#include <stdlib.h>
int resize(int *incsize, int min_size) {
while(*incsize <= min_size) {
*incsize = (int)(*incsize * 1.25);
}
if ( min_size > 60 ) return 0;
|
by: scorpion53061 |
last post by:
Very urgent and I am very close but need a little help to get me over the
edge........
I need to write these columns to a html file with each row containing these
columns (seperated by breaks). Currently this code write all columns to a
single row which works but is not what the boss wants. If anyone has
suggestions how you would do a report like this I very much would like to
hear them as well. vb.net windows app.
...
|
by: Nico |
last post by:
Hello everyone,
I have re-formulated the question I asked on my last post::
I am trying to capture the System event raised when a Network Connection
is established in VB.NET (ie. connection from a client to a network
resource, just like the winsock control did successfully for so many years)
AND the one that is raised when data is recieved on this connection. I have
seen many posts suggesting to create a timer and check the network...
|
by: Claudio Grondi |
last post by:
In the process of learning about some deeper details of Python I am
curious if it is possible to write a 'prefix' code assigning to a and b
something special, so, that Python gets trapped in an endless loop in a
line with:
if a==b: print 'OK'
I mean, it would be of much help to me on my way to understanding Python
to know how such prefix code leading to an endless loop can look like
and if it is eventually not possible to write such...
| | |
by: uche |
last post by:
This function that I have implemented gives me an infinite loop. I am
trying to produce a hexdum program, however, this function is not
functioning correctly.....Please help.
void output(unsigned char ret_buffer, int curr_buffer_size, bool&
endoffile)
{
int index2=0;
int addr=0;
unsigned char outBuff;
|
by: j_depp_99 |
last post by:
Thanks to those guys who helped me out yesterday. I have one more
problem; my print function for the queue program doesnt work and goes
into an endless loop. Also I am unable to calculate the length of my
queue. I started getting compilation errors when I included a length
function.
<code>
template<class ItemType>
void Queue<ItemType>::MakeEmpty()
{
|
by: =?Utf-8?B?d2luZHNpbQ==?= |
last post by:
Hi,
I have a project based on .Net 1.1 and VS 2003,now I am trying to upgrade it
to .Net 2.0 and VS 2005.The project passes the 'Build Solution',but When I
start Debug, it suddenly comes StackOverflowException and Debug stops.
The main Exception point is the function below:
public System.ComponentModel.PropertyDescriptorCollection
GetStatefulPropertyDescriptors()
{
|
by: muddasirmunir |
last post by:
i make a form whic has one data grid and one text box and one button
when i write a name on tex box and click add the name stored in database successfully.
now in the grid i want to show all the names but after i add no name is seen on datagrid but if i add second time the first name appear on the datagrid and when i entery third entry the second name apperar
i use the following code
adodc1.recordset.requery
why it show one field...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
