jwcolby
jwcolby at colbyconsulting.com
Tue Feb 23 18:14:46 CST 2010
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 >> >