William Hindman
wdhindman at bellsouth.net
Wed Mar 3 20:00:24 CST 2004
??? ...allright ...I'll bite ...are you answering her first query or the follow-on? :) William Hindman "My idea of an agreeable person is a person who agrees with me." Disraeli ----- Original Message ----- From: "John W. Colby" <jwcolby at colbyconsulting.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Wednesday, March 03, 2004 7:53 PM Subject: RE: [AccessD] Add All to List > The easiest way is to union a Select "*", "ALL" > > John W. Colby > www.ColbyConsulting.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William > Hindman > Sent: Wednesday, March 03, 2004 5:07 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Add All to List > > > ...the easiest way is to "if" the combo's after update event :) > > After Update Event cboCustomer > If Me![cboCustomer] = "<All>" Then > DoCmd ShowAllRecords > Else > DoCmd ApplyFilter , "[State] = Forms![cboCustomer]![cboCustomer]" > End If > > William Hindman "My idea of an agreeable person is a person who agrees with > me." Disraeli > > ----- Original Message ----- > From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Wednesday, March 03, 2004 4:29 PM > Subject: RE: [AccessD] Add All to List > > > > I don't know what I am doing wrong.... The all shows at the top of the > list, > > but All the records do not show on the subform. The combobox is still > > showing the first record when it opens and the subform is filtered for > that > > record. > > > > What makes the All part of "ALL" in the combo box work? > > > > Virginia > > > > -----Original Message----- > > From: William Hindman [mailto:wdhindman at bellsouth.net] > > Sent: Wednesday, March 03, 2004 8:09 AM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Add All to List > > > > > > Virginia > > > > ...use a UNION SELECT in the combo record source to add an ALL. > > > > ...example: > > > > SELECT DISTINCTROW Customers.Company, Customers.[Customer Number] FROM > > Customers UNION SELECT "<ALL>","" FROM Customers ORDER BY > Customers.Company; > > > > William Hindman "My idea of an agreeable person is a person who agrees > with > > me." Disraeli > > > > ----- Original Message ----- > > From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com> > > To: <accessd at databaseadvisors.com> > > Sent: Wednesday, March 03, 2004 8:45 AM > > Subject: [AccessD] Add All to List > > > > > > > How do you add All to List? This form contains 2 combo boxes on a main > > form. > > > Selecting data shows data on a subform for the related combo box > choices. > > > > > > I need to either have an All in the combo boxes or when the form opens, > I > > > would like them to be blank. > > > > > > I tried this code in the On Open of the main form, but it still opens > to > > > the first record with entries in both combo boxes. > > > > > > With Me > > > .cboNCSANo = "" > > > .cboProcedure = "" > > > End With > > > > > > Virginia > > > -- > > > _______________________________________________ > > > 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 > > -- > > _______________________________________________ > > 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 > > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >