Source Code

M

Michael C

I've written some code into access to find unused queries and tables. This
checks the RecordSource of forms and reports and checks to see if other
queries access it also. But The query could still be used in source code, is
there a way to programatically search the source code in access?

Thanks,
Michael
 
A

Arvin Meyer [MVP]

You can use the Find Method on a module:

object.Find(target, startline, startcolumn, endline, endcolumn[, wholeword,
matchcase, patternsearch])

See the help files for more info.
 
T

Tom van Stiphout

On Thu, 14 Feb 2008 11:52:34 +1100, "Michael C" <[email protected]>
wrote:

Not to burst your bubble, but there are a few low-cost search
utilities already on the market. "Speed Ferret" and Rick Fisher's
"Find and Replace" are two of them.

-Tom.
 
M

Michael C

Tom van Stiphout said:
Not to burst your bubble, but there are a few low-cost search
utilities already on the market. "Speed Ferret" and Rick Fisher's
"Find and Replace" are two of them.
Click to expand...

This is not bursting my bubble, I'm quite happy to not write this. I'm not
actually wanting to specifically search code, I want to find any unused
queries in the database, or in the case that they are used I want to find
where they are used. I want to do the same for tables. I need to do some
housecleaning on a project I have inherited. :)

Michael
 
T

Tom van Stiphout

Check out the tools at fmsinc.com. I believe their Analyzer tool can
do just that.

-Tom.
 
O

Ownor

Tom van Stiphout said:
Not to burst your bubble, but there are a few low-cost search
utilities already on the market. "Speed Ferret" and Rick Fisher's
"Find and Replace" are two of them.

-Tom.
Click to expand...
 
A

Arvin Meyer [MVP]

John W. Vinson said:
I use Speed Ferret quite often.
Click to expand...

I do also and have since Access 2.0. I find it invaluable for finding (and
if necessary, replacing) anything. The FMS tool, although more expensive,
may be better for analyzing usage.
 
Top