how to use wildcards

[hendrikbez]

I want to use wildcards on these textboxes (4 of them)(BergPiek,Bergreeks,Provinsie and Land), only using one Search button "Soek Berg Naam" ,I want it to search only for 3 word and more eg. ?ea? must give me 4 words with letters e and a for second and third letters eg in the bottom part. Is this possible, and is there a sample of this.

[June7]

Are you using a dynamic parameterized query? Or are you using VBA to build filter criteria?

A query could be like:

SELECT * FROM table WHERE BergPiek LIKE "*" & Forms!formname.BergPiek & "*" AND Bergreeks LIKE "*" & Forms!formname.Bergreeks & "*" & AND Provinsie LIKE "*" & Forms!formname.Provinsie & "*" AND Land LIKE "*" & Forms!formname.Land & "*";

[orange]

Hendrik,

See this from M$oft re wildcards.
You have example usage in the crossword database I sent previously.

Good luck.

[hendrikbez]

Orange, I did try your info that you have send me, but got stuck at this line, see my code

Me.lstResults.RowSource = "Select Bergpiek FROM Berge " _
              & " where BergPiek Like '" & Forms!Berge!TXTBergpiek & "'" _
              & " AND fIncludeWord = 0 "

I am not sure what to use instead of Me.lstResults.RowSource =. I have all the fileds in the table and on the form see screeshot

[orange]

In the code I sent to you:
-in form design view go to the code foor the search button
-put a breakpoint on the Me.lstResults.Rowsource..... line
-go to form view
-run the code to the breakpoint
-then in the immediate window put ?TXTBergpiek

Here are 2 graphics from my database.

The contents of the searchtext box


the use of the immediate window


Note the value in the textbox includes the "*".

Perhaps I'm not following your requirement. I am leaving to play golf, but will be back later today.

[hendrikbez]

Orange

Enjoy your golf


As you can see in my form I have a few textboxes, the ones that I want to use is Bergpiek,bergreeks,provinsie and land.
on the buttonSoek berg naam, when I search for a word Bergpiek only it must use wildcards, when find the word or words, it must display it in the bottom, If I search bergreeks and the others the same must happen.

I have tryied it as you can see, but I do not know how to work the last code of yous, as you can see in top picture.

[June7]

Assuming users are NOT typing * into textboxes, include * in the code.

Me.lstResults.RowSource = "Select Bergpiek FROM Berge " _
              & " where BergPiek Like '*" & Forms!Berge!TXTBergpiek & "*'" _
              & " AND fIncludeWord = 0 "

[orange]

Hi again Hendrik,
I have returned from golf.
Tonight, I'll look at the database you sent and try to create a sample for you. But I do not use macros, I use vba.

[orange]

Hendrik,
Please describe the rules again.
Here is my understanding:
-4 textboxes are available (BergPiek,Bergreeks,Provinsie and Land )
-only 1 textbox can be filled for each search attempt, but it could be any of the 4 textboxes
-You enter a string of chars and wildcards as appropriate
-you click the button
-check textboxes for a string to search
-error if no textbox has a string---exit routine
-search table Berge for the string

Update: Hendrik
I took data from your previous database and added a form with a listbox.
You can search with wildcards on any one of your textboxes. At least 1 textbox must be populated.
If more than 1 are populated, then it takes the first one from the top to do the search.
The results are placed in the listbox. A count of found records is above the listbox.
I renamed the buttons for my convenience.
Some of your data have trailing spaces in the names, so do not get searched properly.
Try piek with a*o as search. Then look in table Berge and see the records a...o (followed by space).

Good luck.

[hendrikbez]

Orange
Thank you will look at it today, you are very helpfull, and I begning to understand some of it now.

[hendrikbez]

Thank you orange, just need help on one more thing, going to make new post