[AccessD] QueryDefs question

Or "Select Name from msysObjects where Type = 5 and Flags = 112"


On 22 Mar 2013 at 11:37, Stuart McLachlan wrote:

> 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
> > 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>