Dynamic array

[Warrio]

Hello!

Is it possible to have in Access an array without prespecifying its limit?
I can use array(0 to 1000), but I know if one day if my array goes more than
1002 elements, my program will bug

Thanks for any suggestion!

 

[Guest]

Yes it is. Look in Help for the Redim statement. You can use the Preserve
option to keep the data currently in the array.

 

[Warrio]

that's what I was looking for!
Thanks a lot!!

 

[Guest]

If you google on "dynamic array ms access" you'll get this link titled -
"Simplify Your Code Using Array Variables(Inside Microsoft Access...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima00/html/ima0077.asp

It's a great explanation with a good code sample. Be aware it's written in
DAO, so make sure you either have the reference checked or make the relevent
code changes to ADO.

 

[Warrio]

Thanks again!!
That's the answer to the original question found in your link: