MS Access database support - VBA Collections--How to Obtain Key?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

VBA Collections--How to Obtain Key?

Vincent

2006-04-05, 8:28 pm

If I am iterating through a collection object, how do I retrieve the
key? Thanks.

-Vincent

rkc

2006-04-05, 8:28 pm

Vincent wrote:
> If I am iterating through a collection object, how do I retrieve the
> key? Thanks.

If it's a VBA.Collection object you can't.
Wrap it in another class where you keep the keys
in an array or use the Scripting.Dictionary object
which does it for you.

dev.amit

2006-04-06, 7:41 am

hi
Describe ur problem a bit?

insidetungi.blogsopot.com
tungiprogramming.blogspot.com

Sponsored Links