Searching a database

[DBarker]

I am not sure if this is the correct forum to send this
question to. I want to give the users the capability to
search an entire database on specific text. The
binoculars provided do not seem to be doing a sufficient
job. Should I create a form or what is the best way to
provide this capability.

Thanks,
Debbie

 

[CDS]

What type of data do you want the users to search on?
One suggestion is to create a lookup/search box using a
simple query. Ie. criteria = [Enter Birthdate] All
criteria must be enclosed in brackets. If you would like
a range, criteria= Between [Enter Admission Date] and
[Enter Discharge Date]. This will prompt the user to
type in their request for a specific field. Once the
query has been created, you can create a command
button/switchboard to prompt the user for the search and
once it is found, open the table/form to that location.

 

[Guest]

Thank you for that~ I know how to create the user input
with the brackets. I have one form with multiple
subforms on it and it is the subforms that they want to
search through and have the particular record and have
that record show up on the form. I hope this is clear.
If not let me know.

Thanks,
Debbie

-----Original Message-----
What type of data do you want the users to search on?
One suggestion is to create a lookup/search box using a
simple query. Ie. criteria = [Enter Birthdate] All
criteria must be enclosed in brackets. If you would like
a range, criteria= Between [Enter Admission Date] and
[Enter Discharge Date]. This will prompt the user to
type in their request for a specific field. Once the
query has been created, you can create a command
button/switchboard to prompt the user for the search and
once it is found, open the table/form to that location.

-----Original Message-----
I am not sure if this is the correct forum to send this
question to. I want to give the users the capability to
search an entire database on specific text. The
binoculars provided do not seem to be doing a sufficient
job. Should I create a form or what is the best way to
provide this capability.

Thanks,
Debbie
.

.