Query Criteria, Part 3: Prompting for input by using a parameter

Маңызды :  This article is machine translated, see the disclaimer. Please find the English version of this article here for your reference.

In part 2 of this series, we considered using LIKE and wildcards in query criteria to find inexact matches. Good stuff – but what if you could get the query to apply criteria that are supplied when it is run? What if you could make a query ask for input? Good news! You can make a query ask for input, and it's actually very easy.

All you do is use a question enclosed in square brackets in place of a normal criterion. When someone runs the query, the first thing it does is present a dialog box displaying the question you used. Let's have a look at the design of the query that produced that Customer's last name? dialog box.

Parameter question in square brackets in Criteria row

The query returns all the data from the Customers table, but only those records where LastName matches the user's answer to this:

Enter parameter value

That gets the job done, but there are things you can do to improve the query's usability. For one, you can declare your parameters so Access will provide a sensible error message if someone inputs the wrong type of data (for example, someone enters text when a number is required).

To declare a parameter:

  1. Open the query in Design view and copy the parameter question to the Clipboard, including the brackets (select the parameter question and press Ctrl+C).

  2. On the Query Tools | Design tab, in the Show/Hide group, click Parameters.

  3. In the Query Parameters dialog box, paste the copied parameter into the Parameter column, and then set the data type using the drop-down list in the Data Type column.

Pasting the question into Query Parameter dialog box

If you really want to go all-out, you can use a form to collect the input. A form opens up all kinds of possibilities, such as sharing input parameters among a set of queries or providing a date-picker to input a date/time parameter. For more information, see Use a parameter to make a query ask for input.

Ескерту : Machine Translation Disclaimer: This article has been translated by a computer system without human intervention. Microsoft offers these machine translations to help non-English speaking users enjoy content about Microsoft products, services and technologies. Because the article was machine translated, it may contain errors in vocabulary, syntax or grammar.

Дағдыларды жетілдіру
Оқыту курсымен танысыңыз
Жаңа мүмкіндіктерге бірінші болып қол жеткізу
Office Insider бағдарламасына қосылу

Осы ақпарат пайдалы болды ма?

Пікіріңіз үшін рақмет!

Пікіріңізге рақмет! Сізді Office қолдау көрсету қызметіндегі агенттердің бірімен байланыстырған жөн болуы мүмкін.