Questions database

[williec00]

Hello,

I am new to the forums and definitely new to Access! But trying to throw myself into the fire, if you will. I am attempting to create a database of trivia questions that will be used to store all my questions and then show me all questions that fall under a given category.

So far, I have created a table with the following columns: questionID(auto number), questionTxt, answerTxt, keyword1Txt, keyword2Txt, keyword3Txt, keyword4Txt, keyword5Txt. I will be inputting my questions and answers into these fields. Once have inputted the thousands of questions into the table, I would like to be able to use a checkbox to check all possible keywords (by searching keyword1Txt-keyword5Txt) and then pull up the question and answer for any and all that match the checked boxes. Some questions will only have 1 keyword, I have allowed for up to 5.

I have no idea how to create the user interface portion, that is, the box with the categories that can be checked or how to get it to show the report of the questions and answers. If anyone could point me in the right direction, it would be MUCH appreciated.



Thank you

[June7]

So you want to have a form where you enter a word in a textbox (or select from a combobox dropdown list) that will be used to compare with the keyword fields and return records where there is a match? Build a query that uses the value as filter criteria. Something like:

SELECT * FROM tablename WHERE keyword1Txt = Forms!formname.comboboxname OR keyword2Txt = Forms!formname.comboboxname OR keyword3Txt = Forms!formname.comboboxname OR keyword4Txt = Forms!formname.comboboxname

Use that query as the RecordSource for a report.

No checkboxes needed.

[williec00]

So you want to have a form where you enter a word in a textbox (or select from a combobox dropdown list) that will be used to compare with the keyword fields and return records where there is a match? Build a query that uses the value as filter criteria. Something like:

SELECT * FROM tablename WHERE keyword1Txt = Forms!formname.comboboxname OR keyword2Txt = Forms!formname.comboboxname OR keyword3Txt = Forms!formname.comboboxname OR keyword4Txt = Forms!formname.comboboxname

Use that query as the RecordSource for a report.

No checkboxes needed.

Thank you for the quick response June7 (and the fact that you have endeavored to help a neophyte!) I do have a question though. Like I said, some questions will fall under multiple keywords... for instance a music question about U2 could be keyword1Txt=Music keyword2Txt=90s keyword3Txt=PopCulture keyword4Txt=Ireland keyword5Txt= RocknRoll

The reason I wanted the checkbox was that I might need a question that is a 90s PopCulture question. I could then tic the 90s box and the PopCulture box and all the questions with both these keywords would then be shown.

Do you think multiple combobox dropdowns are a better solution?

I would also like to have the option to enter a word into a text box but then I would want that query to search the questionTxt and answerTxt fields. (pretty sure I can get this part done, heh)

Thank you again for being so helpful!!!!!

[June7]

Yes, multiple combobox dropdowsn better. Then probably need to use LIKE operator with wildcard. Review

http://datapigtechnologies.com/flash...tomfilter.html

http://datapigtechnologies.com/flash...mtoreport.html