Hi !
I creat a search query in ms access and when I want to find a special record in database ,
The result is exactly the same input text that I enter the query. For example I want to find a name such as "abc", when a enter abc in query , the result show all records that their filed's name are "abc" but doesn't show the records that their fileds name is "abcd" or "abcde"...
Is there any on to help me?

Try to key in abc*, which means anything starts with abc.

It depends on how you have created the search. If you are using a query, tyhen you have to use the LIKE operator:

LIKE "abc*"

Otherwise you will get only those that match abc*. You might want to check out the Filter by Form feature.

Thanks,but I have still problem whit this.
In my project there is a text box that we must enter the name, in the text box for search.
For example when I enter "john" in the text box the result doesn't show "johnson" or like this, or when I enter "manchester" in the text box it doesn't show "manchester city" or "manchester united".

Like I said it depends on how you are doing the search. If you are setting criteria as I said using Like and an * it will work. For me to help further you need to describe what you are doing.

I try to use this , but ms access show an error.

In my query in front of criteria is : [forms]![search_form]![txt_firstname]

That's not gong to work like I said. That will only find an exact match you need to use:

Like [forms]![search_form]![txt_firstname] & "*"

Thank you very very much scottgem.
That's OK, it solve my problem.
I have another question too.
As you know , if there is no result for the search, however query will be open.
Is there any way to show a message if there is no result for the search.
(without opening query).

Again, this depends on your code and how you are triggering the query. If you are running the query from VBA with a DoCmd.OpenQuery method, then you can use a DCount() function to check whehter the query returns any records and display a message if it doesn't.

In my project there is a macro that it's action is : open query
DoCmd.RunMacro
Can you describe about DCount() function ?

Look it up in Access Help. I also recommend getting away from macros. You can't do what you want with macros since you can't run a conditional like that.

Whit use this code it solve :
If DCount("first_name]","[query_search_firstname]") = 0 Then
msg=msgbox("Not Found")

We can navigate between record's , in a form by using middle bottom of mouse,
Can we disable it ?

Yep that looks like it would work.

There is a utililty that can disable the wheel in Access forms. I can't find it right now, but if you search on Access Disable mousewheel you should find it.

I found a way to disable mousewheel ( in form access) in this site:

VBA Express : Access - Disabling Mouse Scroll wheel from advancing database entries (http://www.vbaexpress.com/kb/getarticle.php?kb_id=890)