question

[Liz Henry]

i have set up a database that shows all the employers in our system with all
their information. there are over 1000 records, so scrolling through to
find the one i'm looking for is very tedious. i need to add a 'search'
button to the datapage in order to search for a certain employer by employer
name. i went to access help and was told to:

"add code to clone the recordset, to prompt and accept input from user, and
search cloned recordset for the corresponding record."

i don't know HTML, so this doesn't make an ounce of sense to me....can
anyone help?

 

[Guest]

All you need is a query.

Create a query for all of the information about the employer you want to
know. In the criteria box, under name catagory, type [employers name], or
what ever you want the prompt to say. When you run this query, you should
get a box in the middle of the screen that says "employers name" and an emply
space to type the name.

The creat a button on the form that opens the query.

You can also create a form based on the query to put the information in a
more pleasing and effencient format. You would then open the form with the
button.

Hope this helps. And USE THAT HELP SCREEN. Take your time and don't get
overwhelmed.

 

[Guest]

hi Liz,
The simplest way would be to create a select query using
the employee table as record source.
In the criteria pane of the employee field put somethng
like this
[enter employeee name]
Be careful. it will be looking for an exact match.
then add a button to your form. in the buttons on click
event add this code
docmd.openquery "queryname",accviewnormal
regards

 

[Guest]

Do you want to search in a form, table or query? I usually use the "find"
button.

hi Liz,
The simplest way would be to create a select query using
the employee table as record source.
In the criteria pane of the employee field put somethng
like this
[enter employeee name]
Be careful. it will be looking for an exact match.
then add a button to your form. in the buttons on click
event add this code
docmd.openquery "queryname",accviewnormal
regards

-----Original Message-----
i have set up a database that shows all the employers in our system with all
their information. there are over 1000 records, so scrolling through to
find the one i'm looking for is very tedious. i need to add a 'search'
button to the datapage in order to search for a certain employer by employer
name. i went to access help and was told to:

"add code to clone the recordset, to prompt and accept input from user, and
search cloned recordset for the corresponding record."

i don't know HTML, so this doesn't make an ounce of sense to me....can
anyone help?


.