Global 'search and replace' function in Access?

[rutica]

I am using Access 2003.

Is there a global 'search and replace' function in Access?

I inherited a database with descriptive field names.

If I change the field name in my table, is there a function that will search all the IIF statements in all my queries to change the name there automatically?

Could it also change the field names in any reports I have?

Thanks,

 

[KeithG]

No but you could write one to do so.

 

[rutica]

You wrote: "No but you could write one to do so. "

How?

Thanks,

 

[boblarson]

Go here and download V-Tools (Free)
http://www.skrol29.com/dev/en_vtools.htm

And use the Total Deep Search which will replace the item name everywhere (except in data).

 

[rutica]

Bob,
thanks! i checked out the website. This seems good also:

Work on Queries: Using this tool, you are able to work on SQL statement for all your queries in the same time. Search for a string or perform a 'search and replace' in all the queries.

But I am at work and can't download. Also, I'm a bit hesitant using this tool since I don't know if I can trust it completely and this is a widely used database....

I tried to look at "My Source Code", but got 'page cannot be found'.

 

[Brianwarnock]

Can you not create a copy of the database and test it out on that, an action I would have thought essential no matter how you amend it.

Brian

 

[boblarson]

I've been using it for years.

 

[rutica]

thanks, I'll try it from home.

 

[rutica]

I just opened my table in Design view and changed the field name. Then, I went into one of the queries and, to my surprise, the IIF statement updated automatically with the new name! I didn't know Access did that! Access 97 didn't do it.

So I don't need any global search and replace afterall.

Thanks anyway.

 

[boblarson]

That is the AutoName correct and it is sometimes okay. I always turn it off as it has been known to corrupt things at times. So, glad you got your stuff working but be careful with the AutoName correct stuff.