In Access VBA, you use recordsets very frequently, don't you? Especially when you want to output to Excel, your degree of freedom changes depending on whether you can use recordsets or not. Recordsets ...

Sets or returns the SQL statement that defines the query executed by a QueryDef object. The SQL property contains the SQL statement that determines how records are selected, grouped, and ordered when ...

Sets or returns a value that indicates whether an SQL pass-through query to an external database returns records (Microsoft Access workspaces only). This example uses the Connect and ReturnsRecords ...

*expression* A variable that represents a **QueryDef** object. ## Remarks The **SQL** property contains the SQL statement that determines how records are selected, grouped, and ordered when you ...

In a Microsoft Access workspace, if you provide anything other than a zero-length string for the name when you create a **QueryDef**, the resulting **QueryDef** object is automatically appended to the ...