Report based on ADODB recordset

[Nicola Jones]

I am trying to create a report based on an ADODB recordset. I have used a KB
article (Q132881) as a basis and after quite a bit of tweaking have
successfully got pages with the data on. However I am having real problems
getting it to recognise when it has reached the last page. Does anybody have
a nice simple example of this that they can post or a link they can point me
to.

Many thanks

 

[SA]

Nicola:

Doing this any version prior to Access 2003 is pretty flakey. What version
are you using and what do you mean having trouble recognizing when it
reaches the last page?

 

[Nicola Jones]

I am doing this in Access 2003, but my recordset comes from a connection to a
Access 97 database. I have now sorted it. It was a lot simpler once I
worked out I could set the Me.NextRecord and Me.MoveLayout properties in
detail_print.