[AccessD] Fisher Find & Replace

Darryl Collins darryl at whittleconsulting.com.au
Wed Jul 30 19:32:22 CDT 2014


This should do nicely for you :)

"Find And Replace can be used to change names of objects through the entire database (as compared to Access itself which provides minimal built-in name change propagation). In addition to facilitating name changes it has other uses, such as: a) changing the path in the connect string for attached tables (search for old path, replace with new; attachment gets refreshed) and b) searching for occurrences of a given function to enable you to change the parameters. The intended user of this module is a programmer."

http://www.rickworld.com/products.html

It is a paid add in, but it is worth every damn cent.  It will generally pay for itself within minutes.  I have used it for many years now and it has saved me many hundreds of hours of tedious hacking and manual updating.

Highly recommended if you do a lot of Access dev, audit or maintenance work.  Probably not worth it if you only tinker with the odd database.

Cheers
Darryl



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan Fitzpatrick
Sent: Thursday, 31 July 2014 10:06 AM
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



More information about the AccessD mailing list