Hi folks.
I'm doing a library system which contains a table caled "Member",
which in turn contains an ID key and the member's name. I have a combo
box which allows the user to pick a name from the combo box to view
that person's history of borowing books, etc. However, the combo box
is not sorted by name (its sorted by the ID key, which I kept hidden).
So how do I sort the combo box by name? Thank you.
2  22086 
On 20 Apr 2004 21:25:16 -0700, so**********@ho tmail.com (Aravind)
wrote: Hi folks.
I'm doing a library system which contains a table caled "Member",
which in turn contains an ID key and the member's name. I have a combo
box which allows the user to pick a name from the combo box to view
that person's history of borowing books, etc. However, the combo box
is not sorted by name (its sorted by the ID key, which I kept hidden).
So how do I sort the combo box by name? Thank you.
Select the combo-box in form design. Right click and activate
PROPERTIES (if the first time you do this the PROPERTIES box closes,
just do it a second time and it will reopen). Select the DATA tab.
Select the ROWSOURCE line. Click the elipses to the right (three dots
"..."). Click on the SHOW check box below the field with the member's
name. Save.
mike so**********@ho tmail.com (Aravind) wrote in message news:<61******* *************** ***@posting.goo gle.com>... Hi folks.
I'm doing a library system which contains a table caled "Member",
which in turn contains an ID key and the member's name. I have a combo
box which allows the user to pick a name from the combo box to view
that person's history of borowing books, etc. However, the combo box
is not sorted by name (its sorted by the ID key, which I kept hidden).
So how do I sort the combo box by name? Thank you.
Hello,
Set the name field to Ascending in the sort row for the
Row Source of your combo-box, whether it be a query or SQL.
Regards,
Ray This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: raj |
last post by:
When I try to sort my combo box I get the following error.
"Cannot sort a ComboBox that has a DataSource set. Sort the data using the
underlying data model."
--------------------------------THe code is given below.
String strSQL;
strSQL = "SELECT .......... WHERE C.Client = '" +
this.cboClient.SelectedValue + "' ";
|
by: Aravind |
last post by:
Hi folks.
I'm doing a library system which contains a table caled "Member",
which in turn contains an ID key and the member's name. I have a combo
box which allows the user to pick a name from the combo box to view
that person's history of borowing books, etc. However, the combo box
is not sorted by name (its sorted by the ID key, which I kept hidden).
So how do I sort the combo box by name? Thank you.
|
by: rquinnan |
last post by:
Good Evening all, I would greatly appreciate any assistance on this
Access 2003 quandary I'm in. And I do apologize if this has been
answered somewhere else, I didn't see one that addressed my problem
though. I'm looking to be able to sort multiple fields from a form
whose record source is a query of fields from a single table.
Background:
The default view is "Continuous Forms." and in the Form Header
section of the form's design, I...
|
by: Frustrated Developer via DotNetMonster.com |
last post by:
I have posted a couple times on here already and found the user community to
be very helpful. I took on a project before I realized how difficult a time
I'm having working with a database. Assistance would be greatly appreciated!
I am trying to allow certain users to be able to preview a database's
contents without being able to update which I've accomplished. I've created a
"Preview" button and set the datagrid to READ ONLY. Now I want...
|
by: Arnold |
last post by:
Greetings Gurus,
In a mainform's header, I have a combobox named comboStudents. The
rowsource for this combobox is:
SELECT -999 As StudentID, "<Add New Student>" As FullName, "aaa" As
LastName, "x" As FirstName From qryStudents UNION SELECT StudentID,
FullName, LastName, FirstName FROM qryStudents
ORDER BY LastName;
| | |
by: AccessIdiot |
last post by:
I have a combo box with a NotInList event on it that allows me to add a value through another form. When I return to the form that contains the combo box the value I added is at the bottom. How can I get the combo box to sort the values alphabetically so that the value is where it should be for the next record?
The control source is just a field, not a query, so there is no "sort by" option that I can find in the Properties.
thanks for any...
|
by: Kingkev83 |
last post by:
I have a problem, i use a combo box to display members details in the following format
display member: (concatinated field) Surname &' '& Forename &' '& MembershipNo & - & DateofBirth as `Memberdetails`
Valuemember : MembershipNo
I would like to sort the combo box by surname/MemberDetails but it currently only sorts by membershipNo. I have tried the sorted = true value which does sort by surname but does not sort the Valuemember:...
|
by: RZ15 |
last post by:
Hi guys,
I have made a form with a combo box listing fields that a user can sort by. I have a code that works for this when i have 4 levels to sort by. It is the following:
Private Sub cmdOK_Click()
Dim strSQL As String, intCounter As Integer
For intCounter = 1 to 4
If Me("cboSort" & intCounter) <> "" Then
|
by: pateras |
last post by:
I generate code to automatically create combo boxes to handle
relationships between tables:
http://pastebin.com/m59d8f5b0
The problem is, when I sort on any other column, the combo boxes all
get cleared. I've also noted that in doing so, I can no longer sort on
the column. I have a feeling that that might be related. Can anyone
tell me why the combo box
may be getting cleared and why I cannot sort based on the combo box
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
