FAQ

Frequently asked questions for self help.

Please take a quick look at common questions (and answers) in the default list. If you can't find what you're looking for, start off by selecting your Ability Office version and then narrow it down by entering search text and/or category.

Knowledge base article 125

Parameter 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.