Collection Classes and Enumerating then

[Chris Newton]

Excuse me but I haven't been programming with VB/VBA since VB6 but I would
like to create my own object and collection classes within Access 2007.

I seem to remember from my VB6 days that to enable enumeration (for each) of
objects within the custom collection, there had to be an IEnum method and a
number of the methods had to have hidden property values assigned to them.

How do I now achieve this within Access 2007?

 

[Robert Morley]

I'm not sure if it still applies to Access 2007...I think it does...but
here's a brief explanation of what you have to do:

http://www.xtremevbtalk.com/archive/index.php/t-146131.html

Assuming everything still works the same, your other option is to save the
class in VB6 and then import it into VBA.



Rob

 

[Chris Newton]

Thank you Robert. This is exactly what I wanted. Pity the same property
dialog to set these attributes was never included in Office 2007.

Appreciate your help.

Thanks
Chris