By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

New to Access search field

P: n/a
Hello all
I am new to Access.
I have imported data from an old FoxPro 2.x database.
This is probably the most basic function but I cant get a search box to
work. I need to search for company name and cant figure it out in access.

Tony (homey)
Feb 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Like Fox, Access offers severals levels of search capability. Here's a
sample.

1. Find dialog
The simplest option in Access is to click in the field you wish to search,
and then click the Find button on the toolbar (binocular icon) or choose
Find on the Edit menu. This Find dialog gives you several options.

2. Filter By Form
If there might be several entries for the name you are searching for, you
might like to use the "Filter By Form" toobar button instead. This limits
the form to only the criteria you enter (on several fields if you wish), and
you can then use the navigation buttons to move through the results of the
search.

3. Finding records programmatically
If you want to do it programmatically, you could add an unbound text box to
the form (perhaps in the Form Header section), and use its AfterUpdate event
to find the record (if you expect only one) or filter the form (if you
expect multiple matches. For typical code, see:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html
Although the article uses a combo as an example, the code would be the same
for a text box.

4. Combining multiple search options
If you want an example of how to offer the user several specific boxes to
search different fields, in combination, and perform the search
programmatically based on the boxes where they actually entered something,
this database demonstrates the technique:
http://allenbrowne.com/unlinked/Search2000.zip

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Homey!" <bl**********@xyz.com> wrote in message
news:YX****************@fe10.lga...
Hello all
I am new to Access.
I have imported data from an old FoxPro 2.x database.
This is probably the most basic function but I cant get a search box to
work. I need to search for company name and cant figure it out in access.

Tony (homey)

Feb 19 '06 #2

P: n/a
Allen Thanks and your site is great.
Thanks again
Tony
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:43***********************@per-qv1-newsreader-01.iinet.net.au...
Like Fox, Access offers severals levels of search capability. Here's a
sample.

1. Find dialog
The simplest option in Access is to click in the field you wish to search,
and then click the Find button on the toolbar (binocular icon) or choose
Find on the Edit menu. This Find dialog gives you several options.

2. Filter By Form
If there might be several entries for the name you are searching for, you
might like to use the "Filter By Form" toobar button instead. This limits
the form to only the criteria you enter (on several fields if you wish),
and you can then use the navigation buttons to move through the results of
the search.

3. Finding records programmatically
If you want to do it programmatically, you could add an unbound text box
to the form (perhaps in the Form Header section), and use its AfterUpdate
event to find the record (if you expect only one) or filter the form (if
you expect multiple matches. For typical code, see:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html
Although the article uses a combo as an example, the code would be the
same for a text box.

4. Combining multiple search options
If you want an example of how to offer the user several specific boxes to
search different fields, in combination, and perform the search
programmatically based on the boxes where they actually entered something,
this database demonstrates the technique:
http://allenbrowne.com/unlinked/Search2000.zip

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Homey!" <bl**********@xyz.com> wrote in message
news:YX****************@fe10.lga...
Hello all
I am new to Access.
I have imported data from an old FoxPro 2.x database.
This is probably the most basic function but I cant get a search box to
work. I need to search for company name and cant figure it out in access.

Tony (homey)


Feb 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.