PC Review


Reply
Thread Tools Rate Thread

Search Modules

 
 
ERICH
Guest
Posts: n/a
 
      24th May 2004
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?
 
Reply With Quote
 
 
 
 
Marshall Barton
Guest
Posts: n/a
 
      24th May 2004
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]
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Public Variables, Class Modules and Standard Modules Excel Monkey Microsoft Excel Programming 2 30th Apr 2009 04:18 PM
Search Modules for Cell Addresses in Range Variables ExcelMonkey Microsoft Excel Programming 0 17th Dec 2007 04:45 PM
Code to search and replace info on modules =?Utf-8?B?QnJldHQgU21pdGg=?= Microsoft Excel Programming 2 12th Jan 2006 09:58 PM
Public, Private, Event modules, Forms modules,,, Jim May Microsoft Excel Programming 11 31st Oct 2005 04:12 AM
Search modules programmatically Morten Snedker Microsoft Access Form Coding 1 30th Nov 2004 06:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:35 PM.