Arthur Fuller
fuller.artful at gmail.com
Thu Mar 21 22:52:58 CDT 2013
Thanks Stuart! A. On Thu, Mar 21, 2013 at 9:42 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote: > 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 > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Arthur Cell: 647.710.1314 Prediction is difficult, especially of the future. -- Niels Bohr