Query - Array

[indesisiv]

Not really sure if this is possible but here goes

I need to place the results of a simple select query into an array. Does anyone know if this is possible ... and if it is how would I go about doing it??

Steve

 

[dcx693]

How to Fill an Array Using Visual or Access Basic
ACC2000: How to Use Visual Basic for Applications to Fill an Array.

 

[indesisiv]

Looks good

Except -
I can't figure out what to do after the array is done.
As soon as the function exits the array is cleared??

So where i call the function from it seems that i can't actually use the array for anything useful.

Any ideas.

Is there a way for me to be able to use the array outside of hte function?

Steve

 

[dcx693]

If you declare the array variable globally, outside of a function (right below where you would normally see Option Compare Database and Option Explicit, the array wil always be available whenever the form/module is open.

 

[indesisiv]

I can't seem to get that to work ...

I think that i am trying to declare the array wrong but i will keep trying.
Also how do you limit the info that goes into the array?

Something like a where statement?

Steve

 

[indesisiv]

I have sorted out the what is going in to the array by basing it on a query
Just can't seem to get the array to work outside of the function.

Damn my monday morning stupidity.

Steve

 

[indesisiv]

Sorry.

Sorry,
My stupid mistake .. i have it all working now ... thanks all for your help!!