Search results for query: *

I want to thank every one that helped me with my original Query issue, You guys were great, but now I have a second issue , I wont to run my query not from a form , rather i want to create a PAGE and run it from there. Any HELP

I want to thank every one that helped me with my original Query issue, You guys were great, but now I have a second issue , I wont to run my quey not from a form , rather i want to creat a PAGE and run it from there. Any HELP

Nope not adumb question , and yes I am entering values in teh Text box, A typical entry into the table is "Customer cannot login to Picis, customer A typical entry in the text box would be "picis" And upon runnng the Debug test "Runtime error 2465

Strangley enough when a known keyword is entered, Nothing shows up from the query below is the SQL Code SELECT [KnowledgeBase].[Problem_keyword], [KnowledgeBase].[Resolution], [KnowledgeBase].[Resolved_by], [KnowledgeBase].[Notes] FROM KnowledgeBase WHERE ((([KnowledgeBase].[Problem_keyword])...

Query returns a form with list of all entries, the query does'nt filter the keyword entries..

Below is the SQL, and GingerR thank you soooo much for your help and instruction, you are so nice to be so helpfull.. SELECT KnowledgeBase.Problem_keyword, KnowledgeBase.Resolution, KnowledgeBase.Resolved_by, KnowledgeBase.Notes FROM KnowledgeBase WHERE (((KnowledgeBase.Problem_keyword) Like...

Now the criteria listed in my query is: Like "*" & [forms]![KBHD10]![Keyword] & "*" with KBHD10 being the name of the Form (not Query) and Keyword being the name of the Text box, or should keyword be the name of the field I want to search????

Now the criteria listed in my query is: Like "*" & [forms]![KBHD10]![Keyword] & "*" with KBHD10 being the name of the Query and Keyword being the name of the Text box, or should keyword be the name of the field I want to search????

Nope I do not have the word "LIKE" any where.. Should I ??

You guys are graet bearing with me, and belive it or not I am learning, I was thinking , I have NOthing in my Form "KBHD10" that links the textbox where the keyword is entered to the query Criteria. Example "*" & [forms]![kbhd10]![Problem_keyword] & "*" That is the criteria line in my query...

Sorry my mistake KBHD10 is the name of the form, but the Search criteria is entered the results are, every entered record appears, Again I certainly appreciate the help from you guys..

"*" & [forms]![kbhd10]![Problem_keyword] & "*" This is excatly what my search criteria looks like in my Query, What happens is all entered records appear. KBHD10 is the name of the query Probem_keyword is the name of the field wanting to Seacr through. I know it is something simple what am...

I am using Access 2003 and fairly new to the project I have taken control of, I am creating sort of a knowledge base for a small Helpdesk, and I would like to be able to create a Keyword search that could locate records with similar Problems (example if a New Tech were to come across an issue...