[AccessD] ...collections guru?

...uh huh ...dotage setting in, eh ;)

William

--------------------------------------------------
From: "jwcolby" <jwcolby at colbyconsulting.com>
Sent: Tuesday, February 23, 2010 7:14 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] ...collections guru?

> No time for battle.
>
> ;)
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> William Hindman wrote:
>> ...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
>>>
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>