Results 1 to 17 of 17

Thread: [RESOLVED] Working Searchable DB Now!

Threaded View

  1. Dec 22nd, 2005, 06:51 PM #1
    Quizton
    Quizton is offline

    Thread Starter
    Addicted Member Quizton's Avatar
    Join Date
    Dec 2005
    Location
    VB Forums
    Posts
    209

    Resolved [RESOLVED] Working Searchable DB Now!

    VBCode----------------------------
    Private Sub txtSearch_Change()
    If txtSearch.Text = vbNullString Then
    Set rs = db.OpenRecordset("EMPDATA", dbOpenTable)
    Else
    Set rs = db.OpenRecordset("SELECT * FROM EMPDATA WHERE ID LIKE'" & txtSearch.Text & "'" & "& '*'")
    End If

    End Sub

    everything else seems to work fine If it will help I can paste the rest of code ?
    Last edited by Quizton; Dec 23rd, 2005 at 04:05 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width