473,322 Members | 1,806 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Selecting "ALL" items from a Combo Box

If one is using a query as a Row Source on a Form, is there a way to
set up a blank space, or to insert the word "ALL" in a combo box that
represents ALL combo box row items.

The scenario is as follows. I have two combo boxes. One for
COURSECODEs and one for SECTIONCODEs. I select a COURSECODE from teh
1st combo box. Then, from the 2nd combo box I want to select ALL
SECTIONCODEs (associated with the COURSECODE).

This is for MS Access 2002.

Many thanks in advance.

Marcus
******

Nov 13 '05 #1
3 4461
"to*******@yahoo.ca" <to*******@yahoo.ca> wrote in
news:11**********************@l41g2000cwc.googlegr oups.com:
If one is using a query as a Row Source on a Form, is there a
way to set up a blank space, or to insert the word "ALL" in a
combo box that represents ALL combo box row items.

The scenario is as follows. I have two combo boxes. One for
COURSECODEs and one for SECTIONCODEs. I select a COURSECODE
from teh 1st combo box. Then, from the 2nd combo box I want to
select ALL SECTIONCODEs (associated with the COURSECODE).

This is for MS Access 2002.

Many thanks in advance.

Marcus
******


You'll need to create a union query based on your your current
row source. You must do this from the VIEW SQL mode of the query
builder.

Select " << ALL >>" as SECTIONCODE from SECTIONCODES UNION Select
SECTIONCODE from SECTIONCODES ;

The number and names of fields added must match in the two select
statements.

A more difficult question is how to process the " << ALL >> "
option when you select it.
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #2
Many thanks to both Bob and Pietlin

Marcus
*********

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ones Self | last post by:
Hi, I have a tree structure which is maintained through the use of a path enumerated column: CREATE TABLE items ( item_id NUMERIC NOT NULL, path VARCHAR2(64) NOT NULL );
3
by: Gumtree | last post by:
Hi folks, The user interface I'm trying to impliment looks a bit like this: Not Chosen Chosen .------------. .------------. |Item 1 | -> |Item 3 | |Item 2 | <-...
3
by: james.dixon | last post by:
Hi I was wondering if anyone else had had this problem before (can't find anything on the web about it). I have three select elements (list boxes - from here on I'll refer to them as 'the...
3
by: Adam Toline | last post by:
In reference to the following: http://www.bellecose.com/form.htm At the top of each column there is a box for "All". When one is checked I need to check all of (and only) those boxes...
3
by: Bry | last post by:
I know you can select a single item in a list view using the following code listView.Items.Selected = true; Is it possible to do this for all items in the listView control without using a...
3
by: Jonesgj | last post by:
Chaps, How would I select all items in a listbox using code? I'm sure its an easy one but .... Thanks
2
by: bhdvir | last post by:
Does anybody have any advice on selecting all records within a iif-statement? I have a form in which one has to state if all projects or just a selection of projects are to be used for a query....
4
by: Duncan Smith | last post by:
So far, the quikest way I have found to select all items in a list box is to turn off updates, set a wait cusror and then call SetSelected on each item (see below), but it's too slow when the...
3
by: kimiraikkonen | last post by:
Hi, I want to display ALL the items (includes unselected items) of listbox control. How can i code this? Should i use "for each" or other? For example: Assume you have a listbox with 3 items...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.