If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
keyword search in Access
What I want to do is kina like adding the [Enter Number] function on a query.
It prompts the user to search based on a number. This is what I want to do: Retrieve record(s) based on a Keyword entry. This search would allow the user to enter a keyword that would search all records and fields within a table and display all results. Say a fruit databse table and we have one combo box, pulled from a table that lets you select all varities and then another field that you enter in all text pertaining to a specific issue. Whether the keyword the user enters when prompted the results will be all records containing the keyword no matter what field it's in. Is there away to do this? |
#2
|
|||
|
|||
It seems somewhat contrary to the notion of relational design to have to
search "all ... fields" to match a search value/string. If a database is well-normalized, the string/value being sought would probably only be stored in a single field. If your database structure is more like what you'd see in a spreadsheet, the tools and features of Access won't work as well on it. -- Good luck Jeff Boyce Access MVP "lavesely" wrote in message ... What I want to do is kina like adding the [Enter Number] function on a query. It prompts the user to search based on a number. This is what I want to do: Retrieve record(s) based on a Keyword entry. This search would allow the user to enter a keyword that would search all records and fields within a table and display all results. Say a fruit databse table and we have one combo box, pulled from a table that lets you select all varities and then another field that you enter in all text pertaining to a specific issue. Whether the keyword the user enters when prompted the results will be all records containing the keyword no matter what field it's in. Is there away to do this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Does anyone have an Access system to manage a job search? | Chris Symons | Database Design | 1 | October 13th, 2004 01:06 PM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
access database wizard | Phil | General Discussion | 6 | August 24th, 2004 08:08 AM |
keyword to search | Mingman Xu | New Users | 2 | August 23rd, 2004 03:45 AM |