Another VB Question

Hello again,
I need to know how to delete every member of a collection that i make during my program. Is there a simple way to do this?
Thanks

 

which collection..

 

it is a custom collection i make during suntime

 

did you try setting it to "NOTHING" ?

 

you cant set it to nothing, the only options that can be accepted with a collection are: add, remove, count and item. the remove property only lets you remove a certian member

 

Can't you just set your Collection Object to nothing?

Code:

Set myCollection = NOTHING

Wouldn't that just destroy it?

Would this work?

Code:

Dim iCount as Long

For iCount = 1 to myCollection.Count
    myCollection.Remove iCount
Next

You can find more info here.

 

yeah, you can loop through.. but I too thought that it would be as easy as just

set mycollection=nothing

you do it with recordsets.. a collection is a collection..

 

The loop will work, but it will not always delete every member of the collection if it is above 4 members i think.

 

i figured it out
the reason the loop will not work, is because the count keeps changing. the way to remove the collection entirely

Set MyCollection = NOTHING

 

ya figured it out eh? the other two posts didn't give you a clue did they?