Results 1 to 4 of 4

Thread: DataEnvironment1.rsZoeken....little question about .Find

  1. Feb 4th, 2002, 08:58 AM #1
    Matrixxx
    Matrixxx is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Posts
    259

    DataEnvironment1.rsZoeken....little question about .Find

    I am using this code for searching : DataEnvironment1.rsZoeken.Find "NM = '" & Zoeken.Text & " ' "

    That works really good when i search on exact the same value. I was wondering if there is any methode to search on a value that is not exact the same search criteria. For example i have to search "vbforums" but i find it when i search "vbf".

    Please can somone reply ASAP because i need it ASAP.
    Thank you,

    Matrixxx
    Reply With Quote Reply With Quote
  2. Feb 4th, 2002, 09:04 AM #2
    gab2001uk
    gab2001uk is offline
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    St. Albans, Herts, UK
    Posts
    259
    Code:
    DataEnvironment1.rsZoeken.Find "NM LIKE '*" & Zoeken.Text & " *' "
    Graham, www.gab2001uk.com VBExplorer Forum Moderator VBExplorer
    www.gab2001uk.com For comparing and contrasting DAO with ADO
    Code for Creating, Copying, Compacting, Replicating, Synchronising Access 97/2000 databases plus showing Schemas and using .Seek
    Reply With Quote Reply With Quote
  3. Feb 4th, 2002, 11:09 AM #3
    Matrixxx
    Matrixxx is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Posts
    259
    Thank you for the code. It works when the value is in the first word but when it is on the second word he can't find it. Is there maybee any thing i can do about?

    Thanks,
    Matrixxx
    Reply With Quote Reply With Quote
  4. Feb 4th, 2002, 12:52 PM #4
    ralph
    ralph is offline
    Fanatic Member
    Join Date
    Aug 2001
    Location
    Connecticut
    Posts
    855
    Replace * with % since you're using ADO.
    VB 6.0, Access, Sql server, Asp
    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