Get adodb recordset into Access report or table

N

neilr

Does anyone know how to put the results of an adodb recordset into a
report? MS accepts there is a problem with MyReport.recordset =
MyRecordset but their suggestion is to use MyReport.recordsource =
MyRecordset.Name. But the recordset is from SQL so it is an adodb
recordset and does not have a "Name" property. Any brighter ideas?

Alternatively, can anyone help me insert / append the adodb recordset
into an Access table so I could base the report on that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parsing a recordset from an Oracle DB in Word with VBA 0
Class Module returning ADODB recordset that can be assigned to forms or controls. 4
SQL queries on the Mac 0
>> ADO Updateable recordset 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Disconnected recordset with filter and sort appliedshows only 100 records when bound to an access co 0
Report based on ADODB recordset 2
ADODB Recordset 2

Top