473,287 Members | 1,613 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,287 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 7228
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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
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: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...

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.