Searching for text

[Becky]

hello

I recently changed the name of one of my forms. Then I used search/replace
to change the name wherever it appeared in VBA code. Later I got errors
because I had neglected to change the name where it appeared in two queries
and two filter properties.

Here's my question: What is a good way to find the form's name (or any
text, I suppose) wherever it appears in a database?

Thanks
Becky

 

[Gina Whipp]

Becky,

That is one of the problems of Find and Replace utilities, they don't always
find EVERY spot you used the name of the object and/or field. I try to 'get
it named right' the first time, however, in the event I do rename something
I go looking thru the queries that I know the form uses. How do I know
that? I use the Description field when creating my queries, forms, tables,
modules, etc...

I'm secretly hoping someone has found a REAL Find and Replace and will
'share the wealth'.

 

[Peter Hibbs]

Gina (and Becky),

Perhaps you should look at item 10 (Code10.zip) on this site :-
http://www.helenfeddema.com/CodeSamples.htm

I haven't tried it myself although I (and probably a lot of other
developers) would be interested to know if it works satisfactorily.

HTH

Peter Hibbs.

P.S. You can also order hand knitted garments from this site - what
more could you want!

 

[Gina Whipp]

Peter,

I have tried that, it has been awhile but it also has the problem of not
searching 'within' the query. Or it did back when I tried it. Thanks for
the suggestion... I'll be keeping my fingers crossed that someone has
something to do this task!