[AccessD] ...collections guru?

...I smell a jc battle coming on ...long time since jc went to war ...miss 
those days, I do :)

William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Thursday, February 18, 2010 2:46 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>