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
1 1582
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. -
SELECT Subdivision_Folders.Subdivision, Subdivision_Folders.County, Subdivision_Folders.Section, Subdivision_Folders.[Tax Map], Subdivision_Folders.Remarks, Subdivision_Folders.[Digital Plat Location]
-
FROM Subdivision_Folders
-
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: ] & "*"))
-
ORDER BY Subdivision_Folders.Subdivision, Subdivision_Folders.County, Subdivision_Folders.Section, Subdivision_Folders.[Tax Map], Subdivision_Folders.Remarks;
-
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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:
...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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: 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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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: 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...
| |