Gary Kjos
garykjos at hotmail.com
Fri May 7 09:26:18 CDT 2004
Just do a query on MSysObjects table SELECT MSysObjects.Type, MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=5)) ORDER BY MSysObjects.Name; Gary Kjos garykjos at hotmail.com >From: paul.hartland at fsmail.net >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: accessd <accessd at databaseadvisors.com> >Subject: [AccessD] List Queries >Date: Fri, 7 May 2004 12:19:46 +0200 (CEST) > >To all, >Gone totally brain dead, I want to print a list of all my queries in a >database (500+) I only want the names and Documenter don't cater for this. >So has anyone got any sample code for the QueryDef object that I could >probably get a list that way ? >Thanks in advance >Paul > >-- > >Whatever you Wanadoo: >http://www.wanadoo.co.uk/time/ > >This email has been checked for most known viruses - find out more at: >http://www.wanadoo.co.uk/help/id/7098.htm >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com