Hi guys. I got unbounded form that I want to add searching functionality by utilizing indexes. I would like to know how to add indexes for my customer table so that I can use it for searching records. I be happy if some one help with make indexes. Thanks


http://i5.photobucket.com/albums/y18...abledesign.jpg


==> pic of my customer table in design view

Hmmm.. not really sure what you are after... but I sense you arent either.

Your table has an index on the ID field anyway... you could put one on the text field, but not sure it is going to help that much really.
If you wanna put one on it... when in design view, just go >View >Indexes and add it in, if it isnt already, which it probably will be, knowing Access!
You've posted this in the VB section, so you might imagine this would be done in VB, it can be.. just not sure why you'd want to?

But like I say, I doubt this is actually what you asking...

I can't really see why you would need to do this either, but the code you would need is

DoCmd.RunSQL "CREATE INDEX A on [table-name] (field1, field2, ....) [WITH PRIMARY]"

where A is the name of the index (it doesn't matter what it's called), the field list allows you to make a compound index, and if the index is NOT Primary omit the [WITH PRIMARY]

So glad I'm not the only one who is missing the whole point of this one!