Drew Wutka
DWUTKA at Marlow.com
Thu Feb 19 22:28:49 CST 2009
LOL, I hear ya on that, trust me, the envy goes both ways! ;) Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Thursday, February 19, 2009 6:32 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Find First in an Array? Yeah, I think you're absolutely right - opening a recordset of only the controls on a form and looping once forward through the recordset filling the controls will be faster than the other way. However, given how fast it's going now I wonder if I'll be able to see a difference. Right now I've got echo off while translating, resizing and maximizing the form. So there's only one 'painting' of the form. I don't know if that painting, which kind of proceeds from left to right and top to bottom can be replaced with a 'pop'. And again, since I'm independent and my time is really my money, I like to go for the most economical solution and not the most elegant. Shamil asked the right question - how much time do I have for experimenting. Sometimes I envy those in the W-2 world. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Thursday, February 19, 2009 3:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Find First in an Array? Just to clarify Rocky.... While I completely agree that classes and collections provide fast, clear programming, with tons of capabilities, and I use them all the time from their abilities (which sometimes sacrifice a tad of speed for actual performance and ease of use).... your initial issue of using FindFirst will be faster with seek, but Seek is still going to have to do some looking. Reversing your logic, to find and fill the controls based on the record, instead of finding the record based on the control will go faster then either FindFirst or Seek. Because there will be no 'hunting' necessary. The query will bring up all the info for a specific form (so you are dealing with less data, less overhead), and then you just run through the recordset. If you want something that will go even faster.... create a global class, that loads all translations for all controls, and just keep it all in memory. That is going to be more programming though. And I doubt you will see much of a difference in performance doing the 'reverse logic' method over a collection method. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Thursday, February 19, 2009 4:53 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Find First in an Array? Thank YOU! Someone once posted I think it was on this list 'A good program is one that works'. That's my motto, now. No one ever looks under the hood, and I always judge my programs from the outside. Matters not how the data got on the form as long as it happens 1) fast and 2) accurate. Right now, my quest for faster translation is because I see some delay, especially in the Chinese (think it may be due to the Unicode), and I'd like to get rid of the flashing that seems to accompany many Access apps at one point or another. Going to FindFirst to Seek seems fast and easy so the time may be worth the risk for an improvement in user comfort. However, it's a good opportunity to learn and use a class. So I'm going to have to find the time to go back to the beginning to John's classes class and learn it. Seems like a valuable thing to do now that retirement seems to have receded into the distant future. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- 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 The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.