Clipper2000
Programmer
Hi,
There is a discussion in the Access Reports forum on how to attach an ADO recordset to the Me.RecordSource property. So far attaching an ADO recordset to the RecordSource property doesn't seem possible in a regular report, it may be possible in ADP. This is because the Me.RecordSource only accepts a SQL string (the key word here is string).
To circumscribe this issue, I can make this work by an intermediary step via creating an Access SQL string first using perhaps the DAO object. But this also seems to present a challenge because the JET SQL only works on tables and JET SQL definitions, not on a virtual ADO recordset. Can JET SQL query an ADO recordset? I would be very much appreciated if someone can show me the codes here.
There is a discussion in the Access Reports forum on how to attach an ADO recordset to the Me.RecordSource property. So far attaching an ADO recordset to the RecordSource property doesn't seem possible in a regular report, it may be possible in ADP. This is because the Me.RecordSource only accepts a SQL string (the key word here is string).
To circumscribe this issue, I can make this work by an intermediary step via creating an Access SQL string first using perhaps the DAO object. But this also seems to present a challenge because the JET SQL only works on tables and JET SQL definitions, not on a virtual ADO recordset. Can JET SQL query an ADO recordset? I would be very much appreciated if someone can show me the codes here.