
July 7th, 2005, 07:40 AM
|
|
Registered User
|
|
Join Date: Jun 2005
Posts: 11
Time spent in forums: 1 h 41 m 45 sec
Reputation Power: 0
|
|
|
Visual basic array question
I'm reading in data from a table into an array, however:
How do I declare and set the size of an array to be equal to a number held in a variable
i.e.
Dim fstrvars As Integer
fstrvars = DLookup("[strvars]", "[trial]", "[trialno] =" & ftrialno)
I want to create a single dimention array of 1 to fstrvars, but
Dim ftmp(1 To fstrvars) does not work.
How do I do this?
|