Is it possible to compare items in a collection to fields in a recordset? I have a record set called rs and a collection called PNum, I want to compare each value of Pnum to each field in the recordset. Then I will have a simple if statement that will be true if any value of Pnum equals one of the fields in the recordset.

I appreciate any help, thanks.

hi there.. what are you looking for??? because you are explaining the way that the task must be done... or you are asking if it is really possible to do it automatic?? (with a function in the language??)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I'm asking if it's possible, and if so, how do I do it? 8)

Thanks!

well.. I don't know any other way to do it that read every record in the recordset and compare it with all the data in the collection... as far as I know there is no auto way to do it...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I'm pretty new to VB, could you possibly help me out with the code? Some place to start maybe.

ok.. tell me what you have so far i will try to help you...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

While Not rs.EOF

    For i = 0 To rs.fields.Count - 1

        For y = 1 To PNum.Count

            If PNum(y) = rs.fields(i) Then


            End If

        Next y

    Next i

Wend

I wasn't sure if something like this would work, is it too simple?

rs is my recordset, Pnum is my collection. RS has only one record in it called FOLDER. That is what I need to compare to the values in the collection Pnum. If any of the FOLDER fields are equal to a value in the collection, I then need to execute that IF statement.

I appreciate your help, thanks.

this is good.. you are in the right direction.. if you find a true (a field value equals a collection value) then what do you want to do.. cancel all the for loops or just set a flag to true or what??? also I don't remember well but aren't collections indexes in 0 to??? (the first value isn't 0??)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I believe collections index at 0. And if it's true I'm executing an sql command, that part I'm not having problems with. When I try to run the code the way I have it now, I get :


Run-time error '3265'

Item cannot be found in the collection corresponding to the requested name or ordinal.

because if the collection has only one item and is index-0 based then the item Pnum(y) doesn't exist... try with HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========