Technical Help & Discussion > Website Design & Programming

filtering records vb

(1/2) > >>

davypipes:
hi guys....
i want to filter a record based on the first 3 values ... using the .filter method

With dataenv.rssale

 .Filter = "name_field= '" & "da" & "'"

end with

in that a name like david,or daniel will be in the results.the above code will only bring results based on finding exactly "da" and not a value like "david"
anyone?
 :(

Simon:
A Job for Sam, me thinks!  Hold on Davy, I'm sure he'll be around at some point soon.   :)

sam:
maybe it is... expect for the fact that i know absolutely no visual basic!!!

ill have a quick think though

sam:
explain to me what you exactly want to do, sorry am a littel confused from what you are saying. it could just be that I am tired (have been analysing data for 6 hours straight now!).

I am also unsure about the functions you use. Since I dont know vb I can go about this in another way and see if i can piece things together. any explanation will be appreciated.

Oh why dont you try this MSDN page.

davypipes:
hey thanks sam...
illl check out the link youve given me. basically i wanted to filter records based on the first characters...eg..all the names starting with "s" but you see in vb i dont no how to do that with the filter method
( .Filter = "field= '" & "argument" & "'")
hopefully i will get some leeds and post the solution :D

Navigation

[0] Message Index

[#] Next page