Here's a question for you VB gurus.

[Bushwack]

Here's a question for you VB gurus.

I'm using a Collection. When adding Items into my Collection, I'm adding values from a Recordset. I'm assigning a field from the Recordset as a string into the "Item", and I'm assigning the record's key into the collection.Item's "key" as a string.

Here's the records I'm making the assignment with... (there's only two fields with the first being the ID or Key for the record)

2 Fred
25 Bob
30 Joe

I use this statement to add each Item into my Collection (the name of my Recordset is "rsUtility&quot

Collection.add Cstr(rsUtility!Name), Cstr(rsUtility!ID)

Here's my question... when I reference the Collection's Item like this...

Collection(Cstr(rsUtility!ID))

...what will I get back? Will I get the Item "Fred" because the Item's "key" for "Fred" is 2 and I'm giving the Index a string?
...or will I get the second Item in the Collection (which in this case would be "Bob&quot?

 

[Guest_imported]

You will get Fred because you are giving it a string.
If you need to retrieve an item by ordinal position, you need to give it an integer

Nikita

 

[muesli]

Prepend a 'K' character onto the beginning of the numeric key, so it can't be recognised as anything but a string. The Key parameter for Collection.Add is actually a variant: if you suppy a numeric string the collection will try to translate it into a number.

If this is too confusingm, use a Dictionary, but please remember to use the syntax Recordset!Field.value, not just Recordset!Field as otherwise the Dictionary will add the key as the field object itself!

 

[JohnYingling]

"If this is too confusing, use a Dictionary, but please remember to use the syntax Recordset!Field.value, not just Recordset!Field as otherwise the Dictionary will add the key as the field object itself!"

The same is probably true about a collection because of variants. Thankfully they (variants) go away in VB.NET.

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript