PDA

View Full Version : Array(?)with mixed data types



mud2
04-14-2009, 12:34 PM
Thanks to Oorang for help with enumerated form fields...Next: I want to transfer data to a form. The data consists of strings, integers, and booleans. I can't use an array (Easy to step through), and how does one "step through" a TYPE? How to enumerate a type?? If not a type, then what?

CreganTur
04-14-2009, 01:18 PM
Can you be more specific about what you're trying to do/accomplish?

Norie
04-14-2009, 01:41 PM
Why can't you use an array?

It could be a array of variants and if you need to type them you could use TypeName.

mud2
04-14-2009, 06:02 PM
Gregan Tur:
To Explain...what do I want?
I will generate data, of mixed types. After processing the data I'd like to store it (in an array?) so that I can copy it to fields in a form, by stepping through a loop.
If I could enumerate a TYPE it would be easy. Norie's suggestion mightwork...

I suppose I could "store the data in a temporary form, or table, and then copy to my form, as suggested by Oorang.

Norie
04-15-2009, 01:28 AM
Why do you need to know the type for the data?

Surely it's the position in the array that's the important thing.

stanl
04-15-2009, 03:07 AM
why not just create a fabricated recordset with fieldnames and datatypes which coincide with your form fields? .02 Stan