Does a querydef object's returnrecords property automatically equal true for all select queries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MLH - 02 May 2008 02:21 GMT

Does a querydef object's returnrecords property automatically
equal true for all SELECT queries? Or, must the QueryDef Object
ACTUALLY return at least 1 or more records WHEN RUN in
order for the ReturnRecords property to equal True? I'm speaking,
of course, in a DAO setting.

Reply to this Message

Tom van Stiphout - 02 May 2008 05:04 GMT

There is no such property, but there is a similar one. From the help
file:
ReturnsRecords Sets or returns a value that indicates whether an SQL
pass-through query to an external database returns records (Microsoft
Access workspaces only).
If you are in an Access FE, Access BE environment, you should not use
this property.

-Tom.

>Does a querydef object's returnrecords property automatically
>equal true for all SELECT queries? Or, must the QueryDef Object
>ACTUALLY return at least 1 or more records WHEN RUN in
>order for the ReturnRecords property to equal True? I'm speaking,
>of course, in a DAO setting.

Reply to this Message