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

Query works by itself- no records in form

Hi I am still very new at this but need help with a database problem.

To make things simple, I have a database with a form (frmDataEntry) where users can input information (that mostly goes into the main table (tabFeedback) and later search for it. Ideally, I would like to search through user-input keywords to access the files taht match.

To do this, I created another table (tabKW) which stores all of the keywords upon entry and gives them a unique number (KeywordID). I also created a table (tabKWAssign) that would assign the unique number (item #) for the large record from frmDataEntry to a keyword by creating records including the KeywordID, the item #; and a unique number for the link.

For example: should a user input the key words "dog", "cat" into one record; and "cat", "mouse", into another the keyword identifiers would look like 1,2 then 2;3.

There is a listbox (showkey) that queries the tabKWAssign to show the specific keywords for each record Item #.

This seems to all work.

My problem is here: I would like the user to be able to filter the records by searching for keywords and I don't know how. Right now I have a query that works only when its used not in conjunction with the form that is this:

Expand|Select|Wrap|Line Numbers
  1. SELECT tabfeedback.[Item #], tabfeedback.[Log Date], tabfeedback.SI, tabfeedback.[Feedback/ Lessons Learned Description], tabfeedback.[Reference/Source Document (DOC #)], tabfeedback.Project, tabfeedback.User, tabfeedback.Nominator, tabfeedback.[Feedback Classification], tabfeedback.Disposition, tabfeedback.[Disposition Status], tabfeedback.[Final Disposition Date], tabfeedback.[Last Update], tabKWAssign.KeywordID
  2. FROM tabfeedback INNER JOIN tabKWAssign ON tabfeedback.[Item #] = tabKWAssign.[Item #]
  3. WHERE (((tabKWAssign.KeywordID)=[forms]![frmdataentry]![cboKWfind]));
  4.  
cboKWfind is the combo box that displays the possible keywords from tabKW.

Why won't this work? Should I be going about this a different way? Please help, my job depends on this.

Thank you very much
Aug 1 '07 #1
1 1184
JKing
1,206 Expert 1GB
Hi, there. It seems you are on the right track. What are you using as the record source for your form?
Aug 8 '07 #2

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

Similar topics

22
by: Robert Brown | last post by:
suppose I have the following table: CREATE TABLE (int level, color varchar, length int, width int, height int) It has the following rows 1, "RED", 8, 10, 12 2, NULL, NULL, NULL, 20...
6
by: David Shorthouse | last post by:
Hello folks, I have a problem with an update query on an asp not updating the table in an Access db. The code runs, I have no errors, but when I examine the table, nothing was updated. The query...
1
by: frizzle | last post by:
Hi there, I'm building a forum with a mysql backend. The forum has the following structure: - category |--> forum |--> thread |--> replies Once the user has defined a forum (id), i first...
0
by: Phil C. | last post by:
Hi, I'm using Access 2000. I have a Select Query that uses the MID function to separate the actual text of articles from the title of the articles. The articles are enterd into the...
36
by: Liam.M | last post by:
hey guys, I have one last problem to fix, and then my database is essentially done...I would therefore very much appreciate any assistance anyone would be able to provide me with. Currently I...
3
by: ey.markov | last post by:
Greetings, I have a simple query (Access 2000 on W2kPro): SELECT . FROM tblBankInfo INNER JOIN tblPartnerships ON .=. WHERE .=!!; which runs fine by itself. However, when I put it into...
1
by: msmith | last post by:
MSSQL Server 2000 SP3 in both houston and memphis I have a database in houston, lets call it RED. Specific tables from database RED are copied to database BLUE. Database BLUE is then backed...
4
by: Uriah Piddle | last post by:
Hi Gang, In sql Server 2005, I am running a query with an nvarchar param in the WHERE clause like this: .. . . @Bar nvarchar .. . . Select * From Foo WHERE Foo.Bar = @Bar The problem:...
20
by: raylopez99 | last post by:
Inspired by Chapter 8 of Albahari's excellent C#3.0 in a Nutshell (this book is amazing, you must get it if you have to buy but one C# book) as well as Appendix A of Jon Skeet's book, I am going...
2
BeemerBiker
by: BeemerBiker | last post by:
I put together a (what I consider) complex query using the Access wizard. It works fine in access but fails when I code it up. I can actually make it work in code by "simplifying" it, but then it...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.