iworkonline
Registered User.
- Local time
- Yesterday, 16:04
- Joined
- May 25, 2010
- Messages
- 44
Hi Guys
I need to read the stuff from the recordet into array. I have tried using GetRows method but it only reads one record. Here is how I am doing
Here is how I am extracting the values from the array
myarray(0,0).....
If I limit the results as following then I can read all the records
myarray = ds.GetRows(10)
But I do not want to limit the records.
Please help.
Thanks.
I need to read the stuff from the recordet into array. I have tried using GetRows method but it only reads one record. Here is how I am doing
Code:
Dim myarray As Variant
Dim ds As Dao.Recordset
Set db = CurrentDb
Set qdf = db.QueryDefs("Get_Distinct_Shippers")
qdf.Parameters(0) = [Forms]![Form1]![Text3]
Set ds = qdf.OpenRecordset
myarray = ds.GetRows
Here is how I am extracting the values from the array
myarray(0,0).....
If I limit the results as following then I can read all the records
myarray = ds.GetRows(10)
But I do not want to limit the records.
Please help.
Thanks.