[AccessD] Find Every Occurance Of A Query

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


More information about the AccessD mailing list