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!
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!