473,320 Members | 1,974 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

New to Access search field

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
2 7233
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mario | last post by:
I am trying to set up a search field that searches my only my website. I dont want to link it to other search engines. It is only for the web im developing. Any Links or Suggestions on how to...
4
by: Captain Wonky | last post by:
As the subject says... I'm a database novice even though I've been trying to learn Access for years. I've 'almost finished' several databases but always get stumped on something - this time it's...
6
by: Matt | last post by:
I'm having difficulty with trying to update a Access memo field through an SQL statement where the value I'm trying to pass is longer than 255 characters. The field is being truncated. I'm using...
2
by: AA Arens | last post by:
When I push on my find-record button, after I focussed on the ID-number field on my form, the default search field in the Search-form dialog menu is not the focussed field, but another. Why? ...
3
by: zlf | last post by:
Hi, I am trying to access private field by code below. But it runs with error. Please tell me what's the problem or any method that may allow me to access private field. Thank you class Love...
0
by: Jon | last post by:
If anyone can help...Whenevr I go into a form and use the ctrl+F to find something with the binoculars the "Search field as formatted" is checked as default. This seems to slow down the find...
3
mmarif4u
by: mmarif4u | last post by:
Hi everyone, I have a little problem in php coding. i have mysql table guestbook: Fields are Id,name,email,comment,datetime. Now i want to search the database by php query using a Dropdown menu...
2
by: ZEROFIVE | last post by:
Just wanted to know how would i go about making a Search field and search results page if someone wanted to search on my site? Thanks alot, Jimmy
1
by: brenty66 | last post by:
I have a userform that is used as an interface for information stored on excel spreadsheets. The user enters bits of information into fields on the userform which are place on the corresponding...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.