need an analysis tool...

B

Brad Pears

I am working on an Access 2000 project. Part of this project is to clean up
some of the field names etc.. as many now are not what the field name says
it is...

Many of these fields are located in modules, forms, queries, reports, macros
etc... etc.... Also in many cases they may be part of a select clause
within code or within a forms datasource property etc.. Also in dsums,
dcounts - ypou name it...

Is there any tool out there that will allow you to find every instance - not
matter where it is or in what form it's in of a particular field or for that
matter anything - a formname, report name etc.... Basically I need a search
and replace utility that does this for every Access object - not just
code...

Any help would be most appreciated!

brad
 
M

Mike Labosh

Is there any tool out there that will allow you to find every instance -
not
matter where it is or in what form it's in of a particular field or for
that
matter anything - a formname, report name etc.... Basically I need a
search
and replace utility that does this for every Access object - not just
code...
Click to expand...

These folks sell LOTS of goodies for stuff like that:

http://www.fmsinc.com/Products/access.asp
 
L

LeAnne

(some inappropriate Reply-To ng's snipped)

Brad said:
I am working on an Access 2000 project. Part of this project is to clean up
some of the field names etc.. as many now are not what the field name says
it is...

Many of these fields are located in modules, forms, queries, reports, macros
etc... etc.... Also in many cases they may be part of a select clause
within code or within a forms datasource property etc.. Also in dsums,
dcounts - ypou name it...

Is there any tool out there that will allow you to find every instance - not
matter where it is or in what form it's in of a particular field or for that
matter anything - a formname, report name etc.... Basically I need a search
and replace utility that does this for every Access object - not just
code...

Any help would be most appreciated!

brad
Click to expand...
I can personally recommend Rick Fisher's Find and Replace. Good,
versatile tool, and quite reasonably priced:

http://www.rickworld.com/products.html

hth,

LeAnne
 
Top