Find Record

  • Thread starter Thread starter David Frick
  • Start date Start date
D

David Frick

I have two questions on the form operation "Find Record."

1. When I use the wizard to add the find record functionality, it appears
that I cannot search on a memo field. Is there a way around this
limitation?

For example, I want to do a SELECT * FROM table WHERE memofield LIKE 'new%',
return all the records and then navigate through all the matches. Can anyone
point me to an example where this is done?


2. When I use the find record functionality on a regular text field, it
defaults to searching on "whole field." Can I change the default so that it
seraches on "any part of field?"

Thanks
Dave
 
The Find Record wizard is not used to create a search routine. It just
finds the record with an exact match to some criteria. What you are
describing for both questions is a filter. Seems like what you need is a
customized search form. What you can try is create a new form with an
unbound text box, this will be where you type the text you want to search
for. Then create command buttons, one for each field you want to search.
Add code to each button to open the form with the data filtered based on
what was entered into the text box. Appending the wildcard character * to
what was entered will search part of a field.

Look at http://www.mvps.org/access/forms/frm0045.htm for an example.

Kelvin
 
Thanks Kelvin

Great site reference!


Kelvin said:
The Find Record wizard is not used to create a search routine. It just
finds the record with an exact match to some criteria. What you are
describing for both questions is a filter. Seems like what you need is a
customized search form. What you can try is create a new form with an
unbound text box, this will be where you type the text you want to search
for. Then create command buttons, one for each field you want to search.
Add code to each button to open the form with the data filtered based on
what was entered into the text box. Appending the wildcard character * to
what was entered will search part of a field.

Look at http://www.mvps.org/access/forms/frm0045.htm for an example.

Kelvin

that
Click to expand...
 
Back
Top