ERICH wrote:
>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.
--
Marsh
MVP [MS Access]
|