Search a database

[jlt7]

I have a movie database program and in this program I have a treeview on it. I would like to have a search on it to search the database for movie name and select the closest one to what is entered into the search textbox and have the search button change to say find next and search more of the database until it has found no more then msgbox no more found. Also have it select the name in the treeview.

[dreamvb]

umm hi I know ho you can do this but at the moment I not got time to make an example for you how ever I took a pice of code I used in a program I made years ago that may help get you started,

Dim StrSql As String
On Error Resume Next
    
    RecoredSet = "TestTable"
    
    StrSql = "SELECT Firstname,LastName,Age " & _
    "FROM " & RecoredSet & " WHERE Firstname Like '*" & "Kevin" & "*'"
    
    Set Recored_Set = d_base.OpenRecordset(StrSql)
    If Recored_Set.RecordCount = 0 Then SiteFound = False: Exit Function
    
    With Recored_Set
        While Not Recored_Set.EOF
            'This just loops tho and picks out any names
            MsgBox !Firstname
            MsgBox !LastName
            .MoveNext
        Wend
    End With
    Set Recored_Set = Nothing
    StrSql = ""