|
-
Sep 8th, 2000, 02:52 PM
#1
Thread Starter
Member
I'm trying to search a table with the following data format:
#.#.#.#/#, #.#.#.#/#, #.#.#.#/#, #.#.#.#/#
I want to check to see if a string (#.#.#.#/#) exists anywhere in the table. I've got a .FindFirst query (posted below) that won't return a match. Maybe my approach is wrong.
Set db = CurrentDb
Set rs = db.OpenRecordset("MainData", dbOpenDynaset)
strSrch = "IP like '" & currentEntry & "'"
With rs
.MoveFirst
.FindFirst strSrch
If .NoMatch Then
MsgBox "NOMATCH"
Else
MsgBox "MATCH!"
End If
End With
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
|