Solved Slow Search on Subform

[Minty]

That sounds as if you have locked all the controls on the form, not just specific ones?

If it worked fine before I would fix the original problem. Have a search on here for locking certain fields. Look for posts involving the tag property.

 

[DatabaseTash]

That sounds as if you have locked all the controls on the form, not just specific ones?

If it worked fine before I would fix the original problem. Have a search on here for locking certain fields. Look for posts involving the tag property.

Thanks, I did try the tag property method and a few others and had many problems. Guess I will have to have to just settle for a slow search for the time being.

Thanks for your help

 

[DatabaseTash]

Just wanted to let you know I worked out the issue!

I did a compact and repair on the backend and it searches SO fast now! The backend file went from 211,284kb to 7,668kb.

Thanks for all the input guys!

 

[pbaldy]

Glad you got it sorted out.

 

[CJ_London]

come to this late but if your users typically search for the numbers, then assuming they know the first few, in your table split the text and numbers into two fields, both indexed. If they know the first few numbers, you can avoid using the initial * and therefore make use of the indexing. I don't include the initial * in my apps, but train users to include an initial * if they need to (or provide a 'begins with/ends with/contains option box).

Many of of those I've trained become interested in what else they can do with wildcards so I provide a short training session explaining the other wild cards and how you can use them.

 

[DatabaseTash]

come to this late but if your users typically search for the numbers, then assuming they know the first few, in your table split the text and numbers into two fields, both indexed. If they know the first few numbers, you can avoid using the initial * and therefore make use of the indexing. I don't include the initial * in my apps, but train users to include an initial * if they need to (or provide a 'begins with/ends with/contains option box).

Many of of those I've trained become interested in what else they can do with wildcards so I provide a short training session explaining the other wild cards and how you can use them.

Thanks CJ London. Seems to be working well so will leave it alone while it is working.