Results 1 to 3 of 3

Thread: filter problem

  1. Sep 11th, 2000, 11:06 AM #1
    bboht
    bboht is offline

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    35
    I am trying to filter a recordset.
    ie rstSetName.Filter = "KEYFIELD = '" & varName & "'"

    My problem: if there is a ' or a " in varName it ends the string for my filter and messes it up. I have been told to do something like this.

    rstSetName.Filter = "KEYFIELD = '" & replace(varName, "'", "''" & "'")

    This does stop the filter from crashing, however it doesn't really solve my problem because the filter is incorrect, and doesn't find the data I want it to. I have been scratching my head over this one for a while, so any help would be super cool!
    Reply With Quote Reply With Quote
  2. Sep 11th, 2000, 11:45 AM #2
    Joacim Andersson
    Joacim Andersson is offline
    I'm about to be a PowerPoster! Joacim Andersson's Avatar
    Join Date
    Jan 1999
    Location
    Sweden
    Posts
    14,649
    The solution you had is almost correct:
    Code:
    rstSetName.Filter = "KEYFIELD = '" & Replace(varName, "'", "''") & "'"

    Reply With Quote Reply With Quote
  3. Sep 11th, 2000, 11:46 AM #3
    Shafee
    Shafee is offline
    Addicted Member
    Join Date
    Sep 2000
    Posts
    219
    Try this.

    rstSetName.Filter = "KEYFIELD = '" & Replace(Replace(varName, "'", ""), chr(34), "") & "'"

    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