[AccessD] Find and Replace

[Rocky Smolin]

Did you ever use Rick Fisher's F&R?

Does this one work well for you? Any problems or shortcomings?

Backstory: I have a client with a fairly complex application and db. I
learned early on not to delete anything that seemed to be deletable
because client sometimes changes his mind and wants to restore the deleted
functionality in whole or in part.

So it's time to do a clean up - get rid of queries no longer used, forms no
longer used, fields in tables, etc. Ideal problem for a goof F&R. So I just
want to get the best one. It's probably a one-off use for me. (I also have
to go through all the code and add documentation, but that's another issue).

r

On Fri, Dec 1, 2023 at 7:35 AM Ryan W <wrwehler at gmail.com> wrote:

> https://www.utteraccess.com/topics/1992076
>
> This is the one I use. you have to create an account and log in to
> download. IIRC I used the second posts link to get an accdb file and then
> just copied the form object into the FE I needed it in.
>
>
> On Fri, Dec 1, 2023 at 9:30 AM Gustav Brock via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> > Hi Rocky
> >
> > This is still an option.
> >
> > /gustav
> >
> > -----Oprindelig meddelelse-----
> > Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På
> > vegne af Gustav Brock via AccessD
> > Sendt: 26. april 2021 11:26
> > Til: Access Developers discussion and problem solving <
> > accessd at databaseadvisors.com>
> > Cc: Gustav Brock <gustav at cactus.dk>
> > Emne: Re: [AccessD] Find and Replace
> >
> > Hi Rocky
> >
> > There is Philipp Stiefel's "Find and Replace for MS-Access":
> >
> > https://accessdevtools.com/product/find-and-replace/
> >
> > /gustav
> >
> > -----Oprindelig meddelelse-----
> > Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På
> > vegne af Rocky Smolin
> > Sendt: 26. april 2021 05:05
> > Til: Access Developers discussion and problem solving <
> > accessd at databaseadvisors.com>
> > Emne: [AccessD] Find and Replace
> >
> > One of my (last) clients has a major redesign of a system I wrote for him
> > to run one of his three businesses. It gives me a chance to clean up a
> lot
> > of stuff that's been left over from previous revisions.
> >
> > I used to use Fisher's Find and Replace but apparently he went away
> > leaving me with an orphan app that doesn't work. It was a brilliant piece
> > of work in its day but it's dead now.
> >
> > Is there something similar - not just to find a replace, but to tell me
> if
> > a query or a report, or a module is no longer referenced in the database?
> >
> > MTIA
> >
> > Rocky
> > Beach Access Software
> > --
> > --
> > 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
>