Is Autocompletion Possible?
in [General]
|
Prev: I want to ask this question
Next: Passing Arguments
From: Douglas J. Steele on 19 Mar 2010 08:09 Are you concerned that the combo box won't have anything in it if the table doesn't have anything in it? How is that any different than having a text box? You can set the RowSource property of the combo box to SELECT DISTINCT Full_Name FROM MyTable ORDER BY Full_Name Remember that you need to set the combo box's LimitToList property to True, and put code in its NotInList event to add new entries to the table. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Faraz Ahmed Qureshi" <FarazAhmedQureshi(a)discussions.microsoft.com> wrote in message news:E4E8F32A-6D5A-48E0-BB98-B50ED6B14FEE(a)microsoft.com... > Thanx DJ > > The only reason is that How can I have a combo made up of the field > itself? > In other words it seems quite wierd to have a field like Full_Name being > presented in a combo manner showing not even a single entry at the first > records. Having a code to record new entry be added to the combo box > everytime. However, in case of a case being repeated, presenting only the > unique names only once? > > -- > Thanx & Best Regards, > > Faraz! > > > "Douglas J. Steele" wrote: > >> Why not use a combo box? >> >> -- >> Doug Steele, Microsoft Access MVP >> http://www.AccessMVP.com/DJSteele >> (no e-mails, please!) >> >> "Faraz Ahmed Qureshi" <FarazAhmedQureshi(a)discussions.microsoft.com> wrote >> in >> message news:C4B23A4C-739D-48AD-98BC-7EED00FC0CF9(a)microsoft.com... >> >I want to have a sort of autocompletion be available so as to help in >> > completing a field, if recording any entry similar to already existing >> > one, >> > only at a few clicks, instead of inserting a Full Name everytime. >> > -- >> > Thanx & Best Regards, >> > >> > Faraz! >> >> >> . >>
From: David W. Fenton on 19 Mar 2010 14:14 "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in news:uEcv3z1xKHA.1548(a)TK2MSFTNGP02.phx.gbl: > You can set the RowSource property of the combo box to > > SELECT DISTINCT Full_Name > FROM MyTable > ORDER BY Full_Name Probably better to have: SELECT DISTINCT Full_Name FROM MyTable WHERE Full_Name Is Not Null ORDER BY Full_Name Otherwise, you end up with a blank entry in the dropdown list, which does nobody any good. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
From: Douglas J. Steele on 19 Mar 2010 17:11
Good point. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message news:Xns9D4090F21F67Bf99a49ed1d0c49c5bbb2(a)74.209.136.94... > "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in > news:uEcv3z1xKHA.1548(a)TK2MSFTNGP02.phx.gbl: > >> You can set the RowSource property of the combo box to >> >> SELECT DISTINCT Full_Name >> FROM MyTable >> ORDER BY Full_Name > > Probably better to have: > > SELECT DISTINCT Full_Name > FROM MyTable > WHERE Full_Name Is Not Null > ORDER BY Full_Name > > Otherwise, you end up with a blank entry in the dropdown list, which > does nobody any good. > > -- > David W. Fenton http://www.dfenton.com/ > usenet at dfenton dot com http://www.dfenton.com/DFA/ |