Using wildcards

[bodvoc]

Hi Guys

Tried searching on this but drawn-a-blank...........

I have fields in my db that hold a surname and a ref type... i.e....

Bloggs (R)

I need to use a wildcard in the query that will bring up Blo *, in short include spaces, and any ending of the primary search.... Can it be done???

Thanks in advance...

Bodvoc....

 

[dcx693]

Put this into your criteria line:
Like "Blo*"

 

[roelandkim]

You could also try putting the following in the criteria:

Like "*" & [enteparameterhere] & "*"

This will bring up anything with the criteria you specify.

 

[bodvoc]

You are a god, that worked great... Thanks for your time.. Bodvoc

 

[Mile-O]

Personally, I'd put a textbox on a form and a command button.

The user would type their search into the textbox and then click the command button.

It offers more functionality as you can check the query when you click the button and inform the user that there is no records, etc, and you can verified that what the user wans to search with is valid for that field. No pint in searching for numbers in a name field.

Like "*" & [Forms]![frmYourForm]![txtYourTextbox] & "*"

 

[bodvoc]

Cheers Mile-O-Phile

EXCELLENT!! Will try that....

Q. If I wanted the form that is based on a query to open with a new record instead of doing a search, any ideas how can I do that??

Cheers again

bodvoc

 

[Mile-O]

For a new record:

DoCmd.OpenForm "frmNameHere", acNormal, , , acFormAdd, acWindowNormal

 

[bodvoc]

Great, thanks for that.... all sorted out now...

 

[bodvoc]

Hi Mile-O-Phile

Ummm, don't know to word this given the take a mile quote..

Did what you suggested, now they want the same thig to work in the form it opens... can this be done??? I have tried, but.. the Form and text boxes open OK, but when you click the command button, nothing happens...

What am I doing wrong???

Thanks again........

Bodvoc.......

 

[Mile-O]

Can you detail this in much greater detail or post a '97 example of what you have thus far?

 

[Mile-O]

In fact, I'll cross reference with the other thread.

 

[bodvoc]

DONE IT

After leaving it for a bit, got it sussed! Just a syntax thing, to many "," and not enought thought... Thanks all for helping...

Bodvoc