jwcolby
jwcolby at colbyconsulting.com
Mon Sep 21 17:26:46 CDT 2009
I will hand you the ugly tab issue. Not enough to make it worth my time though. Besides which I have used icons in tabs. Works a treat. John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: > ..and then you have to jump through loops to see which tab control was > clicked. And you cannot change its colour, etc. you are stuck. Use a button > or a label simulating a tab/button and the world is your oyster (assuming > you like fish - but then we are back to your other problem LOL). > > > Max > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: 21 September 2009 23:09 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit > > > but why make extra work for yourself showing and hiding stuff with > "buttons" on a single parent > form and generally reinventing the wheel? > > Agreed. That is precisely what the tab control is for. Write the code and > place it in a framework > library... ;) > > John W. Colby > www.ColbyConsulting.com > > > Charlotte Foust wrote: >> Max, you obviously haven't followed the JIT loading threads we've had >> over the years. Tabs don't load anything you have instantiated. When I >> built tab forms in Access, they didn't load anything on a page until >> that page got the focus. The overhead of loading all tabs is enormous, >> but why make extra work for yourself showing and hiding stuff with >> "buttons" on a single parent form and generally reinventing the wheel? >> >> Charlotte Foust >> >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo >> Sent: Monday, September 21, 2009 1:03 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit >> >> Ok, it is for ME. >> >> I will never go back to tabs. >> >> Tabs load ALL the data for all the tabs each time you open the form and >> each time you navigate between records. ALL of it ALL the time. >> >> A button merely replaces the sub form with another sub form. >> Practically instantaneous and only loads the data in the sub form that >> you have opened. >> To the user it looks and feels the same but FASTER...a lot FASTER. >> >> One form I had was practically unworkable and now it flys. >> >> >> Max >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte >> Foust >> Sent: 21 September 2009 20:57 >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit >> >>> Best of all, drop the multi-tab subform and replace with buttons. Must >> faster and easier to maintain. >> >> NOT! >> >> Charlotte >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo >> Sent: Monday, September 21, 2009 12:51 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit >> >> If this has just happened on a form which hitherto was working ok, then >> do a rebuild. >> If you have added any code to make changes to the data on the form >> (either directly or via a Query) then put a me.dirty=false to ensure the >> change is written away immediately. >> >> Best of all, drop the multi-tab subform and replace with buttons. Must >> faster and easier to maintain. >> >> Max >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin >> Sent: 21 September 2009 20:03 >> To: 'Access Developers discussion and problem solving' >> Subject: [AccessD] Update or CancelUpdate Without Addnew or Edit >> >> Dear List: >> >> I have a rather complex form with a multi-page tab. Some of the tabs >> have subforms >> >> When I open the form and click in an empty space on the subform I get >> the message "Update or CancelUpdate Without Addnew or Edit". If I go to >> any other tab page with a subform and click anywhere on the subform I >> get the message. One of the tab pages generates the message without >> even clicking. >> >> >> I can click on any tab page which does not have a subform with no >> problem. >> >> I get this problem in 2007 but not 2003. My client has it in 2007 and >> 2003. >> But not on all machines. >> >> I'm stumped. Any ideas welcome. >> >> >> >> MTIA >> >> Rocky >> >> >> -- >> 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 >>