Charlotte Foust
cfoust at infostatsystems.com
Mon Sep 21 15:56:56 CDT 2009
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