Darren DICK
d.dick at uws.edu.au
Fri Jan 16 01:06:58 CST 2004
Thanks Handy Man ----- Original Message ----- From: <handyman at actcom.co.il> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Friday, January 16, 2004 4:49 PM Subject: Re: [AccessD] A2K: Is it possible....? > > These links might help you do what you want. > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office03022000.asp > http://members.iinet.net.au/~allenbrowne/ser-07.html > > gm > > At 04:18 PM, 1/16/2004 +1100, you wrote: > >Hello all > >I have a combo box fed by a simple SQL > >Me.cboMycombo.rowsource = "SELECT tblMyTable.* FROM tblMyTable;" > >So far so good. If there are 5 items in tblMyTable I expect to see 5 items > >in the combo box. > > > >Here's the tricky Bit. > >Say I want to add a 6th entry that is really just a line of text that is > >not in the table > >A string something like "<None of the Items in this List>" then have the > >'real' 5 or so items > >from the table in addition to the 1 line of text > > > >Make sense? > > > >Many thanks in advance > > > >Darren > > > >_______________________________________________ > >AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > >Website: http://www.databaseadvisors.com > > Gershon Markowitz > mailto:Handyman at actcom.co.il > http://www.yadchaimtzvi.org > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com