Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

ms-access-course - criteria in queries

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms-access-course - Criteria In Queries

ms-access-course - Criteria In Queries

ResolvedVersion Standard

tina has attended:
Access Introduction course

Criteria In Queries

How do I set changeable criteria in queries?

RE: Criteria In Queries

If you use square brackets in the criteria field

eg. [criteria here]

then access will prompt you to enter the value when the query is run.

Access tip:

Pop up property

If you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.