Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #11127 > unrolled thread

Access 2003: Query Stopped Referencing Values On Form ?

Back to article view | Back to comp.databases.ms-access

Contents

  Access 2003: Query Stopped Referencing Values On Form ? "(PeteCresswell)" <x@y.Invalid> - 2015-09-22 16:17 -0400
    Re: Access 2003: Query Stopped Referencing Values On Form ? Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-09-22 14:24 -0700
      Re: Access 2003: Query Stopped Referencing Values On Form ? "(PeteCresswell)" <x@y.Invalid> - 2015-09-23 12:27 -0400
    Re: Access 2003: Query Stopped Referencing Values On Form ? "Phil" <phil@stantonfamily.co.uk> - 2015-09-23 09:50 +0100
    Re: Access 2003: Query Stopped Referencing Values On Form ? Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-09-23 11:15 -0700
      Re: Access 2003: Query Stopped Referencing Values On Form ? Optimist <v.meldrew@i.do.not.believe.it> - 2015-09-24 09:28 +0100

#11127 — Access 2003: Query Stopped Referencing Values On Form ?

I have a query that refers to fields like
[forms]![frmHome]![txtAsOfDate] and
[forms]![frmHome]![txtTradingAccountID]

The query has been working for years and years.

Now, suddenly, it seems to not be seeing those values - running the
query "Manually", not from VBA.    It doesn't abend, just returns an
empty result set.

The fields are there on the form and populated.

When I clone the query and replace the refs with explicit values, it
returns the expected result set.

Anybody else been here?

Windows 7, SP1.
-- 
Pete Cresswell

[toc] | [next] | [standalone]

#11128

On Tuesday, September 22, 2015 at 4:18:00 PM UTC-4, (PeteCresswell) wrote:
> I have a query that refers to fields like
> [forms]![frmHome]![txtAsOfDate] and
> [forms]![frmHome]![txtTradingAccountID]
> 
> The query has been working for years and years.
> 
> Now, suddenly, it seems to not be seeing those values - running the
> query "Manually", not from VBA.    It doesn't abend, just returns an
> empty result set.
> 
> The fields are there on the form and populated.
> 
> When I clone the query and replace the refs with explicit values, it
> returns the expected result set.
> 
> Anybody else been here?
> 
> Windows 7, SP1.
> -- 
> Pete Cresswell

Maybe check by opening frmHome and verifying the text box field names didn't change.

[toc] | [prev] | [next] | [standalone]

#11136

Per Patrick Finucane:
>Maybe check by opening frmHome and verifying the text box field names didn't change.

Been there.... done that.
-- 
Pete Cresswell

[toc] | [prev] | [next] | [standalone]

#11131

On 22/09/2015 21:17:51, "(PeteCresswell)" wrote:
> I have a query that refers to fields like
> [forms]![frmHome]![txtAsOfDate] and
> [forms]![frmHome]![txtTradingAccountID]
> 
> The query has been working for years and years.
> 
> Now, suddenly, it seems to not be seeing those values - running the
> query "Manually", not from VBA.    It doesn't abend, just returns an
> empty result set.
> 
> The fields are there on the form and populated.
> 
> When I clone the query and replace the refs with explicit values, it
> returns the expected result set.
> 
> Anybody else been here?
> 
> Windows 7, SP1.

I vaguely remember something similar, 
so have you checked that txtAsOfDate and txtTradingAccountID are the form’s
field names and not the name of the field’s ControlSource?

If they are OK, have you tried a Compact & Repair?

I can’t remember whether there was a bug in Access, but have you tried
re-installing Access and applying SP3?

Phil

[toc] | [prev] | [next] | [standalone]

#11139

On Tuesday, September 22, 2015 at 4:18:00 PM UTC-4, (PeteCresswell) wrote:
> I have a query that refers to fields like
> [forms]![frmHome]![txtAsOfDate] and
> [forms]![frmHome]![txtTradingAccountID]
> 
> The query has been working for years and years.
> 
> Now, suddenly, it seems to not be seeing those values - running the
> query "Manually", not from VBA.    It doesn't abend, just returns an
> empty result set.
> 
> The fields are there on the form and populated.
> 
> When I clone the query and replace the refs with explicit values, it
> returns the expected result set.
> 
> Anybody else been here?
> 
> Windows 7, SP1.
> -- 
> Pete Cresswell

One other thing you might want to do...add some columns.  Ex:  Your criteria might read Forms!MyForm!TextBox1.  OK, take that Forms!MyForm!TextBox1 and create a column with it.  Run the query, see what that column contains.  Is it the expected value or blank?

[toc] | [prev] | [next] | [standalone]

#11142

On Wed, 23 Sep 2015 11:15:00 -0700 (PDT), Patrick Finucane <patrickfinucanetx@gmail.com> wrote:

>On Tuesday, September 22, 2015 at 4:18:00 PM UTC-4, (PeteCresswell) wrote:
>> I have a query that refers to fields like
>> [forms]![frmHome]![txtAsOfDate] and
>> [forms]![frmHome]![txtTradingAccountID]
>> 
>> The query has been working for years and years.
>> 
>> Now, suddenly, it seems to not be seeing those values - running the
>> query "Manually", not from VBA.    It doesn't abend, just returns an
>> empty result set.
>> 
>> The fields are there on the form and populated.
>> 
>> When I clone the query and replace the refs with explicit values, it
>> returns the expected result set.
>> 
>> Anybody else been here?
>> 
>> Windows 7, SP1.
>> -- 
>> Pete Cresswell
>
>One other thing you might want to do...add some columns.  Ex:  Your criteria might read Forms!MyForm!TextBox1.  OK, take that Forms!MyForm!TextBox1 and create a column with it.  Run the query, see what that column contains.  Is it the expected value or blank?

I had trouble with forms in an application developed and changed over years with various versions of
Access.  Controls had been added and deleted over the years.  Eventually I re-created the forms by
selecting and copying all the controls from the old forms.  The problems stopped.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web