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
|
|||
|
|||
Combo Boxes
Hi
Database: Symbols Database is filled with data from apple to zebra - therefore using every letter in the alphabet. Is it possible in Access, that when a user selects a combox box and they type the first letter in a word e.g "p" that the combo box scrolls to the first word beginning with p. I hope i have explained this clearly. Also is it possible that when a user adds data to a database it is automatically sorted in ascending order. Thanks |
#2
|
|||
|
|||
Combo Boxes
Set the "Auto Expand" property to true for the combobox.
As far as sorting, work in a form, not the table, and you will be able to control the sorting -- Rick B "microsoft" wrote in message ... Hi Database: Symbols Database is filled with data from apple to zebra - therefore using every letter in the alphabet. Is it possible in Access, that when a user selects a combox box and they type the first letter in a word e.g "p" that the combo box scrolls to the first word beginning with p. I hope i have explained this clearly. Also is it possible that when a user adds data to a database it is automatically sorted in ascending order. Thanks |
#3
|
|||
|
|||
Combo Boxes
The autoexpand field is already set to Yes and I still am not achieving this
goal. Please explain the last comment where you inidicated that I should work in a form not the table to control the sorting. "Rick B" wrote: Set the "Auto Expand" property to true for the combobox. As far as sorting, work in a form, not the table, and you will be able to control the sorting -- Rick B "microsoft" wrote in message ... Hi Database: Symbols Database is filled with data from apple to zebra - therefore using every letter in the alphabet. Is it possible in Access, that when a user selects a combox box and they type the first letter in a word e.g "p" that the combo box scrolls to the first word beginning with p. I hope i have explained this clearly. Also is it possible that when a user adds data to a database it is automatically sorted in ascending order. Thanks |
#4
|
|||
|
|||
Combo Boxes
Tables are simply buckets that store your records. They have no explicit
sort order. They are not intended to be used as a user interface. When you add/change/delete records, you should be doing so in a form, not in the table. Once your database is created, you should rarely open your tables again. -- Rick B "microsoft" wrote in message ... The autoexpand field is already set to Yes and I still am not achieving this goal. Please explain the last comment where you inidicated that I should work in a form not the table to control the sorting. "Rick B" wrote: Set the "Auto Expand" property to true for the combobox. As far as sorting, work in a form, not the table, and you will be able to control the sorting -- Rick B "microsoft" wrote in message ... Hi Database: Symbols Database is filled with data from apple to zebra - therefore using every letter in the alphabet. Is it possible in Access, that when a user selects a combox box and they type the first letter in a word e.g "p" that the combo box scrolls to the first word beginning with p. I hope i have explained this clearly. Also is it possible that when a user adds data to a database it is automatically sorted in ascending order. Thanks |
#5
|
|||
|
|||
Combo Boxes
Granted, I understand what you are saying, however when my user adds a new
record via the form interface. When the user goes to the combo box the data entered is shown as the last in the combo and is not placed in its alphabetical order. Is it possible to have the data entered into the system and placed /sorted to its correct location in the database. "Rick B" wrote: Tables are simply buckets that store your records. They have no explicit sort order. They are not intended to be used as a user interface. When you add/change/delete records, you should be doing so in a form, not in the table. Once your database is created, you should rarely open your tables again. -- Rick B "microsoft" wrote in message ... The autoexpand field is already set to Yes and I still am not achieving this goal. Please explain the last comment where you inidicated that I should work in a form not the table to control the sorting. "Rick B" wrote: Set the "Auto Expand" property to true for the combobox. As far as sorting, work in a form, not the table, and you will be able to control the sorting -- Rick B "microsoft" wrote in message ... Hi Database: Symbols Database is filled with data from apple to zebra - therefore using every letter in the alphabet. Is it possible in Access, that when a user selects a combox box and they type the first letter in a word e.g "p" that the combo box scrolls to the first word beginning with p. I hope i have explained this clearly. Also is it possible that when a user adds data to a database it is automatically sorted in ascending order. Thanks |
#6
|
|||
|
|||
Combo Boxes
Then adjust the record source of your combo box. Your row source is a
table/query. Make it a query and set a sort order. -- Rick B "microsoft" wrote in message ... Granted, I understand what you are saying, however when my user adds a new record via the form interface. When the user goes to the combo box the data entered is shown as the last in the combo and is not placed in its alphabetical order. Is it possible to have the data entered into the system and placed /sorted to its correct location in the database. "Rick B" wrote: Tables are simply buckets that store your records. They have no explicit sort order. They are not intended to be used as a user interface. When you add/change/delete records, you should be doing so in a form, not in the table. Once your database is created, you should rarely open your tables again. -- Rick B "microsoft" wrote in message ... The autoexpand field is already set to Yes and I still am not achieving this goal. Please explain the last comment where you inidicated that I should work in a form not the table to control the sorting. "Rick B" wrote: Set the "Auto Expand" property to true for the combobox. As far as sorting, work in a form, not the table, and you will be able to control the sorting -- Rick B "microsoft" wrote in message ... Hi Database: Symbols Database is filled with data from apple to zebra - therefore using every letter in the alphabet. Is it possible in Access, that when a user selects a combox box and they type the first letter in a word e.g "p" that the combo box scrolls to the first word beginning with p. I hope i have explained this clearly. Also is it possible that when a user adds data to a database it is automatically sorted in ascending order. Thanks |
#7
|
|||
|
|||
Combo Boxes
Do you know how to sort records via the form so that the records show as you
like? A combo box has an asscoiated query where you can limit how the dtaa is displayed via the Combno Box. NWO. "microsoft" wrote: Granted, I understand what you are saying, however when my user adds a new record via the form interface. When the user goes to the combo box the data entered is shown as the last in the combo and is not placed in its alphabetical order. Is it possible to have the data entered into the system and placed /sorted to its correct location in the database. "Rick B" wrote: Tables are simply buckets that store your records. They have no explicit sort order. They are not intended to be used as a user interface. When you add/change/delete records, you should be doing so in a form, not in the table. Once your database is created, you should rarely open your tables again. -- Rick B "microsoft" wrote in message ... The autoexpand field is already set to Yes and I still am not achieving this goal. Please explain the last comment where you inidicated that I should work in a form not the table to control the sorting. "Rick B" wrote: Set the "Auto Expand" property to true for the combobox. As far as sorting, work in a form, not the table, and you will be able to control the sorting -- Rick B "microsoft" wrote in message ... Hi Database: Symbols Database is filled with data from apple to zebra - therefore using every letter in the alphabet. Is it possible in Access, that when a user selects a combox box and they type the first letter in a word e.g "p" that the combo box scrolls to the first word beginning with p. I hope i have explained this clearly. Also is it possible that when a user adds data to a database it is automatically sorted in ascending order. Thanks |
#8
|
|||
|
|||
Combo Boxes
I'm having the same problem with sorting. I went into the form and changed
the row source in properties...from "table/query" to "query", as Rick suggested. How do I set a sort order? When I changed the row source to query and opened the form, it no longer gave me the list. The arrow still showed up, but the box was just empty. I'm new to creating databases, and am in a position where I have to learn as I go...so any help is much appreciated. "NWO" wrote: Do you know how to sort records via the form so that the records show as you like? A combo box has an asscoiated query where you can limit how the dtaa is displayed via the Combno Box. NWO. "microsoft" wrote: Granted, I understand what you are saying, however when my user adds a new record via the form interface. When the user goes to the combo box the data entered is shown as the last in the combo and is not placed in its alphabetical order. Is it possible to have the data entered into the system and placed /sorted to its correct location in the database. "Rick B" wrote: Tables are simply buckets that store your records. They have no explicit sort order. They are not intended to be used as a user interface. When you add/change/delete records, you should be doing so in a form, not in the table. Once your database is created, you should rarely open your tables again. -- Rick B "microsoft" wrote in message ... The autoexpand field is already set to Yes and I still am not achieving this goal. Please explain the last comment where you inidicated that I should work in a form not the table to control the sorting. "Rick B" wrote: Set the "Auto Expand" property to true for the combobox. As far as sorting, work in a form, not the table, and you will be able to control the sorting -- Rick B "microsoft" wrote in message ... Hi Database: Symbols Database is filled with data from apple to zebra - therefore using every letter in the alphabet. Is it possible in Access, that when a user selects a combox box and they type the first letter in a word e.g "p" that the combo box scrolls to the first word beginning with p. I hope i have explained this clearly. Also is it possible that when a user adds data to a database it is automatically sorted in ascending order. Thanks |
#9
|
|||
|
|||
In the query sort the field that contains "apples" to "zebra" in ascending order. When you type a "p" in the combo and you have "peach", "pet", and "pie", "peach" will pop up. If you continue typing "i", "pie" will show. If you have a lot of items that begin with the same first say three letters, they will be in order if you use the dropdown arrow on the combobox and you shouldn't have to scroll too far.
To me, it is too complicated and hit and miss to try to sort in a form. It should take only a couple of minutes to create a query and then insert a combo based on that query in the form. Quote:
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Confused about 3 combo boxes | esparzaone | New Users | 1 | April 28th, 2005 01:06 PM |
Continuous subforms, combo boxes, and making them dependent | David Walker | Using Forms | 3 | July 26th, 2004 08:35 PM |
Combo Boxes #1 | Tom | Using Forms | 0 | June 9th, 2004 03:50 AM |
Data Dependencies between Combo Boxes | Tom | Using Forms | 7 | June 6th, 2004 05:25 PM |
Multiple combo boxes | Lee | Worksheet Functions | 2 | May 6th, 2004 02:49 PM |