Select All Names

[Robert T]

We have a form with a combo box and that combo box executes a query to find
all of the records matching the user's name. The query derives that value
from a form based parameter called vName.

This is how the process works.

1. The user starts by selecting their name via a drop down list combo box on
a dialog form.
2. That selection becomes the value of vName.
3. The user clicks OK and then moves to the data entry form.
4. On the data entry form, the user then clicks on another combo box which
runs the aforementined query, which in turn uses the value of the variable
vName to find only those records which match vName.

That works great, however, a new problem arose yesterday. One of the users
asked for the option to query ALL names via the Combo Box on the data entry
form. I went back to dialog fom and tried everything I could think of, such
as giving them a drop down choice of "Is Not Null", but nothing worked. Any
suggestions would be appreciated.

Thanks,
Robert

 

[Brendan Reynolds]

We have a form with a combo box and that combo box executes a query to
find
all of the records matching the user's name. The query derives that value
from a form based parameter called vName.

This is how the process works.

1. The user starts by selecting their name via a drop down list combo box
on
a dialog form.
2. That selection becomes the value of vName.
3. The user clicks OK and then moves to the data entry form.
4. On the data entry form, the user then clicks on another combo box which
runs the aforementined query, which in turn uses the value of the variable
vName to find only those records which match vName.

That works great, however, a new problem arose yesterday. One of the users
asked for the option to query ALL names via the Combo Box on the data
entry
form. I went back to dialog fom and tried everything I could think of,
such
as giving them a drop down choice of "Is Not Null", but nothing worked.
Any
suggestions would be appreciated.

Thanks,
Robert

There are links to examples of how to do this in various versions of Access
at the following URL ...

http://www.google.ie/search?hl=en&q=select+all+combo+box+access+microsoft+form

 

[Klatuu]

You can use a Union query to add All as an option to your combo. Here is an
example:

SELECT 0 As ID, "(All)" As Dummy FROM dbo_Initiative UNION SELECT StatusID,
StatusDescr FROM dbo_ProjectStatus;