Criteria across the board?

[Beeler]

In attempting to create a simple query I came across an unexpected
occurrence. All I wanted to do was create a select query that I could narrow
down to returning results by entering a date range. So using the between and
operaters I decided to have Access create a pop up message box to ask for
those dates every time the query was run. So under the Date Column (design
view) I put under the criteria row: Between [Begin Date:] And [End Date:].
This works, however, whenever I try to run a different query the same pop up
boxes appear. I only want this criteria to apply to that particular query,
how do I make that happen?

 

[mscertified]

There must be some other query referencing the query that needs the dates.

 

[Beeler]

That seems to be it. I didn't think so, but I had forgotten that the query I
was currently working on referenced a query that referenced that query, so I
didn't even think it was related. Thank you.
--
-Beeler

There must be some other query referencing the query that needs the dates.

In attempting to create a simple query I came across an unexpected
occurrence. All I wanted to do was create a select query that I could narrow
down to returning results by entering a date range. So using the between and
operaters I decided to have Access create a pop up message box to ask for
those dates every time the query was run. So under the Date Column (design
view) I put under the criteria row: Between [Begin Date:] And [End Date:].
This works, however, whenever I try to run a different query the same pop up
boxes appear. I only want this criteria to apply to that particular query,
how do I make that happen?

 

[John W. Vinson]

In attempting to create a simple query I came across an unexpected
occurrence. All I wanted to do was create a select query that I could narrow
down to returning results by entering a date range. So using the between and
operaters I decided to have Access create a pop up message box to ask for
those dates every time the query was run. So under the Date Column (design
view) I put under the criteria row: Between [Begin Date:] And [End Date:].
This works, however, whenever I try to run a different query the same pop up
boxes appear. I only want this criteria to apply to that particular query,
how do I make that happen?

It shouldn't be doing this in other queries! Does the second query reference
the first one? Perhaps you could open the second query (which is giving
prompts and shouldn't) in SQL view and post it here.

John W. Vinson [MVP]

 

[Beeler]

SELECT [All].RMO, [All].[Forms 2006].Date AS Expr1, [All].[Forms 2007].Date
AS Expr2
FROM [All];

I'm still working on these queries but this is one that references the first
one (that contains the criteria) query directly title All. This view puts it
in perspective though. I didn't expect Access to update these automatically.

--
-Beeler

In attempting to create a simple query I came across an unexpected
occurrence. All I wanted to do was create a select query that I could narrow
down to returning results by entering a date range. So using the between and
operaters I decided to have Access create a pop up message box to ask for
those dates every time the query was run. So under the Date Column (design
view) I put under the criteria row: Between [Begin Date:] And [End Date:].
This works, however, whenever I try to run a different query the same pop up
boxes appear. I only want this criteria to apply to that particular query,
how do I make that happen?

It shouldn't be doing this in other queries! Does the second query reference
the first one? Perhaps you could open the second query (which is giving
prompts and shouldn't) in SQL view and post it here.

John W. Vinson [MVP]

 

[John W. Vinson]

SELECT [All].RMO, [All].[Forms 2006].Date AS Expr1, [All].[Forms 2007].Date
AS Expr2
FROM [All];

I'm still working on these queries but this is one that references the first
one (that contains the criteria) query directly title All. This view puts it
in perspective though. I didn't expect Access to update these automatically.

If the query named ALL has the prompts, then you'll get the prompts appearing
when you run this query. It's not "updating" anything - you're just calling
the query named All; Access sees that the query named All has parameters; it's
asking for the parameters.

John W. Vinson [MVP]

 

[Beeler]

Thanks for you help. I hadn't realized that my queries were referencing the
ALL query. In the one instance, I have a query that is referencing the query
I posted which was giving me the response. That's why I was confused, I
didn't immediately see that they were connected.
--
-Beeler

SELECT [All].RMO, [All].[Forms 2006].Date AS Expr1, [All].[Forms 2007].Date
AS Expr2
FROM [All];

I'm still working on these queries but this is one that references the first
one (that contains the criteria) query directly title All. This view puts it
in perspective though. I didn't expect Access to update these automatically.

If the query named ALL has the prompts, then you'll get the prompts appearing
when you run this query. It's not "updating" anything - you're just calling
the query named All; Access sees that the query named All has parameters; it's
asking for the parameters.

John W. Vinson [MVP]