FAQ

Veelgestelde vragen voor zelfhulp.

Bekijk snel de veelgestelde vragen (en antwoorden) in de standaardlijst. Als u niet kunt vinden wat u zoekt, begin dan met het selecteren van uw Ability Office -versie en verfijn deze dan door zoektekst en/of categorie in te voeren.

Kennisbank artikel 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.