Charlotte Foust
charlotte.foust at gmail.com
Fri Aug 1 13:00:59 CDT 2014
It won't run on my machine with Office 2013. Doesn't turn up as an add-in and doesn't work. Charlotte On Thu, Jul 31, 2014 at 2:30 PM, Bill Benson <bensonforums at gmail.com> wrote: > At all? > On Jul 31, 2014 12:45 PM, "Charlotte Foust" <charlotte.foust at gmail.com> > wrote: > > > Doesn't work on 2013. > > > > Charlotte > > > > > > On Wed, Jul 30, 2014 at 10:27 PM, Rocky Smolin <rockysmolin at bchacc.com> > > wrote: > > > > > 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 > > > > > -- > > 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 >