Max Wanadoo
max.wanadoo at gmail.com
Mon Sep 21 16:11:57 CDT 2009
> but why make extra work for yourself 1. You have to do the work anyway for a Tab. So, it is just as easy to do it in a subform. 2. Tabs DO load when the form opens and they run the code on those tabs too including populating the combos, listboxes, etc. Which is why it was making one of my forms run so slow on load and subsequent tabbing between them. 3. I also put a "Blank" Button option (ie, Tab replacement) on the Main Form along with there others; which just loads a blank/empty sub form. This is extremely useful when scrolling through records where you just need to look at the info on the Main Form until you find the records you are searching for and then you can click on whichever button you want to load that info you are interested in. 4. The wheel was reinvented because it was square. This makes it nice and round and it rolls really well, uphill and down. At the risk of repeating myself. My Tab form was unworkable because of the speed issue. Replacing tabs with buttons made it slick, fast and a delight to use. It got a 100% approval rating from the users who could see no difference but suddenly they were no longer waiting 30=60 seconds for movement between records. We clearly have a different mindset on this. I am going with what goes for me and I pass it on for what it is worth. I think Doug Steele adopted this recommendation a few weeks back and I think had similar results. Perhaps you could give us some feedback - Doug? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 21 September 2009 21:57 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit 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