QueryDef.Type property (DAO)
Applies to: Access 2013, Office 2013
Sets or returns a value that indicates the operational type or data type of an object. Read-onlyInteger.
Syntax
expression .Type
expression A variable that represents a QueryDef object.
Remarks
For a QueryDef object, the possible settings and return values are shown in the following table.
Constant |
Query type |
|---|---|
dbQAction |
Action |
dbQAppend |
Append |
dbQCompound |
Compound |
dbQCrosstab |
Crosstab |
dbQDDL |
Data-definition |
dbQDelete |
Delete |
dbQMakeTable |
Make-table |
dbQProcedure |
Procedure (ODBCDirect workspaces only) NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. |
dbQSelect |
Select |
dbQSetOperation |
Union |
dbQSPTBulk |
Used with dbQSQLPassThrough to specify a query that doesn't return records (Microsoft Access workspaces only). |
dbQSQLPassThrough |
Pass-through (Microsoft Access workspaces only) |
dbQUpdate |
Update |
When you append a new Field, Parameter, or Property object to the collection of an Index, QueryDef, Recordset, or TableDef object, an error occurs if the underlying database doesn't support the data type specified for the new object.