find & change

[slimjen]

Hi all. Using ms access 2010. I've search the internet with no avail. Asked this question in another forum but wanted to see if I got any other suggestions. Is there a
vba code to search and change all default values in tables or criteria in
queries from one word or number to another word or number at the same time? Ex.


I would like to search if a default value is = to "odd" change to "even" or
criteria in a number in a query = 213 change to 214. I have several tables and
queries and don't know which contain the words or values need to change and it
would be very time consuming design viewing all the objects to find them. Thank
you

[June7]

Need third-party software. I use Rick Fisher's Find and Replace. Cost about $50. Saved my sanity a few times.

Or you could write your own Add-in program. I recommend just buying Fisher's.

[ssanfu]

Here is a link to Rick Fisher's Find and Replace (30 day trial - Registration cost is $37 per copy)
http://www.rickworld.com/products.html

Also a link to V-Tools
http://www.skrol29.com/us/vtools.php