Rocky Smolin
rockysmolin at bchacc.com
Mon Sep 21 18:44:46 CDT 2009
I'm here. I'm auditing the course. Taking notes. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Monday, September 21, 2009 3:09 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit BTW, Have you noticed that yet ONCE AGAIN, Mr Rocky has started an argument and then disappeared? Max Ps. You can play in my sand box if you want to. My ball though! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 21 September 2009 22:58 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit >Voila! Max wins again! Only in Max's own little universe...where no one else wants to play. 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 2:54 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit > 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 21 September 2009 22:45 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit No, Max, you aren't listening. Tabs load only what you tell them to load and when. If you don't tell them to load a subform until a specified event, they don't load a subform. They're very considerate that way. You built your own speed problem by following Microsoft's instructions and putting all the subform objects into the subform controls at design time. That isn't an issue with the tab control, which is merely a container. It's an issue of design of the application you're building, not the tools available to you. Wiser heads have always waited to load the subforms until they're needed. That works just as well with a tab control and saves you a bunch of subform swapping because the overhead is for the initial load. After that, you can leave the darn thing on its tab without incurring additional overhead. However, you do incur additional overhead if you unload and load subforms over and over. 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 2:12 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit > 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 -- 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