Parameters

Resolved · Medium Priority · Version 2010

Wed 27 Jul 2011, 16:41 Delegate Jassen said...

Jassen has attended:
Access Intermediate course

Parameters

How do you create a field that prompts a user to enter an import for a query using a wildcard?

Fri 29 Jul 2011, 12:28 Trainer Anthony said...

RE: Parameters

Hi Jassen, thanks for your query. What you need is called a Parameter Query. There's a useful walkthrough right here:

http://www.techonthenet.com/access/queries/parameter3.php

Hope this helps,

Anthony

Thu 4 Aug 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips