Max Wanadoo
max.wanadoo at gmail.com
Mon Sep 21 17:16:06 CDT 2009
..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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com