getrows problem with a dao recordset

[Douglas J. Steele]

How are you calling it?

 

[Guest]

sometimes when I call getrows from a dao recordset, I get only one row of
data, instead of all rows. This happens even though I haven't called
movefirst or movelast. how do I prevent this from happening and ensure I
get all records?

 

[Guest]

'get multilevel map
qMultiLevelMap = "SELECT * FROM qry_Multi_Level_Map"
Set rsMultilevelMap = db.OpenRecordset(qMultiLevelMap, dbOpenSnapshot)
If Not rsMultilevelMap.BOF Then arsMultilevelMap =
rsMultilevelMap.GetRows
rsMultilevelMap.Close

 

[Douglas J. Steele]

The GetRows method expects you to tell it how many rows you want to fetch:

If Not rsMultilevelMap.BOF Then arsMultilevelMap =
rsMultilevelMap.GetRows(10)

While this reference is for Access 97, it'll apply equally well to other
versions:
http://msdn.microsoft.com/library/en-us/office97/html/output/f1/d2/s5a2b1.asp