[AccessD] Fisher Find & Replace

Bill Benson bensonforums at gmail.com
Thu Jul 31 16:30:38 CDT 2014


At all?
On Jul 31, 2014 12:45 PM, "Charlotte Foust" <charlotte.foust at gmail.com>
wrote:

> Doesn't work on 2013.
>
> Charlotte
>
>
> On Wed, Jul 30, 2014 at 10:27 PM, Rocky Smolin <rockysmolin at bchacc.com>
> wrote:
>
> > The best danged utility ever given to an Access developer:
> > http://www.rickworld.com/products.html
> >
> > R
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan
> > Fitzpatrick
> > Sent: Wednesday, July 30, 2014 5:06 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Fisher Find & Replace
> >
> > Out of curiosity, what is Find and Replace?  I assume a utility program
> of
> > some kind?
> >
> > Cheers
> > */Bryan Fitzpatrick
> > Mobile: 0418 618 469/*
> > On 31/07/2014 9:36 AM, Darryl Collins wrote:
> > > Hi David,
> > >
> > > I have Find and replace - never used it update headers or colours
> though.
> > Not sure it can do that as it is mostly geared to updating names and/or
> > properties rather than colours - although you could always send Rick an
> > email and ask.  The few times I have needed to contact him he has always
> > gotten back promptly with an answer.
> > >
> > > Cheers
> > > Darryl.
> > >
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com
> > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David
> > > Emerson
> > > Sent: Thursday, 31 July 2014 9:09 AM
> > > To: 'Access Developers discussion and problem solving'
> > > Subject: Re: [AccessD] Fisher Find & Replace
> > >
> > > Thanks for the quick response.
> > >
> > > The changes are only to form header and detail colors.  I suppose I
> could
> > write code to do this but I hoped it would already be within Rick's tool.
> > >
> > > Otherwise it may be quicker just to make the changes manually to each
> > form
> > (about 100).
> > >
> > > Regards
> > >
> > > David
> > >
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com
> > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
> > > Sent: Thursday, 31 July 2014 10:57 a.m.
> > > To: Access Developers discussion and problem solving
> > > Subject: Re: [AccessD] Fisher Find & Replace
> > >
> > > Hi David. I don't know about that program's capabilities but would you
> > not
> > be able to do this somewhat simply with VBA?..
> > >
> > > With a form open, identify all controls in that Section, check that
> > > TypeName = "Textbox", and set the background color and / or however
> > > that theme manifests, to whatever value(s) look right in a control you
> > > have manually set. The parent hierarchy is
> > >
> > > Docmd.open acform, theformname, acDesigh (I think.... can't test from
> > > where I am now)
> > >
> > > This is air code and I might not have the correct index for header
> > section.
> > >
> > > For each ctrl in Screen.ActiveForm.sections (0).controls
> > >       With curl
> > > ...
> > >
> > >        End with
> > > Next
> > >
> > >
> > > At least this is how I would go about trying to do it anyway. Shame
> there
> > is no Macro recorder in Access!
> > > On Jul 30, 2014 6:42 PM, "David Emerson" <newsgrps at dalyn.co.nz> wrote:
> > >
> > >> Hi Listers,
> > >>
> > >>
> > >>
> > >> I Have Rick's Find and Replace version 9.00k.  I need to change the
> > >> form section (header and detail) background colors for all the forms
> > >> in my Access 2010 database.
> > >>
> > >>
> > >>
> > >> I have tried playing with the Search User Specified Properties
> > >> section but am not coming up with any matches (let alone being able
> > >> to change
> > > them).
> > >>
> > >>
> > >> The objective is to eventually replace several control fields with
> > >> Theme colours.
> > >>
> > >>
> > >>
> > >> Does anyone have any pointers?
> > >>
> > >>
> > >>
> > >> Regards
> > >>
> > >> David Emerson
> > >> Dalyn Software Ltd
> > >> Wellington, New Zealand
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> --
> > >> AccessD mailing list
> > >> AccessD at databaseadvisors.com
> > >> http://databaseadvisors.com/mailman/listinfo/accessd
> > >> Website: http://www.databaseadvisors.com
> > >>
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> >
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2014.0.4716 / Virus Database: 3986/7951 - Release Date: 07/30/14
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list