Combo box auto complete names

[Guest]

Hello all hopefully someone can help me.

Recently all my Combo boxes don't auto complete the names in the table. What
I used to be able to do was start typing a name and the combo box would go
down the list to the nearest available record. It is very confusing and
strange, now it just sits there and I have to type the whole value or scroll
down the list.

I can create a new combo box using the wizard and it will actually do it
correctly until I close the database and open it again then it doesn't work
anymore. I have found one combo box which still works it is a value list with
4 records. Is there perhaps a limit to a combo box when it stops auto
completing? that would be strange since it works when newly created.

Any assistance would be appriciated.

 

[Guest]

Hi Jens,

This is indeed strange behavior. It sounds like your database may be
starting to corrupt. Are you up-to-date on service packs for your operating
system, your version of Office, and the JET database engine? Here is a KB
article that includes directions for checking all of this:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528

Now would probably be a good time to create a new database, and then import
all objects, one group at a time, into your new database. In other words,
import all tables (but not linked tables), then import all queries, then all
forms, etc. While Access will allow you to import all objects in one
operation, the experts at FMS, Inc. (a Microsoft Partner), have stated that
it is best to import objects one group at a time. Recreate any linked tables
from scratch. When importing local tables, make sure to check the option to
import relationships, menus and toolsbars, and import/export specs. If any of
the local tables in the source DB are hidden, you'll need to first unhide
them.

You will need to set the checked references to match the source database,
along with any startup options set under Tools > Startup. You should disable
Name Autocorrect after creating the new container database. Going through
this process often times solves corruption problems, because you get a new
set of the hidden system tables (the tables whose names start with "MSYS").
These system tables are updated appropriately as you import objects.

This may sound like a lot of work, but it really isn't. Creating a new
container DB, disabling NameAutocorrect, importing all objects one group at a
time, and setting startup options and references to match the source DB is
usually a fairly quick procedure. When you are in the Visual Basic Editor, in
order to check that the references match the source DB, you should do a Debug

Compile ProjectName as well. You want to re-create any linked tables from

scratch, because Access can cache a lot of information about the links. Some
of this infomation may no longer be valid, so it's always best to recreate
the linked tables from scratch.

Good Luck,
Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hello all hopefully someone can help me.

Recently all my Combo boxes don't auto complete the names in the table. What
I used to be able to do was start typing a name and the combo box would go
down the list to the nearest available record. It is very confusing and
strange, now it just sits there and I have to type the whole value or scroll
down the list.

I can create a new combo box using the wizard and it will actually do it
correctly until I close the database and open it again then it doesn't work
anymore. I have found one combo box which still works it is a value list with
4 records. Is there perhaps a limit to a combo box when it stops auto
completing? that would be strange since it works when newly created.

Any assistance would be appriciated.

 

[Gary Walter]

Hello all hopefully someone can help me.

Recently all my Combo boxes don't auto complete the names in the table.
What
I used to be able to do was start typing a name and the combo box would go
down the list to the nearest available record. It is very confusing and
strange, now it just sits there and I have to type the whole value or
scroll
down the list.

I can create a new combo box using the wizard and it will actually do it
correctly until I close the database and open it again then it doesn't
work
anymore. I have found one combo box which still works it is a value list
with
4 records. Is there perhaps a limit to a combo box when it stops auto
completing? that would be strange since it works when newly created.

Hi Jens,

In addition to Tom's sage advice, is there a chance that you
enabled ANSI-92 SQL syntax (and your RowSources do not
contain DISTINCT)?

http://support.microsoft.com/?kbid=824189

I know its a wild shot, but had to ask.

good luck,

gary