ADVERTISEMENT

Access: Create a query that accepts a "barcode" number as a parameter in Access 2003/XP/2000/97

---

Question:  In Access 2003/XP/2000/97, I'd to create a query where the user can enter a specific barcode number and view all of the entries pertaining to that number. How can I do this?

Answer:  You can create a parameter query that prompts for a barcode number.

To do this, first create your query.

Then enter your barcode parameter. Parameters should be enclosed in [] brackets as follows:

[Enter barcode]

This will create a parameter called [Enter barcode].

Next, you probably want to ensure that the user enters a valid number in the barcode parameter. To do this, select Parameters under the Query menu.

When the Query Parameters window appears, enter the parameter called [Enter barcode], and select Long Integer as the data type. Click on the OK button.

Now, when you run the query, you will be prompted to enter a barcode number.

Your query will then only return the records where the barcode matches the parameter value entered by the user.