Creating a keyword search 
Author Message
 Creating a keyword search

Hello,

I am very green at programming Access but a coworker has
asked me to help her implement a keyword search for her. I
have a text field(edtKeyword), a button(btnFIndWord), and
a listbox(listbox1). I also have set up a parameterized
query, however the query is not exactly handy. How can i
use the three components mentioned above to return the
results of my query? I have no clue where to start with
this? Any help is appreciated.

Thanks,

Brian



Mon, 29 Aug 2005 05:48:40 GMT  
 Creating a keyword search
hello Brian
one way is to open the query in design view, delete any
parameters you have,
in the criteria of the field corresponding to edtKeyword:
"=Forms!formName!edtKeyword"
and in the criteria of the field corresponding to listbox1:
"=Forms!formName!ListBox1"

then have the button run the query.
good luck
Erez.

Quote:
>-----Original Message-----
>Hello,

>I am very green at programming Access but a coworker has
>asked me to help her implement a keyword search for her.
I
>have a text field(edtKeyword), a button(btnFIndWord), and
>a listbox(listbox1). I also have set up a parameterized
>query, however the query is not exactly handy. How can i
>use the three components mentioned above to return the
>results of my query? I have no clue where to start with
>this? Any help is appreciated.

>Thanks,

>Brian
>.



Mon, 29 Aug 2005 08:00:21 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Create Search form with Keywords

2. Create Keyword search..help me pls

3. Creating Keyword Search in Access

4. Creating Keyword Search in Access

5. Form Keyword Search

6. Combo Box and Keyword Searches

7. Urgent..Keyword Search

8. keyword searching

9. Keyword style searches

10. Search for keyword


 
Powered by phpBB® Forum Software © phpBB Group