Charlotte Foust
cfoust at infostatsystems.com
Thu Nov 6 10:11:20 CST 2003
You'd have to use something like SpeedFerret from www.moshannon.com to find every instance of qryUnionAvailaibilityTables in the database. It will find them in queries, forms, reports, code, comments, etc. Charlotte Foust -----Original Message----- From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] Sent: Thursday, November 06, 2003 7:40 AM To: accessd Subject: [AccessD] Find Every Occurance Of A Query To all, I have a query named qryUnionAvailabilityTables, is there anyway I can find out any other Query that uses aryUnionAvailabilityTables without going and looking at everyone of them, i.e. some code to loop through all the queries I have looking for this etc. I would look manually but we have over 250 queries in our main database. Thanks for any help in advance....... Paul Hartland _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com