Perguntas frequentes

Perguntas frequentes para auto-ajuda.

Por favor, dê uma olhada rápida nas perguntas comuns (e respostas) na lista padrão. Se você não encontrar o que está procurando, comece selecionando sua versão Ability Office e, em seguida, reduza-a inserindo o texto de pesquisa e/ou categoria.

Artigo da base de conhecimento 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.