Search Modules

  • Thread starter Thread starter ERICH
  • Start date Start date
E

ERICH

Is there a way to perform a mass search on the modules?
You can create queries to scan all MS Access queries for a
given text. I think it scans the MS OBjects tables. Is
ther a way to do this to scan all modules and view the
results in record set format?
 
ERICH said:
Is there a way to perform a mass search on the modules?
You can create queries to scan all MS Access queries for a
given text. I think it scans the MS OBjects tables. Is
ther a way to do this to scan all modules and view the
results in record set format?


The VBA development window allows several options on the
Edit - Find feature to search only a single procedure the
current module or all modules. It will not make a list of
the matches (in a recordset or otherwise).

You can write a procedure that opens each module in the
Containers("Modules").Documents collection and searches the
module's code for a string. See Help on the properties and
methods available for use with a module object.
 
Back
Top