Results 1 to 2 of 2

Thread: ADO

  1. Dec 5th, 2000, 01:25 AM #1
    Guest

    Unhappy

    How do you code the cmdFind button to search for records in a database? Thanks for your help. Phil
    Reply With Quote Reply With Quote
  2. Dec 5th, 2000, 05:26 AM #2
    dlm
    dlm is offline
    Lively Member dlm's Avatar
    Join Date
    Oct 2000
    Location
    Geraardsbergen(Belgium)
    Posts
    91
    Hi,


    code
    -----------------------------

    rs.Filter = "Field1 = '" & txtFind.Text & "'"

    If rs.BOF and rs.EOF then
    'Nothing found
    Else
    ' record(s) found
    rs.Movefirst
    end if

    -------------------------------
    If you can solve the problem, why worrying about it…
    If you can’t solve the problem, worrying won’t help…

    De la Motte Günther
    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