[AccessD] Combo Box Values [Access 2003 / 2007]

Hi Jeff,

>From this list several years ago, this may help.


2/6/2006
Hi,

I know I saw something about how to do this discussed on this list.  How 
do I add the "All" indication at the top of a combobox list?  Thanks.

Tina

One way is something like this :

SELECT ID, Descr 
FROM Project
UNION 
SELECT 0 as t1,'(All)' as t2
     FROM Project " & _
   "ORDER BY Descr ASC;"

The UNION statement is the key here.

Bobby

Another way

SELECT -9999 AS Product_LID, "All" AS ProductDescription FROM PROD_Main
UNION 
SELECT Product_LID, ProductDescription FROM PROD_Main;

HTH
Bill

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Monday, February 06, 2006 10:23 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Adding "All" to Combo List






--------------------------------------------------
From: "Jeff Barrows" <jeff.developer at gmail.com>
Sent: Friday, July 17, 2009 7:50 AM
To: <accessd at databaseadvisors.com>
Subject: [AccessD] Combo Box Values [Access 2003 / 2007]

Sorry if this has been discussed before, but I could not find anything in
the archives.

I have a combo box (limited to list) using a query as the data source.  Now
I am told that the users need to be able to select one of two options that
are NOT in the list - EVER!  Basically the two additional options are
exceptions.  I seem to remember reading something about this years ago,
possibly in one of the ADHs, but I do not have them available right now.

Anyone else remember this or was it just wishful thinking?

-- 
Jeff Barrows
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com