WIldcard searching

#1

Hi there
I have setup a search form that runs a selected query after a name
(text string) is enter.
Code from query - Like [Forms]![frmNameQueryMenu]![TextName]
eg An exact search happens for "Green" unless "*Green*" is entered.

It would be a simplier and tidy if only "Green" was entered.
is there a solution I have overlooked?

Cheers
Duncan

#2

"Duncan" <duncanjx (AT) optusnet (DOT) com.au> wrote

Quote:

Hi there
I have setup a search form that runs a selected query after a name
(text string) is enter.
Code from query - Like [Forms]![frmNameQueryMenu]![TextName]
eg An exact search happens for "Green" unless "*Green*" is entered.

It would be a simplier and tidy if only "Green" was entered.
is there a solution I have overlooked?

Cheers
Duncan

Like "*" & [Forms]![frmNameQueryMenu]![TextName] & "*"

#3

On Nov 11, 7:53*am, "paii, ron" <n... (AT) not (DOT) com> wrote:

Quote:

"Duncan" <dunca... (AT) optusnet (DOT) com.au> wrote in message

news:d7bbb080-388a-45af-aa74-259aec79e308 (AT) z22g2000pri (DOT) googlegroups.com...

Hi there
I have setup a search form that runs a selected query after a name
(text string) is enter.
Code from query *- Like [Forms]![frmNameQueryMenu]![TextName]
eg An exact search happens for "Green" unless "*Green*" is entered.

It would be a simplier and tidy if only "Green" was entered.
is there a solution I have overlooked?

Cheers
Duncan

Like "*" & [Forms]![frmNameQueryMenu]![TextName] & "*"

Oh my god that simple!!!!
Works a treat

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

WIldcard searching

comp.databases.ms-access comp.databases.ms-access

WIldcard searching - 11-10-2010 , 03:38 PM

Re: WIldcard searching - 11-10-2010 , 03:53 PM

Re: WIldcard searching - 11-10-2010 , 04:14 PM