Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

You must either use DAO or else dump the ADO recordset to a temporary table, and then bind the report to that temporary table. The read/write behavior of the Recordset property is determined by the ...

Key Concepts in the Code: Object-Oriented VBA: The code uses custom classes (cMod_Curve, cMod_Bond) to handle financial data and operations, showcasing object-oriented programming in VBA. ADODB for ...

I have a recordset (rst) which I have created using an OpenRecordset Method on an existing table...call it t_Employee: Set rst = db.OpenRecordset("t_Employee", dbOpenDynaset) I want to be able to ...