searching database

[Richard]

Hi

I am a real beginner i am at secondary school doing
coursework so any help on this matter would be great.

I want to know if you can create a button that will search
the entire databse for you. or can it only search the
table or form that you are in. if this is possible i would
be happpy if i could be shown how.

thanks

Richard

 

[John Vinson]

Hi

I am a real beginner i am at secondary school doing
coursework so any help on this matter would be great.

I want to know if you can create a button that will search
the entire databse for you. or can it only search the
table or form that you are in. if this is possible i would
be happpy if i could be shown how.

thanks

Richard

Well... with a logically designed database, you will rarely or never
need to "search the entire database". Each Table and each Field should
contain its own distinct category of information. It wouldn't make
sense to search date/time fields for people's names, or to have a
search for "Johnson" turn up people named Johnson, people who live in
Johnson City, and people who live on Johnson Avenue!

Could you explain what you're trying to accomplish with this?