Creating a search button for key words

[In need]

Hi there,
I havent used access before and need a easy way to seach through 1300 records i have created in a form. Each record has 6 criteria, some with drop down options. I would like to create a button that when you type into a box and click this button it will search all my records and bring up a list of all the records containing the key words searched for.
I am working on Access 2000, hope this aint to much trouble


Cheers for your help in advance

[alansidman]

You probably want to do this in a query. Here is a link that may help you set up a query to do that type of search.

http://www.datapigtechnologies.com/f...earchform.html

This is not exactly what you are looking for, but it should help you to see how to get there.

[orange]

Please see and review
https://www.accessforums.net/showthr...Keyword-Search

I helped someone with searching for keywords in Dec 2011. Parts of it may be useful to you.

[In need]

alansidman
I have worked my way through the tutorial you have sent me, though i am having issues with it working and dont understand what i have done wrong.
When creating the command button for clear parameters (command3) i get a response of; Compile error: Method or data member not found
With it opening up the visual basic form, highlighting 'Private Sub Command3_Click()
When clicking Command4, my run query button it opens another box called 'Enter Parameter Value' with all the options in my form and then doesn't bring up any of the records.
Do you know what i need to do to resurect these problems?

[alansidman]

Without seeing what you have done specifically, it is difficult to diagnose. Perhaps you should upload a sanitized (no confidential information) copy of your data base with a limited number of records so that we can analyze it.

[In need]

I there another way of uploading the form apart from using the attach button on these responses as i cant seem to get the file small enough as only allows 500kb!!

[orange]

First do a compact repair of your database; then make a zip file to compress the file size; attach the zip.

To attach use the Go Advanced button.

[In need]

Attachment 7439

This is what im trying to work on
Cheers

[orange]

It isn't clear what your form is about/doing. I'll look at it more later.

My first thought concerns naming convention - Don't use names with embedded spaces or special characters ">?\/ etc.

What exactly do you want to search on?
You might consider using a defined list of values you'll use to attribute to a photo.

You realize there are no photos -it's not important at this point - you may want to add some to your zip for completeness.

[alansidman]

I noticed that your form is not named the same as the reference in the query. In the query you call the form formfind, yet the form is only named find. Secondly, you did not name the unbound text box for rivers yet you reference as qriver1 in your query. You also need to add a me.requery line to the clear filter command button. This should get you started.

Alan

[In need]

Some how i have got the Clear command to work now, not sure how as changing the names and putting Me.requery in wasn't working but after closing and opening it up again it is now working without Me.requery!!

I have renamed the query to just find rather than findform which i had before and named my river textbox qriver1. However it is still not working, although it occasionally brings up the same 3 records!

Photo wise i realise i haven't included any this is as they are on a external hard drive so they can be accessed on different computers.

CheersPhoto Database.zip