Search Modules

[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?

 

[Marshall Barton]

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.