QueryDef

Methods

Name	Returns	Description
Cancel		Cancels execution of an asynchronous OpenRecordset method.
Close		Closes an open DAO object.
CreateProperty	Property	Creates a new user -defined Property object.
Execute		Executes an action query.
OpenRecordset	Recordset	Creates a new Recordset object.

Properties

Name	Returns	Description
CacheSize	Long	Sets or returns the number of records to be locally cached from an ODBC data source.
Connect	String	Sets or returns a value providing information about a data source for a QueryDef .
DateCreated	Variant	Returns the date and time when the QueryDef was created. Read-only.
Fields	Fields	Collection of Field objects in a QueryDef object. Read-only.
LastUpdated	Variant	Returns the date and time of the most recent change to an object. Read-only.
MaxRecords	Long	Indicates the maximum number of records to return from a query.
Name	String	Returns the name of this object.
ODBCTimeout	Integer	Sets or returns the number of seconds before a timeout occurs on an ODBC database.
Parameters	Parameters	Collection of Parameter objects available for a QueryDef object. Read-only.
Prepare	Variant	Indicates whether to prepare a temporary stored procedure from the query.
Properties	Properties	Collection of Property objects. Read-only.
RecordsAffected	Long	Returns the number of records affected by the last Execute method. Read-only.
ReturnsRecords	Boolean	Sets or returns a value indicating whether a SQL pass-through returns records.
SQL	String	Sets or returns the SQL statement that defines the query.
StillExecuting	Boolean	Indicates whether an asynchronous method call is still executing. Read-only.
Type	Integer	Sets or returns the data type of an object.
Updatable	Boolean	Returns whether the query definition can be change. Read-only.