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