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

Thanks Bill!

I also found this, by Ken Getz, 'Creating Combo Boxes in Access 2007 that
Allow Users to Select N/A' (
http://msdn.microsoft.com/en-us/library/dd671280.aspx).



On Fri, Jul 17, 2009 at 10:27 AM, Bill Patten <bill_patten at embarqmail.com>wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Jeff Barrows