[AccessD] Fisher Find & Replace

David Emerson newsgrps at dalyn.co.nz
Wed Jul 30 18:09:12 CDT 2014


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



More information about the AccessD mailing list