Using a String in an array?

[BigJimSlade]

Hey, Big Jim here,

Is there anyway to use a string in an array?

Say I had:

Dim intTest(strWords, 1 to 5) as Integer

Something along those lines. Is it possible?


Thanks in advance....Big Jim

 

[kaspi]

Hi Big Jim
It seems to me that you may be better of using access collection.

dim col as Access.collection
dim var_Cur as variant

set col = new access.collection

col.add str1, "1"
col.add str2, "2" etc

for each var_cur in col
''you code for working with your strings
next var_cur

'alternatively you can reference the segments as col("1") etc.

Hope it helps
kaspi

 

[BigJimSlade]

Thanks, Kaspi!

Big Jim is greatful that you could help him out. You're the best!


Big Jim