[AccessD] ...collections guru?

Mark,
I think you have that back to front....Testing for 1 will always  work for a
non-empty container.

Test for 0 and if that blows up then you know it is 1  based.

BTW, all the example for  MS Access show 1 based including those in the F1
help.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: 18 February 2010 01:57
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] ...collections guru?

> Ummm, not true JWC, collections are 1 based.
>
> Drew

I love this discussion because it doesn't seem like there was any
CONSISTENCY applied...
Excel may be different than Access and different than Word, etc...
My solution: First test for 1 based and if the test loop blows-up on the
COUNT,
 then it's 0 based.




-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com