Passing Arrays around Classes and subs

[Ecniv]

Access 2003 - VBA module (form) and Class module

Hi,

Simple enough, I have an array on a form, and I want to pass it to a class. Problem is I haven't done this in a while and I cannot seem to get a reference working yet.

The class property I am using is Let and has a variant type. The array on the form is two dimensional and is a string.

I am getting error 13 - wrong data type.

Can someone please point me in the right direction as my brain has died...
(Due to a wrong filename this morning stopping my FTP connection reading local files correctly - found and fixed that, but this is just plain annoying)

[westconn1]

you will need to convert you string array to variant array of strings

probably won't be able to "convert" the array, so you will have to copy the elements into a new array of variant type

pete

[Ecniv]

Hmmm - I knew the arrays were useful and I recall (vaguely) that I had this problem before. Not exactly what I wanted to do, but I guess I have no choice.

All I wanted was a reference to the array held on the form (or module) and then I can nuse the code in the class to pull the data I need from it. Not possible huh?

I'll have another experiment and see.

Thanks for the reply


Edit:
I have tried a simple one to another referenced array - and it works !!
This is only between subs in the same module though, and I have a feeling Classes screwed that up a little. I'll post back in a while.

[westconn1]

can't you just use (declare) a variant array to start with?

some arrays can be converted but after doing some reading on it it is not very many and i'm not sure which

pete

[Ecniv]

Weirdly it is now working from form module to class.. Although I have shifted the Array to a module and made it public, the pointers are still variants and appear to be referencing the array as required.

Thanks for the reply