|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 18th, 2010, 12:18 PM
posted to microsoft.public.access
|
|||
|
|||
Is Autocompletion Possible?
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! 
|
|
#2
March 18th, 2010, 12:38 PM
posted to microsoft.public.access
|
|||
|
|||
|
Is Autocompletion Possible?
Why not use a combo box?
-- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Faraz Ahmed Qureshi" wrote in message ... 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!
|
|
#3
March 18th, 2010, 01:25 PM
posted to microsoft.public.access
|
|||
|
|||
|
Is Autocompletion Possible?
You can with a combo box or look at www.allenbrowne.com for some insight.
-- Milton Purdy ACCESS State of Arkansas "Faraz Ahmed Qureshi" wrote: 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!
|
|
#4
March 18th, 2010, 01:34 PM
posted to microsoft.public.access
|
|||
|
|||
|
Is Autocompletion Possible?
"Faraz Ahmed Qureshi" wrote in message ... 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!
|
|
#5
March 19th, 2010, 04:50 AM
posted to microsoft.public.access
|
|||
|
|||
|
Is Autocompletion Possible?
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" wrote in message ... 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! .
|
|
#6
March 19th, 2010, 12:09 PM
posted to microsoft.public.access
|
|||
|
|||
|
Is Autocompletion Possible?
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" wrote in message ... 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" wrote in message ... 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! .
|
|
#7
March 19th, 2010, 06:14 PM
posted to microsoft.public.access
|
|||
|
|||
|
Is Autocompletion Possible?
"Douglas J. Steele" wrote in
: 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/
|
|
#8
March 19th, 2010, 09:11 PM
posted to microsoft.public.access
|
|||
|
|||
|
Is Autocompletion Possible?
Good point.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "David W. Fenton" wrote in message 36.94... "Douglas J. Steele" wrote in : 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/
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
