A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo Boxes



 
 
Thread Tools Display Modes
  #1  
Old November 15th, 2005, 03:47 PM
microsoft
external usenet poster
 
Posts: n/a
Default 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  
Old November 15th, 2005, 04:10 PM
Rick B
external usenet poster
 
Posts: n/a
Default 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  
Old November 15th, 2005, 05:29 PM
microsoft
external usenet poster
 
Posts: n/a
Default 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  
Old November 15th, 2005, 05:46 PM
Rick B
external usenet poster
 
Posts: n/a
Default 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  
Old November 15th, 2005, 06:32 PM
microsoft
external usenet poster
 
Posts: n/a
Default 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  
Old November 15th, 2005, 07:07 PM
Rick B
external usenet poster
 
Posts: n/a
Default 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  
Old November 15th, 2005, 11:46 PM
NWO
external usenet poster
 
Posts: n/a
Default 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  
Old November 16th, 2005, 04:09 PM
Jen
external usenet poster
 
Posts: n/a
Default 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  
Old November 16th, 2005, 11:18 PM
Bob Miller Bob Miller is offline
Senior Member
 
First recorded activity by OfficeFrustration: May 2005
Posts: 358
Default

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:
Originally Posted by Jen
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





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.