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