Disconnected Recordsets

[JJ]

Hi All,

Heres a question for all you gurus out there. I have access 2002 and in
code behind I am populating a disconnected recordset. In the report code
behind I set me.recordset = rst and it produces error down the page. I use a
normal recordset not disconnected using this statement and it works. What
am I doing wrong with disconnected recordset?


Thanks,

JJ

 

[Larry Linson]

ADO disconnected recordset? What's the specific "error down the page" and
what are the specifics ... first detail, first data, or something else?
Clarify and maybe someone can help.

 

[JJ]

Hi Larry,

I found out my problem. When I was inserting data into the disconnected
recordset I used rst.Update
instead of using rst.BatchUpdate. This fixed my problem and works
beautifully IN 2002. Using disconnected recordsets
in a report is a really good way to populate reports.

So Heres another question. How can I populate a report using a disconnected
recordset in vers 2000? I tryed
to loop through a the recordset in the detail print but only prints the last
line. I need some kind of newlineto be feed to the report
so that it prints all lines. Any Ideas?

Thanks,

JJ

 

[Larry Linson]

So Heres another question. How can
I populate a report using a disconnected
recordset in vers 2000?

IIRC, I don't think you can, but I haven't used A2000 for a while and don't
use ADO to any extent, either.

I tryed to loop through a the recordset in
the detail print but only prints the last
line. I need some kind of newlineto be
feed to the report so that it prints all lines.
Any Ideas?

I'm not sure what you mean, here. Could you clarify? Maybe even include the
code you are describing.

Larry Linson
Microsoft Access MVP