473,322 Members | 1,473 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,322 software developers and data experts.

Find list of matching record

14
Hi,

I'm pretty new to Access and I'm not too sure how to handle the following.

There is an atual DB in access and I need to add a search tool to it. More exactly, we have a field name and a field description in the main table. I want to create a menu for an user to query this table to find the specific records that contains key words.

For example, a record name would be "Approvals Policy" and the description would be Cheque Requisitions and Credit Approval Levels. I want the user to be able to type any of these words (policy, approvals, cheque, etc..) and to be able to find any records that contains these words.

I know I can use the filter fonction, but I do not find it user friendly enough. is there any other way to work around this?

Thank you

Marie
Apr 16 '07 #1
1 1582
tdw
206 100+
Hi,

I'm pretty new to Access and I'm not too sure how to handle the following.

There is an atual DB in access and I need to add a search tool to it. More exactly, we have a field name and a field description in the main table. I want to create a menu for an user to query this table to find the specific records that contains key words.

For example, a record name would be "Approvals Policy" and the description would be Cheque Requisitions and Credit Approval Levels. I want the user to be able to type any of these words (policy, approvals, cheque, etc..) and to be able to find any records that contains these words.

I know I can use the filter fonction, but I do not find it user friendly enough. is there any other way to work around this?

Thank you

Marie
I have a database that is called Subdivision Folders Index. When we get a new request for a land survey, we can search this index to see if we already have the subdivision plat on file. I have set this db up so that we can search by keyword in three fields. I have a form that displays all of the records in continuous forms, and on that form is a 'Search' button. That button launches a macro that opens a new form called "Search Results" using a select query as a filter. Here is the sql I use for that query, maybe it will help you.
Expand|Select|Wrap|Line Numbers
  1. SELECT Subdivision_Folders.Subdivision, Subdivision_Folders.County, Subdivision_Folders.Section, Subdivision_Folders.[Tax Map], Subdivision_Folders.Remarks, Subdivision_Folders.[Digital Plat Location]
  2. FROM Subdivision_Folders
  3. WHERE (((Subdivision_Folders.Subdivision) Like "*" & [Enter All or Part of the Subdivision you want to find: ] & "*") OR ((Subdivision_Folders.Section) Like "*" & [Enter All or Part of the Subdivision you want to find: ] & "*") OR ((Subdivision_Folders.Remarks) Like "*" & [Enter All or Part of the Subdivision you want to find: ] & "*"))
  4. ORDER BY Subdivision_Folders.Subdivision, Subdivision_Folders.County, Subdivision_Folders.Section, Subdivision_Folders.[Tax Map], Subdivision_Folders.Remarks;
  5.  
Apr 18 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Dejan M. | last post by:
Please can you help me with this problem: In the next form, when I Add new person who is not registered in the base I had the massage: The Microsoft Jet database engine cannot find a record in...
3
by: Tom Mitchell | last post by:
All: I'm stumped on a query. How do I find duplicates in a table where one of the duplicates has values is a certain field and the other doesn't. For example, I have the following table: ...
1
by: David C. Barber | last post by:
I'm trying to determine if any matching records exist on a LIKE query performing a partial match of last names to a remote back-end database in the most efficient manner possible. LAN Traffic...
2
by: dskillingstad | last post by:
I'm building a tracking system and I'm having some problems. I thought this was relatively easy, but.... I have the following tables and fields (abbreviated): tblPermitMain PermitID - pk...
4
by: Aaron Smith | last post by:
Dim dv As DataView = New DataView(FacilitiesDS1.Facilities, "", "ID ASC", DataViewRowState.CurrentRows) Dim iPos As Integer = dv.Find(dr.Item("ID")) Me.BindingContext(FacilitiesDS1,...
6
by: Tom McL. | last post by:
I'm trying to move a program that was designed using Visual Studio 2003 and (Visual Basic) into Visual Studio 2005. When it runs I get the following warning in the Error List Window and I'm not...
2
by: clickon | last post by:
I am using ASP.net 2.0 and trying to take advantage of the updated data editing facilities provided through the SQLDataSource control and the DetailsView control. The data is a record from a...
1
by: ron.vdm | last post by:
Hi all. I have a SQL question I am having trouble with. We have a table, with a column that contains a code. These codes start at '00001', '00002', '00003', '00004'... and so on. If the record...
10
by: dstorms | last post by:
Hi, I'm trying to create a button on a form that: 1. Takes the ComputerID from the form linked to Table 1, 2. Checks Table 2 for a matching ComputerID, and 3. Opens the query qryEditData, and...
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...
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: 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...
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)...
1
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...
1
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.