Search form

[encore0000]

I am lookign for designing a multisearch form where a user can search the database based on what is entered in the text box. There would be about three to four text boxes and a search button. i believe the search button would call an on_click fucntion which would search what was entered in the text box against the corresponding fields in the database. I am fairly new to Access and any help would be very appreciated..

 

[jbento]

This is a great one at this link:

http://www.jerpat.org/SearchDb.mdb

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[encore0000]

I am getting a error: userdefined type not defined
on dim dbNm As Database


Private Sub cmdSearch_Click()
'Set the Dimensions of the Module
Dim strSQL As String, strOrder As String, strWhere As String
Dim dbNm As Database
Dim qryDef As QueryDef
Set dbNm = CurrentDb()

 

[encore0000]

Dim dbNm As Database ->Compile Error User-defined type not defined

 

[jbento]

Download this file:

http://www.jerpat.org/AnswerToYourQuestion.pdf

It will answer your question.

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[encore0000]

Thanks alot but it has already been selected