many queries with same parameters

  • Thread starter Thread starter kristy
  • Start date Start date
K

kristy

I am running several queries in a row that ask for the
same parameters (begin dates, end dates). They are
running within a macro. I have to rekey the paramaters
every time a new query starts. Is there a way to ask for
this information one time and then use the results in
several queries without having to reenter?
 
Create a form that has textboxes on it for the values you want to use. Then
have the queries read the textboxes instead of asking for parameters:

Between [Forms]![Formname]![txtBoxName1] And
[Forms]![Formname]![txtBoxName2]

for example.

The form will need to be open while all the queries run.
 
THANK YOU!! That did the trick!
-----Original Message-----
Create a form that has textboxes on it for the values you want to use. Then
have the queries read the textboxes instead of asking for parameters:

Between [Forms]![Formname]![txtBoxName1] And
[Forms]![Formname]![txtBoxName2]

for example.

The form will need to be open while all the queries run.

--
Ken Snell
<MS ACCESS MVP>

kristy said:
I am running several queries in a row that ask for the
same parameters (begin dates, end dates). They are
running within a macro. I have to rekey the paramaters
every time a new query starts. Is there a way to ask for
this information one time and then use the results in
several queries without having to reenter?
Click to expand...


.
Click to expand...
 
You're welcome.

Kristy said:
THANK YOU!! That did the trick!
-----Original Message-----
Create a form that has textboxes on it for the values you want to use. Then
have the queries read the textboxes instead of asking for parameters:

Between [Forms]![Formname]![txtBoxName1] And
[Forms]![Formname]![txtBoxName2]

for example.

The form will need to be open while all the queries run.

--
Ken Snell
<MS ACCESS MVP>

kristy said:
I am running several queries in a row that ask for the
same parameters (begin dates, end dates). They are
running within a macro. I have to rekey the paramaters
every time a new query starts. Is there a way to ask for
this information one time and then use the results in
several queries without having to reenter?
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top