[AccessD] Fisher Find & Replace

Kovacs, Bruce bruce.kovacs at urs.com
Thu Jul 31 07:26:20 CDT 2014


I agree this is a great tool; I use it regularly.  I have, however, developed my own report that is more concise that that provided.  It is based on the temporary tables created by the utility.



Bruce Kovacs
Quality Assurance Director

The Steam Generating Team
7207 IBM Drive
Charlotte, NC  28262

Phone: 704-805-2131
Mobile: 704-200-8802
Fax: 704-805-2875
bruce.kovacs at urs.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, July 31, 2014 01:28 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Fisher Find & Replace

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


This e-mail and any attachments contain URS Corporation confidential information that may be proprietary or privileged. If you receive this message in error or are not the intended recipient, you should not retain, distribute, disclose or use any of this information and you should destroy the e-mail and any attachments or copies.



More information about the AccessD mailing list