Max Wanadoo
max.wanadoo at gmail.com
Mon Sep 21 17:42:11 CDT 2009
Well, just remember, it is my sandpit.. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 21 September 2009 23:40 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit > And how exactly do you manipulate the background colour, font ,foreground > colour, etc of a tab control? Fluff. IF I wanted to do that I would place a label over the tab I suppose. I have to say in all my years I have never had a client care. Besides which you have shifted your argument from JIT subform to fluff. I caught you you sly dog. John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: > And how exactly do you manipulate the background colour, font ,foreground > colour, etc of a tab control? > > Guess what you can do with a button or even better a label simulating a > button or even better a graphic simulating a button? > > Forget tabs. Trust me! > > Max > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: 21 September 2009 23:24 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit > > >Voila! Max wins again! > > Well, not exactly. Do the exact same thing only have your subforms reside > on the pages of a tab. > Now as the tab click event fires, load the subform for the correct page, > just as you do for your > buttons. the difference is that my code is clean, handling one control (the > tab control). Yours > has to be customized to the number of buttons you have on your form. > > Add a subform, add a button, add a button event handler. > > In my case, add a subform, just add a tab. No code change at all. In fact > this is the one lonely > place where I use the tag property... of the subform control to store the > subform to load in that > subform control. In the subform control I simply remove the name of the > form to load and in the > OnClick of the tab control I yank the name from the subform control tag and > place it back in the > source property to cause the subform to load. > > Works a treat. Add a tab, drag a subform onto the tab. Cut the subform > name out of the source > property and place it in the tag. Instant JIT subform. Not a single button > handler in sight. > > Voila... John wins again. ;) > > John W. Colby > www.ColbyConsulting.com > > > Max Wanadoo wrote: >>> Max, you aren't listening. >> True. >> >> I wasn't talking about loading subforms as part of the tabs, but in having >> controls on the tabs screen space. IOW, one form, no subforms. Main form >> has dozens of tabs each displaying different information from the mainform >> source. >> >> Break all that out into subforms which load JIT based on buttons. Voila! > Max >> wins again! >> >> Max > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com