getrows problem with a dao recordset

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?

I'm using Access 2000.

re: getrows problem with a dao recordset

On Aug 08 2004, 09:25 am, <arch> wrote in
news:41162632$1@funnel.arach.net.au:
[color=blue]
> 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?[/color]

To ensure that you get all rows, you do need to fully populate the
recordset by using MoveLast, then use MoveFirst, then GetRows.

--
remove a 9 to reply by email

re: getrows problem with a dao recordset

Great. I tried that and it works. thanks.

"Dimitri Furman" <dfurman@cloud99.net> wrote in message
news:Xns953F7736B1EF2dfurmancloud99@127.0.0.1...[color=blue]
> On Aug 08 2004, 09:25 am, <arch> wrote in
> news:41162632$1@funnel.arach.net.au:
>[color=green]
> > sometimes when I call getrows from a dao recordset, I get only one row[/color][/color]
of[color=blue][color=green]
> > 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[/color][/color]
I[color=blue][color=green]
> > get all records?[/color]
>
> To ensure that you get all rows, you do need to fully populate the
> recordset by using MoveLast, then use MoveFirst, then GetRows.
>
> --
> remove a 9 to reply by email[/color]