Access Database Design and Programming, Second Edition

QueryDef Object

Collections

Property	Type	Version	Description
Fields	Fields	3.0/3.5	Collection of fields in the QueryDef object
Parameters	Parameters	3.0/3.5	Collection of Parameter objects in the QueryDef object
Properties	Properties	3.0/3.5	Collection of Property objects in the QueryDef object

Methods

Method	Parameters	Returns	Version	Description
Cancel		Sub	3.5	Cancels execution of an asynchronous OpenRecordset method
Close		Sub	3.0/3.5	Closes the open QueryDef object
CreateProperty	[Name], [Type], [Value], [DDL]	Property	3.0/3.5	Creates a new user-defined Property object
Execute	[Options]	Sub	3.0/3.5	Execute the Querydef
OpenRecordset	[Type], [Options]	Recordset	3.0	Creates a new Recordset object
OpenRecordset	[Type], [Options], [LockEdit]	Recordset	3.5	Creates a new Recordset object

Properties

Property	Type	Version	Description
CacheSize	Long	3.5	Number of records to be locally cached from an ODBC data source
Connect	String	3.0/3.5	Value providing information about a data source for a QueryDef
DateCreated	Variant	3.0/3.5	Date and time the QueryDef was created
LastUpdated	Variant	3.0/3.5	Date and time of the most recent change to the QueryDef
MaxRecords	Long	3.5	Maximum number of records to return from the query
Name	String	3.0/3.5	Name of this QueryDef object
ODBCTimeout	Integer	3.0/3.5	Number of seconds to wait before a timeout occurs when querying an ODBC database
Prepare	Variant	3.5	Indicates ...