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

action queries

ResolvedVersion 2003

Olyemisi has attended:
Access VBA course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Project Intro Intermediate course

Action Queries

under a query, where you have a *IT* can you query benefit as a query. e.g Benefit IT Office

RE: Action Queries

Dear Olyemisi

Thank you for attending Access Courses. I hope you enjoyed courses and have started to put them into practice.

Sammie who was in the same training has also asked teh same question. Therefore I am copying and pasting the response.

I am not sure it this is the definite answer but you can try this and I am confident that it will work

In the Job Title field in the Design View of the Query type the following:

* IT (Please note that there is a space between * and IT)
IT *
* IT * (Please note that there is space before and after IT)

This should be entered in the same line on the Job Title field.

Please try it and tell me if that helps you or not.

I hope this has helped in answering your query. If this has answered your question then may I please request you to mark this post as resolved!!

Many thanks

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub


3. Open your form in Form View and use the TAB key to make sure it works.

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.1 secs.