473,320 Members | 2,092 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,320 software developers and data experts.

ADP: subform auto-requeries in endless loop

Hi All,
This one has me stumped. I hope someone else has seen this behavior
and knows what's going on.
I'm using Access 2003 ADP on Windows XP, database in 2002/2003 format,
with SQL Server 2000. Everything patched to latest version. This
happens both at work and at home.
My form is very similar in structure to the NorthwindCS Orders form: a
parent form with a subform in datasheet. The subform draws its data
from a view. The LinkChildFields and LinkMasterFields properties are
used to restrict the rows to what's needed for the parent values (1
field; datatype=smallint). I have a field in the footer of the subform
summing a Currency field, and a control on the parent that picks up
that value. There is no code in any important event.
The form requeries itself in an endless loop, about 5 times per
second.
Here is the kicker: if I resize the subform so all rows fit (i.e. no
vertical scrollbar), then the requery does not happen!

I can stop this behavior by taking out "=Sum([TargetAmount])" from the
ControlSource of the control in the footer of the subform. Taking out
the ControlSource of the control in the parent
(=[chiMain].[Form]![txtTargetTotal]) does not stop it.

Any insights much appreciated.

-Tom.

Nov 13 '05 #1
2 2330
On Tue, 28 Dec 2004 20:29:50 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
I found a work-around, but I don't yet understand why it happened in
the first place. The field in LinkMasterFields is a textbox, with a
controlsource of:
=[Forms]![frmStartup]![cmbFY]
to pick up the fiscal year from a dropdown list on another form.
Although the textbox displays its value just fine, replacing the
controlsource with:
=2005
stabilizes the form.

This also worked: setting the ControlSource to:
=GetFiscalYear()
and adding a function:
Private Function GetFiscalYear() As Integer
GetFiscalYear = [Forms]![frmStartup]![cmbFY]
End Function

I still have no idea why the first implementation did not work.

-Tom.
Hi All,
This one has me stumped. I hope someone else has seen this behavior
and knows what's going on.
I'm using Access 2003 ADP on Windows XP, database in 2002/2003 format,
with SQL Server 2000. Everything patched to latest version. This
happens both at work and at home.
My form is very similar in structure to the NorthwindCS Orders form: a
parent form with a subform in datasheet. The subform draws its data
from a view. The LinkChildFields and LinkMasterFields properties are
used to restrict the rows to what's needed for the parent values (1
field; datatype=smallint). I have a field in the footer of the subform
summing a Currency field, and a control on the parent that picks up
that value. There is no code in any important event.
The form requeries itself in an endless loop, about 5 times per
second.
Here is the kicker: if I resize the subform so all rows fit (i.e. no
vertical scrollbar), then the requery does not happen!

I can stop this behavior by taking out "=Sum([TargetAmount])" from the
ControlSource of the control in the footer of the subform. Taking out
the ControlSource of the control in the parent
(=[chiMain].[Form]![txtTargetTotal]) does not stop it.

Any insights much appreciated.

-Tom.


Nov 13 '05 #2
This is an intermittent bug with Access and calculated controls or conditional
formatting on correlated subforms. FWICT, it is not specific to ADPs. You've
already found the appropriate solutions.

On Tue, 28 Dec 2004 20:29:50 -0700, Tom van Stiphout <no*************@cox.net>
wrote:
Hi All,
This one has me stumped. I hope someone else has seen this behavior
and knows what's going on.
I'm using Access 2003 ADP on Windows XP, database in 2002/2003 format,
with SQL Server 2000. Everything patched to latest version. This
happens both at work and at home.
My form is very similar in structure to the NorthwindCS Orders form: a
parent form with a subform in datasheet. The subform draws its data
from a view. The LinkChildFields and LinkMasterFields properties are
used to restrict the rows to what's needed for the parent values (1
field; datatype=smallint). I have a field in the footer of the subform
summing a Currency field, and a control on the parent that picks up
that value. There is no code in any important event.
The form requeries itself in an endless loop, about 5 times per
second.
Here is the kicker: if I resize the subform so all rows fit (i.e. no
vertical scrollbar), then the requery does not happen!

I can stop this behavior by taking out "=Sum([TargetAmount])" from the
ControlSource of the control in the footer of the subform. Taking out
the ControlSource of the control in the parent
(=[chiMain].[Form]![txtTargetTotal]) does not stop it.

Any insights much appreciated.

-Tom.


Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Filips Benoit | last post by:
Dear All, W2000 Office2000 Access adp SQLserver DB Problem: Adding a new property for a company in the subform. The FIRST time I Select a property in combobox CPROP_PRP_ID the subform act
33
by: Jerry Boone | last post by:
A long time ago Larry Linson (MVP contributor to this group) made a point to me that mdb's could do anything ADP's (Access Projects) could by using linked tables to leverage Sql server databases. ...
5
by: M Wells | last post by:
Hi All, Is it possible to use form criteria in a query / view in an Access 2003 ADP with SQL Server as the backend? ie something like: select * from mytable where recid = forms!! I'm...
3
by: Todd | last post by:
Hi, I've been told in another forum that I can apply a filter to a subform (from a control on the main form) by using the following code: Me.sfrMySubform.Filter = " = 7" I've tried this...
0
by: JH Higgins | last post by:
In Access (.mdb File) I have a subform on a form. Doing data entry on the subform works just fine. If I move the forms and tables over to a .adp I can no longer do data entry in the child...
0
by: Filips Benoit | last post by:
Dear All, W2000 Office2000 Access adp SQLserver DB Problem: Adding a new property for a company in the subform. The FIRST time I Select a property in combobox CPROP_PRP_ID the subform act
3
by: Andrew Chanter | last post by:
I am in the process of developing an ADP client for a SQL Server database. The IT Manager has requested that the adp file be launched centrally by each user from a file on the file server (as...
7
by: Br | last post by:
I'm sure this has been answered before but I can't dig up any posts that give a good answer.. and I'm sure I've come across it before but forget how I dealt with it. I have an ADP (A2000,...
4
by: bobg.rjservices | last post by:
running access 2k; adp w/ linked tables to SQL server; I am absolutely stymied, and ticked off beyond belief - I can not believe how much time I've wasted trying to do something that should be...
5
by: David Wright | last post by:
Hello Everyone I would be grateful if someone could help me with the automatic increment of a field on my subform called ‘Test_SrNo’. I am Using Microsoft Office 2000. The auto entry of the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.