Parameters/Forms/Querys

[Fie]

Hey,

Am working with Access 97 and am trying to design a form that users
enter in parameters required in query to produce a report based on
parameters. I cant seem to find any help for Access 97, all seems to
be Access 2000 or 03...

can anyone help me

PLEASE

fiona

 

[Arvin Meyer [MVP]]

The answer is the same for all versions: Use the criteria box in the QBE
grid in the query wizard.

Anything you put in square brackets [ ] will be evaluated and if it can't be
resolved, will trigger a prompt. Like:

[Please Enter a Date to Start]

If you want to use a form reference to provide the parameter, you can enter
something like:

= [Forms]![Form1]![MyTextBox]

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[John Vinson]

Hey,

Am working with Access 97 and am trying to design a form that users
enter in parameters required in query to produce a report based on
parameters. I cant seem to find any help for Access 97, all seems to
be Access 2000 or 03...

Access 2.0, 95, 97, 2000, 2002, and 2003 all use basically the same
technique for this.

The help you see for 2000 will work. Try it. Just use

[Enter search term:]

or any prompt that you wish, in square brackets, on the Criteria line
of the query upon which your report is based.

John W. Vinson[MVP]

 

[Andre C]

Hey,

Am working with Access 97 and am trying to design a form that users
enter in parameters required in query to produce a report based on
parameters. I cant seem to find any help for Access 97, all seems to
be Access 2000 or 03...

Try http://allenbrowne.com/casu-08.html

This whole site is a wondeful resource if like me you are on the steep
learning path.

ACC

 

[Michel Walsh]

Hi,



Do you mean you use OpenArgs? that argument has been added only on recent
version, indeed. For previous version, define a global (application wide)
collection variable; add item to it (the key being the "parameter name", the
value being the ... value; in your report, refer to that
collection("parameter name") to get the value. Note that using a collection,
rather than a string, avoid formatting problems, since a collection can hold
"objects" of different datatype (while a string, as OpenArgs, requires that
everyone is dumped as a string, and that you read the sub-string in the same
order as the order you use to wrote the values (since you probably didn't
wrote the parameters in that string))... but I am getting outside the scope
of the initial discussion...




Hoping it may help,
Vanderghast, Access MVP

 

[Tim S]

I couldn't get the >= [Forms]![Form1]![MyTextBox] to work on my query. Am I
entering this incorrectly? EQUILIBRIUM_PCT:
[Forms]![frmQualifyingRateCalcEntry]![EQUIL_PCT] is what I am using....

Thanks, Tim

The answer is the same for all versions: Use the criteria box in the QBE
grid in the query wizard.

Anything you put in square brackets [ ] will be evaluated and if it can't be
resolved, will trigger a prompt. Like:

[Please Enter a Date to Start]

If you want to use a form reference to provide the parameter, you can enter
something like:

= [Forms]![Form1]![MyTextBox]

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Hey,

Am working with Access 97 and am trying to design a form that users
enter in parameters required in query to produce a report based on
parameters. I cant seem to find any help for Access 97, all seems to
be Access 2000 or 03...

can anyone help me

PLEASE

fiona

 

[John Vinson]

I couldn't get the >= [Forms]![Form1]![MyTextBox] to work on my query. Am I
entering this incorrectly? EQUILIBRIUM_PCT:
[Forms]![frmQualifyingRateCalcEntry]![EQUIL_PCT] is what I am using....

It looks like you're putting this into a vacant Field cell. What do
you want the query to do with this form value? IF it is to be a search
criterion, the Forms! etc. reference should go onto the Criteria line
under the field that you want to match.

Perhaps you could open the Query in SQL view and post the SQL text
here.

John W. Vinson[MVP]