Database for VB non-Alphabetical

[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.

[EricJ]

if it's vb.net you can set the combobox.sorted property to true
"Bobby" <an*******@discussions.microsoft.com> wrote in message
news:0d****************************@phx.gbl...

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.

[Phill. W]

"Bobby" <an*******@discussions.microsoft.com> wrote in message
news:0d****************************@phx.gbl...
.. . .

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.

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.

[Herfried K. Wagner [MVP]]

* "Bobby" <an*******@discussions.microsoft.com> scripsit:

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.

Give the databinding ng a try:

<news://news.microsoft.com/microsoft.public.dotnet.framework.windowsforms.dat abinding>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Herfried K. Wagner [MVP]]

* "EricJ" <ericRéMo**@ThiSomnipack.be> scripsit:

if it's vb.net you can set the combobox.sorted property to true

This will not work with a combobox attached to a datasource.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>