Hi there,



I would like to create a form, that the user can enter a word, or words

into, and then these words can be searched for in the database, and a list

of all the records for with those words is displayed.



How do I do that?

Or is there some website or book I should be looking at?



Thanks,

Steve.

Steve,



There are a couple of programs you can download that will help you in

programming



1.  ACC97KB.exe is an an extensive knowledgebase of sample codes for Access

97.  You can download it at

http://support.microsoft.com/support/kb/articles/Q167/1/20.asp?LN=EN-US&SD=g

n&FR=0&qry=acc97kb.exe&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

1. ACC97KB.exe is an extensive knowledgebase of sample codes for Access 97.

You can download it at

http://support.microsoft.com/support/kb/articles/Q167/1/20.asp?LN=EN-US&SD=g

n&FR=0&qry=acc97kb.exe&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97



2. Frmsmp97.exe is a program that once executed, creates a Forms sample

database which shows you samples of how to use forms.  It is located at

http://support.microsoft.com/support/kb/articles/Q175/0/66.asp?FinishURL=%2F

downloads%2Frelease%2Easp%3FReleaseID%3D13864%26redirect%3Dno



3.  Go to http://www.microsoft.com/downloads/search.asp? and in the Product

Name enter Access 97 or Access 2000 (whichever you are using).  There are

lot's of useful downloads that can help you program.



4. Check to see if you have the Solutions.mdb installed.  It would be in the

folder called Samples in your Office directory.  Mine is located in the

C:\Program Files\Microsoft Office\Office\Samples directory.  It is extremely

useful.



Finally, in general terms, to answer your question.  I would have a Form

(frm_Main) and a sub-form (frm_DataFound). The frm_Main would have the

control (txt_Search) that the user would use to enter the text.  The

frm_DataFound would display the records that were found.  I would create a

query that would reference the frm_Main's txt_Search control.  So the

criteria would look like this: Like "*" & Forms!frm_Main!txtSearch & "*".

The asterisk before and after the "Forms!frm_Main!txtSearch" would find all

records that have the word/s the user typed in the txt_Search control.  This

is just a brief example of how you can perform the task you are asking

about.



There are many other ways and I'm sure you will get other solutions.  Try

them all and see what works best for you.





John Ruff - The Eternal Optimist :)





-----Original Message-----

From:	Steve Robbo [mailto:style@p...]

Sent:	Tuesday, March 20, 2001 3:45 AM

To:	Access

Subject:	[access] search form



Hi there,



I would like to create a form, that the user can enter a word, or words

into, and then these words can be searched for in the database, and a list

of all the records for with those words is displayed.



How do I do that?

Or is there some website or book I should be looking at?



Thanks,

Steve.

Just in case some of you are in the same boat I was (didn't have the 

Solutions database) it can be found in the Knowledge Base Article 

#Q248674. Following the links within the message will lead you to the 

download site.



> Steve,

> 

<< SNIPPED FOR BREVITY'S SAKE>>

> 

> 4. Check to see if you have the Solutions.mdb installed.  It would be in 

the

> folder called Samples in your Office directory.  Mine is located in the

> C:\Program Files\Microsoft Office\Office\Samples directory.  It is 

extremely

> useful.

>