Text Box Search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 25 Jan 2008 15:16 GMT

    Is it possible to use a Query to search for terms in a text box? I
had the bright idea to cut down on key strokes through a form by using a
code for a number of entries instead of pull down lists and or yes/no
fields. However I'm unable to make a Query that will do the job I want.

    A text box would look something like the following and I'd be wanting
to search on any term or combination of terms entered.

    *Eduard 0716. KB. MC. LD. PR. DB. SEC. [and so on.....]

    If it can't be done I guess yes/no fields would be my next best bet.

    Thank you. cheers - Jim.

Reply to this Message

John Spencer - 25 Jan 2008 15:33 GMT

Dp you have all the codes in ONE field or in multiple fields.

If in one field, you can search for one value using criteria like
Like "*" & [Find code] & "*"

Finding a combination of terms with that structure is much more difficult.

Signature

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Is it possible to use a Query to search for terms in a text box? I had
> the bright idea to cut down on key strokes through a form by using a code
[quoted text clipped - 9 lines]
>
> Thank you. cheers - Jim.

Reply to this Message

Klatuu - 25 Jan 2008 21:32 GMT

A List Box set to Multi Select might be the answer. See VBA Help for the
Items Selected property. It will show you how to loop through the selected
items. I can't give much more info because I don't know how you are doing
the search.

Signature

Dave Hargis, Microsoft Access MVP

> Is it possible to use a Query to search for terms in a text box? I
> had the bright idea to cut down on key strokes through a form by using a
[quoted text clipped - 9 lines]
>
> Thank you. cheers - Jim.

Reply to this Message

Jim - 29 Jan 2008 14:16 GMT

> Is it possible to use a Query to search for terms in a text box?
> I had the bright idea to cut down on key strokes through a form by using
[quoted text clipped - 9 lines]
>
> Thank you. cheers - Jim.

********** If anyone had a reply to this question I'd request a reprint.
My IP failed to bring in any messages from this newsgroup for the last
four days but today seems to be back in business. So if anyone replied
I'd appreciate a reprint - if no one replied - oh well :-)

Cheers and thanks again. Jim.

Reply to this Message

John W. Vinson - 30 Jan 2008 01:11 GMT

>> Is it possible to use a Query to search for terms in a text box?
>> I had the bright idea to cut down on key strokes through a form by using
[quoted text clipped - 16 lines]
>
> Cheers and thanks again. Jim.

I don't think I replied but....

Storing multiple disparate pieces of information in one field is NOT a good
idea. It will make data entry HARDER not easier - with autocomplete a textbox
can fill in SEC with two keystrokes (S and <Tab>) if that's the only code
beginning with S; you won't get typos like DBB where DB was intended; you will
be able to *SEARCH* your data effectively rather than using convoluted
substring queries.

Yes/no fields would be a tiny bit better but still not good.

Would a multiselect Listbox (where the user can simply click on the desired
entries) work? Or a Subform with one code per row?

John W. Vinson [MVP]

Reply to this Message