[AccessD] Find and Replace

[Rocky Smolin]

Got it! Actually I had it, but didn't remember downloading it and never
tried it because the need went away.

I have a client who changes things.  A lot. But the changes he wants always
make the system better. But he'll change nomenclature and I'm picky about
self documenting code. If there a button that say lease tracking the button
is named cmdLeaseTracking. It opens a form called frmLeaseTracking. Data
source is qryLeaseTracking. Which get records from tblLeaseTracking. All
the fields in tblLeaseTracking start with fldLeaseTracking.

So when he wants to change the button and the title on the form to Lease
Process, what to do? I'm thinking of myself maintaining this 6 months now
and wonder WFT, and a;sp thinking of someone who might take this over
someday. So the button now says Lease Process but all the objects say Lease
Tracking? Global replace, thank you Mr. Fisher. But that doesn't work any
more.

Recently he made a change that affected the architecture of a major part of
the system. That's when I began thinking of global find and replace. But
I'm over the hump now so I can go back to sleep. But that Search for Text
does look like a gem.

r



On Thu, Jun 22, 2023 at 7:56 PM Paul Wolstenholme <
Paul.W at industrialcontrol.co.nz> wrote:

> Rocky,
>
> On 24 April this year I posted this as part of the thread you might be
> referring to.  It is free.
>
> ---
> I use SearchForText v4.2 by Brent Spaulding.  It can be hard to find links
> to it but these ones work:
>
>
> https://social.msdn.microsoft.com/Forums/office/en-US/207eba70-2acd-4890-869a-7b35ac95960f/quick-easy-method-to-find-which-reports-forms-and-queries-use-a-field?forum=accessdev
>
>
> https://social.msdn.microsoft.com/Forums/office/en-US/56652d4b-f0c6-42de-a26d-f355cc1d247a/using-vba-or-some-other-techniques-how-can-i-find-out-which-queries-and-tables-are-used-by-a-form?forum=accessdev
> ---
>
> For completeness I could add that I've changed one line of the code in my
> copy:
> X = 1 + lngCharWhere    ' corrected from x + lngCharWhere by Paul
> Wolstenholme 16/6/2022
>
> Paul Wolstenholme
>
>
> On Fri, 23 Jun 2023 at 05:29, Rocky Smolin <rockysmolin2 at gmail.com> wrote:
>
> > 👍 Thank you.
> >
> > r
> >
> > On Thu, Jun 22, 2023 at 9:36 AM Ryan W <wrwehler at gmail.com> wrote:
> >
> > > Rocky,
> > >  Here ya go
> > >
> > > https://www.utteraccess.com/topics/1992076
> > >
> > > On Wed, Jun 21, 2023 at 4:37 PM Rocky Smolin <rockysmolin2 at gmail.com>
> > > wrote:
> > >
> > > > I'll check utter access. THanks.
> > > >
> > > > r
> > > >
> > > > On Wed, Jun 21, 2023 at 12:47 PM Ryan W <wrwehler at gmail.com> wrote:
> > > >
> > > > > It was out on utteraccess forums. I’m out of town so I can’t link
> > > > directly
> > > > > to it.
> > > > >
> > > > > Sent from my iPhone
> > > > >
> > > > > > On Jun 21, 2023, at 12:04 PM, Rocky Smolin <
> rockysmolin2 at gmail.com
> > >
> > > > > wrote:
> > > > > >
> > > > > > A while back there was a thread about FInd and Replace products
> to
> > > > > replace
> > > > > > RIck Fisher's.  There was a link to a free product that I think
> had
> > > to
> > > > be
> > > > > > imported into the db but which was very effective.
> > > > > >
> > > > > > I have a one-time need for such a facility. Can someone remind me
> > > what
> > > > > that
> > > > > > product was?
> > > > > >
> > > > > > TIA
> > > > > >
> > > > > > Rocky
> > > > > > --
> > > > > > AccessD mailing list
> > > > > > AccessD at databaseadvisors.com
> > > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > > Website: http://www.databaseadvisors.com
> > > > > --
> > > > > AccessD mailing list
> > > > > AccessD at databaseadvisors.com
> > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > Website: http://www.databaseadvisors.com
> > > > >
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>