Database for VB non-Alphabetical

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Hi. I am working on checking and adding to an Access 2000
database. The database is being used in a Visual Basic
application. I don't know much about technology so i
would need an easy-to-understand answer, if possible.
(The database is divided into five categories.) After I
have added to or edited some entries and then go to the
program itself, the various drop down boxes are supposed
to show the entries in alphabetical order but sometimes
they are not. The names seem to be random at times.

Can anyone help? Thanks, Bobby.
 
.. . .
After I have added to or edited some entries and then go to the
program itself, the various drop down boxes are supposed
to show the entries in alphabetical order but sometimes
they are not. The names seem to be random at times.
Click to expand...

If you fill the drop-downs "long-hand" (i.e. reading from database
and inserting the items in a loop), set the ComboBox's Sorted
property to True.

If the ComboBoxes are data-bound (Yuk!), add an "Order By"
clause to the SQL used to retrieve the values.

HTH,
Phill W.
 
* "EricJ said:
if it's vb.net you can set the combobox.sorted property to true
Click to expand...

This will not work with a combobox attached to a datasource.
 
* "Bobby said:
Hi. I am working on checking and adding to an Access 2000
database. The database is being used in a Visual Basic
application. I don't know much about technology so i
would need an easy-to-understand answer, if possible.
(The database is divided into five categories.) After I
have added to or edited some entries and then go to the
program itself, the various drop down boxes are supposed
to show the entries in alphabetical order but sometimes
they are not. The names seem to be random at times.
Click to expand...

Give the databinding ng a try:

<
 
Back
Top