Search query

[Pusher]

Search query
How can I make a query that a can put into my form that users can use to find specific records based on a few letters, based on two field names? I know how to link them from a form but how to make it so that the query selects all the lines that have, for example, “Dun” in all records that have “dun” in the two fields.

 

[jdraw]

You may get some ideas from this free video tutorial
http://www.datapigtechnologies.com/flashfiles/searchform.html

 

[MStef]

Look at "DemoSearchQueryA2000.mdb" (attachment, zip).
Open Form1 and try.
Look at Table1, Query1.

 

[Pusher]

How can i make my combo box be the search box. How can i make my combo box not limit to list so i can use it for my search query box, it calls some column widths problem...

 

[Alansidman]

Use the same principle for referencing your combo box in the query as shown in the video. Look at this tutorial on Not in List. This will allow you to add items to your combo box.

http://allenbrowne.com/ser-27.html

Alan

 

[Pusher]

The problem is that i don't want to add items to my combo box, just want to make possible to enter a value in the box that can be used as a search criteria for finding the right already existing item in my combo box.

 

[Pusher]

Please can you help me

 

[Alansidman]

I just re-read the original request. You are trying to filter to find a particular record? You are not using the combo box as part of a search form for a query? Is this correct?

If so, then look at this:

http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

 

[Pusher]

Sorry for the delayed response, no filter is not what I want – I want to make possible to search the table in 2 or more fields but if possible I want to use the combo box for that search. Example:
I have the street name corner (so it’s named by 2 or more names, old names etc.) : Yellow street(1st street)-White street(Wall street) and in the description of that street its entered that that the old street name is : Pine street.
I want to be able to make a button so when I enter into my combo box if possible – “Wall” I will get a query that will list me every line in the table that contains Wall in the name of the street or in the description, also when i enter Pine i want the same line.

 

[Alansidman]

You just made my head mushy. Perhaps you can post your database with sample data and then tell us from the sample data what the expected results should be. This will help to clear up what is making me dizzy.

Alan

 

[Pusher]

I cant make my combo box into a search box so i made a button for opening a different form where a made a list box controlled by a text box.