Use an 'array' in VBA?

[InkyRich]

Hi all,
In my distant past (in good old Basic programming - shows how old I am) I recall using an array to assign a value to a variable (say x) to collect a value in a loop (like x1 first pass, x2 second pass etc.)
I am trying to do the same in VBA in an Access database within a loop. I have created a variable called BirthdateVar and in each pass through the loop I want to take the value of x and place it on the end of the variable so that I can then take that value and use it.
Can you tell me what the syntax is for this? Remembering the old Basic I have tried BirthdateVar(x) but it doesnt work.
Any suggestions please?

Hampshire UK.

A fool and his money are soon parted - so you might as well send it to me!

 

[dhookom]

I still find arrays a bit complex particularly when dimensioning and redimensioning. Since you haven't provided any code I would suggest you start by searching the web for a good resource.

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

A very basic sample of an array:

Dim [blue]BirthDateVar(5)[/blue] As String
Dim i As Integer

[blue]BirthDateVar(0) = "ABC"
BirthDateVar(1) = "XYZ"
BirthDateVar(2) = "UYT"
BirthDateVar(3) = "OPR"
BirthDateVar(4) = "KLM"
BirthDateVar(5) = "WER"[/blue]

For i = LBound([blue]BirthDateVar[/blue]) To UBound([blue]BirthDateVar[/blue])
    Debug.Print "BirthDateVar with index of " & i & " has a value of " & [blue]BirthDateVar(i)[/blue]
Next i

Have fun.

---- Andy

 

[InkyRich]

Thanks chaps,
I will give it a go.
And thanks for the code.

Hampshire UK.

A fool and his money are soon parted - so you might as well send it to me!

 

[MajP]

This is a great resource for arrays in vba.

http://www.cpearson.com/excel/vbaarrays.htm

I have taken most of this code and keep it in a module. Then you can do things like add and remove from an array dynamically.