How to pass an dynamic array between modules?

[Troy]

I have a dilemma where I am creating a dynamic two dimensional array
and filling it with information from a .csv file. Unfortunately,
later when I try to call that information back from the array I get an
error or I don't get anything back at all. I'm not sure how to make a
dynamic array public (so to speak) so that I can call the information
back between modules or forms. Can anyone help? Thanks.

[Rich P]

There are a couple of ways to deal with this. Way one is to make your
dynamic array global. That way it is not likely to go out of scope.
When the array goes out of scope, you lose all your data - the garbage
collector underneath the hood of Access will destroy all resources
connected to that array and release resources from the heap - deallocate
memory.

An easier way to deal with this would be to write the data from the CSV
file to a table. Then use the data from the table.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Stephen Lebans]

Pass the array by reference within the function.

Public Function fGetContentsStream(ByRef arrayOLE() As Byte, _
FileExtension As String, _
Optional FileNamePackage As String = "") As Boolean

Now in the function itself, you can redim the array as desired.

' Size our main array
ReDim arrayOLE(0 To UBound(arrayB))

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Troy" <Tr**********@gmail.comwrote in message
news:11**********************@e65g2000hsc.googlegr oups.com...

>I have a dilemma where I am creating a dynamic two dimensional array
and filling it with information from a .csv file. Unfortunately,
later when I try to call that information back from the array I get an
error or I don't get anything back at all. I'm not sure how to make a
dynamic array public (so to speak) so that I can call the information
back between modules or forms. Can anyone help? Thanks.

[The Frog]

Hi Troy,

You can also pass the array to a sub the same way as a function, as
long as you use the byref keyword.

If you make the array global it will be available to everything, and
if you simply dim it inside a procedure it will be destroyed at the
end of the procedure.

The key here in using it is to make sure you use the ByRef keyword
when passing it around if you want to 'send' it to a sub or function.

Cheers

The Frog