Find and Replace

[InFlight]

This question is about an old program called "Find and Replace 9.0" by Rick Fisher
I used to use it when I had Office 2003 now I am using 2010 and it want work anymore.
The program provides a "Find and Replace" function for Tables (searching design elements such as field names, not the data in the table), Queries, Forms, Reports, Macros, and Modules (Access only provides Find and Replace for Modules/CBF). Find And Replace can be used to change names of objects through the entire database.

If you wanted to change a field name this program would change it everywhere, Queries, Forms, Reports, Macros, and Modules.
Does anyone know of any other program that can do this?

 

[isladogs]

AFAIK Rick Fisher's code is no longer available online.

However, there is a free addin called V-Tools by skrol that works very well
http://www.skrol29.com/us/vtools.php

The only thing it doesn't (or didn't) do is replace in macros.
That's because the macro code isn't VBA and contains lots of 'irrelevant' junk that needs to be ignored.

I created my own code that also manages find & replace in macros.
However, its part of a large commercial app and I've never got around to separating the code into a standalone app.

 

[Gasman]

If you use it that much, $37 is pretty cheap I would have thought?

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

 

[isladogs]

Looks like I was wrong & that it is still available online.

However, I notice that the most recent version' v9 also can't do search and replace in macros (A2007 onwards).
So you may as well try V-Tools which is free.

Looks like it would be worth me releasing my own version as it does do replace in macros...but I would need to charge for it as it was several weeks work!

See attached screenshots

 

[Gasman]

Go for it Colin, cannot hurt.

 

[InFlight]

Is the program (of the screen pic's you show ) available. Can it search the whole DB

 

[isladogs]

My version (shown in the screenshots) searches the entire database ... or whichever parts you want it to search.

As I said in an earlier post its currently embedded into one of my commercial apps
I've started separating it out into a standalone app.
Its going to take me a few days to finish due to other commitments but it will then be available at a lower price than Rick Fisher's utility.

As well as a deep search and replace of ALL database objects, it will include:
a) list of all database objects (by object type)
b) database statistics