I have a multidimensional array that is 6 colums wide.
I am populating it from a recordset and therefore do not know the length so I using a dynamic array as below
currentfile = 0
WHILE NOT MyRS2.EOF
IF currentfile = 0 Then
' do nothing
Redim Preserve ArrPassed(5,currentfile)
ArrPassed(vantivenumber,currentfile) = MyRS("vantivenumber")
ArrPassed(teamname,currentfile) = MyRS("teamname")
ArrPassed(passedreason,currentfile) = MyRS("passedreason")
ArrPassed(timetaken,currentfile) = MyRS("timetaken")
ArrPassed(notes,currentfile) = MyRS("notes")
ArrPassed(dateentered,currentfile) = MyRS("dateentered")
currentfile = currentfile + 1
I am now trying to find out how to find out the ubound limits of the array so i can do a for next loop but i cant seem to figure it out from the many articles i have read.
This is extremely urgent hence the points.