search text box for FAQ database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

im new to programming, and i need help with creating a search engine for my
FAQ database....

id like to have a keyword search that would scan the question and answer
columns, and display the questions and answers in a report corresponding to
their keyword.

i used the search button on my form, but its searching the forms.... and not
giving me a report... any ideas how to set up the query to be based on the
keyword in the text box, then bring up the report automatically??

also, how do i set my textboxes in my forms to be blank by default? (as to
not allow accidental editing of the previous record)

if you have any ideas how i could go about doing this differently, that
would be great also!

thanks,

Em ~
 
Hi emmy128,

In order, here we go...
id like to have a keyword search that would scan the question and answer
columns, and display the questions and answers in a report corresponding to
their keyword.

i used the search button on my form, but its searching the forms.... and not
giving me a report... any ideas how to set up the query to be based on the
keyword in the text box, then bring up the report automatically??
Click to expand...

use a query that picks up the data from your keyword form, similar to select
* from tblFAQ where FAQSubject like "*" & forms!frmSearch.txtFAQSearch & "*"

Create a report based on this query, and have the report open when the user
types something into the keyword search box and clicks a button.
also, how do i set my textboxes in my forms to be blank by default? (as to
not allow accidental editing of the previous record)
Click to expand...

I assume you mean how do start a new record when you open your form. Set an
On Open Event to use docmd.GoToRecord acDataForm, me.Name, acNewRec which
will take you straight to a new blank record.

Hope this helps.

Damian.
 
that works so far, but how do set up and create a text box, where, when i
type in a keyword, and press a control button, a query comes up with all the
questions containing that keyword?

i have my form set up so that I have to enter keywords along with my
question and answer, but how do i go about running a query that searches the
keywords column, and displays the related answer?

im confused....

Thanks,

Em~
 
Actually, i got more information from allenbrowne.com. he gave a lot of
examples of code that i can use... im just not sure how he set up the whole
search form!!?? did he add a subform at the bottom? what do i do first? add
the unbound text boxes, or create a subform... also, he has his search
buttons... and i cant seem to duplicate the code to make it work in my
form....

i guess what im looking for is steps on how to create the search form from
the ground up....

visit his website http://allenbrowne.com/ser-62.html

im very new to access..... i appreciate your patience

Thanks in advance

Em!
 
Back
Top