View Recordset Results 1

[cranebill]

Is there a way to view a code driven recordset results in possibly something like datasheet mode?

This is basically for troubleshooting purposes.

Bill

 

[DaltonVB]

Are you using ADO or DAO?

What I have done to see what kind of records I am getting back is put the source of the recordset into a query and open the query.

szQuery = "SELECT * " _
        & "  FROM sys_tblqueries " _
        & " WHERE hasRun = false " _
        & "   AND active = true ORDER BY RunOrder;"
    
Set adoRSQueries = New ADODB.Recordset
adoRSQueries.Open szQuery, CurrentProject.Connection, _
                  adOpenStatic, adLockOptimistic

CurrentDb.QueryDefs("tempQuery").SQL = szQuery
CurrentDb.QueryDefs.Refresh

DoCmd.OpenQuery "tempQuery", acViewNormal

"tempQuery" would be a query from the same database as the source of your recordset.