Frequently asked questions for self help.
Knowledge base article 125Parameter entry before running queries
Suppose you have a defined a query and each time you run it, you want to prompt for a paramater or date range.
MS Access will automatically prompt for unknown query parameters. Ability does not do this but it is possible to setup a small system of tables and forms to do the same.
To see how this can be done, please download and open the following example: QUERYPARAMS.ADB
In the above baseTable is the data you want to set the paramters for the query. There are two examples: a set number example (see the form: FormNumberQuery) and a date range example (see the form: FormDateQuery).
These examples are largely self explanatory. In brief, they each use a dummy table to store the query parameters and then relate with the base table, limiting the result to the values in the dummy table.
For a more in depth explanation, please email support stating what it is that is not clear.