[AccessD] Fisher Find & Replace

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