MS Access database support - New to Access search field

Author

New to Access search field

Homey!

2006-02-18, 8:24 pm

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)

Allen Browne

2006-02-19, 7:23 am

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!" <blahblahblha@xyz.com> wrote in message
news:YXOJf.1059$d%3.843@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)

Homey!

2006-02-19, 9:23 am

Allen Thanks and your site is great.
Thanks again
Tony
"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:43f861c2$0$3071
5$5a62ac22@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!" <blahblahblha@xyz.com> wrote in message
> news:YXOJf.1059$d%3.843@fe10.lga...
>
>

Sponsored Links