search for use of a function in all queries

[supmktg]

I have built a number of queries using the built-in function 'replace'. I have discovered that this function works fine in vba, but is causing problems in my queries. I have created my own 'replaceinquery' function and it is working properly.

I would like to search all of my queries to determine if I have used the built-in 'replace' function anywhere else. Can anyone tell me how to do that?

Thanks,
Sup

 

[jdraw]

You could write all of your querydef.sql to a text file and search through that with Notepad or similar.
Along the lines
For each qry in db.querydefs
write qry.sql to textfile...

 

[boblarson]

A quick way is to download the free V-Tools and then use their Total Deep Search tool.

 

[Simon_MT]

Bob,

Does this do what it is "on the box". There are times when you what to change something instead of manually going through all your queries, forms reports. I'll give you an example, years ago that's my excuse I created a variable called Size relating to what measurement I was going to use - Imperial or Metric. This worked until I came to web applications and Sze is reserved so I manually when through my application and changed the name.

Can Vtools search for Size and allow you to make the appropriate changes through the database? If it does that would be brilliant.

Simon

 

[boblarson]

Bob,

Does this do what it is "on the box". There are times when you what to change something instead of manually going through all your queries, forms reports. I'll give you an example, years ago that's my excuse I created a variable called Size relating to what measurement I was going to use - Imperial or Metric. This worked until I came to web applications and Sze is reserved so I manually when through my application and changed the name.

Can Vtools search for Size and allow you to make the appropriate changes through the database? If it does that would be brilliant.

Simon

V-Tools' Total Deep Search does let you do search AND replace. If you want more options though than what it gives, it is well worth the money to buy Rick Fisher's Find and Replace tool.

 

[supmktg]

Bob,

Are you familiar with mz-tools? I have been using it for quite a while, mostly for error handling and message boxes. It also has a find and replace feature, but it seems to only look in the vba code.

I've looked at v-tools, but I was concerned about having 2 add-ins that are so similar installed at the same time. The application's end users do not have mz-tools nor will they have v-tools installed. Should I be concerned about conflicts or corruption if I add v-tools? Do you have both mz-tools and v-tools installed?

Thanks,
Sup

 

[boblarson]

I use MZ Tools, V-Tools, Rick Fisher's Find and Replace, and Smart Indenter.

MZ Tools does what V-Tools doesn't and V-Tools has a lot of functionality that MZ Tools does not. So together they supplement each other well.