Array element appears to lose value (Access 2002, XP SP2)

[Jack]

Hi there,
I have an multi-dimensional array (5,i) (5 'columns', i 'rows') where
i is the number of records in the recordset that I use to populate the
array and hence the number of 'rows' in the array . I want to use the
array repeatedly to provide information elsewhere in my app. When I
first call on the Array values in 'columns' 1 to 5 in 'rows' 1 to i
they are all present as expected.

On the second time of calling on the array (ie starting at i=1 again),
one of the array elements (5,i) returns an empty string "" but ALL of
the other array elements ie (1,i), (2,i) etc are still populated.

I have set Option Base 1

Any thoughts/suggestions/prior experience?

TIA,
Jack

[Tom van Stiphout]

On 16 Feb 2005 04:24:28 -0800, ky*****@yahoo.com (Jack) wrote:

In many cases you can use the recordset itself to hold data, and get
rid of the array altogether.

-Tom.

Hi there,
I have an multi-dimensional array (5,i) (5 'columns', i 'rows') where
i is the number of records in the recordset that I use to populate the
array and hence the number of 'rows' in the array . I want to use the
array repeatedly to provide information elsewhere in my app. When I
first call on the Array values in 'columns' 1 to 5 in 'rows' 1 to i
they are all present as expected.

On the second time of calling on the array (ie starting at i=1 again),
one of the array elements (5,i) returns an empty string "" but ALL of
the other array elements ie (1,i), (2,i) etc are still populated.

I have set Option Base 1

Any thoughts/suggestions/prior experience?

TIA,
Jack