[AccessD] QueryDefs question

Stuart McLachlan stuart at lexacorp.com.pg
Thu Mar 21 20:37:49 CDT 2013


Function GetQueryType()
Dim qdf As QueryDef
For Each qdf In CurrentDb.QueryDefs
    Debug.Print qdf.Name, qdf.Type
Next
End Function

Passthrough is Type 112.

-- 
Stuart

On 21 Mar 2013 at 21:27, Arthur Fuller wrote:

> Does someone know how to identify which QueryDefs are Pass-Thru Queries. I
> want to walk the list of QueryDefs and visit the PTQs and only those.
> 
> TIA,
> -- 
> Arthur
> Cell: 647.710.1314
> 
> As lousy as things are now, tomorrow they will be somebody's good old days.
> 
> - Gerald Barzan
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list