Jürgen Welz
jwelz at hotmail.com
Wed Mar 10 09:13:36 CST 2004
I use various techniques depending on the type of list. Most of my lists rarely change but with those that do, I have a single record table with a time field for each combo/list data that has data that should be current. When a container form opens or when a user sorts or filters a list data, it checks the time for a particular table to see if the array is stale. If so, it requiries the data and resets the array. In order for this to work, I code an update of the single record time table when the data is changed. For example, my not in list procedure uses the table name as a parameter and it updates the time flag for that table as well as adding. My edit form for that table updates the time flag table in the after update. When encapuslated as a subform, there is a property procedure that sets and gets the last time source data was queried. It is necessary to work with server time. A system like your dependent control system would be applicable here. Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com >From: "John W. Colby" <jwcolby at colbyconsulting.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: RE: [AccessD] Your favorite control behavior >Date: Wed, 10 Mar 2004 06:37:29 -0500 >MIME-Version: 1.0 >Received: from mc12-f28.hotmail.com ([65.54.167.164]) by >mc12-s8.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Wed, 10 Mar 2004 >03:36:54 -0800 >Received: from databaseadvisors.com ([209.135.140.44]) by >mc12-f28.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Wed, 10 Mar >2004 03:36:53 -0800 >Received: from databaseadvisors.com (databaseadvisors.com >[209.135.140.44])by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id >i2ABaDM24060;Wed, 10 Mar 2004 05:36:13 -0600 >Received: from ColbyConsulting.com (svr5.tokios.com [69.41.224.26])by >databaseadvisors.com (8.11.6/8.11.6) with ESMTP id i2ABZxM23851for ><accessd at databaseadvisors.com>; Wed, 10 Mar 2004 05:36:00 -0600 >Received: from jcolbyws [67.86.213.29] by ColbyConsulting.com with >ESMTP(SMTPD32-7.15) id ADA93F020A; Wed, 10 Mar 2004 05:36:09 -0600 >X-Message-Info: jl7Vrt/mfsqW0/sGQb515Tsu9Rkf1saX >Message-ID: <DCEFJAOENMNENLAAOFGPMECEHCAA.jwcolby at colbyconsulting.com> >X-MSMail-Priority: Normal >X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 >In-Reply-To: <BAY2-F96TpVIMqyNEMd000324d1 at hotmail.com> >X-BeenThere: accessd at databaseadvisors.com >X-Mailman-Version: 2.1.4 >Precedence: list >List-Id: Access Developers discussion and problem >solving<accessd.databaseadvisors.com> >List-Help: <mailto:accessd-request at databaseadvisors.com?subject=help> >List-Post: <mailto:accessd at databaseadvisors.com> >List-Subscribe: ><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=subscribe> >List-Archive: <http://databaseadvisors.com/pipermail/accessd> >List-Unsubscribe: ><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=unsubscribe> >Errors-To: accessd-bounces at databaseadvisors.com >Return-Path: accessd-bounces at databaseadvisors.com >X-OriginalArrivalTime: 10 Mar 2004 11:36:53.0780 (UTC) >FILETIME=[FC673D40:01C40693] > >Jurgen, > >Great ideas. I've been looking at clickable header sort dir methods for >awhile. > >One question, how do you determine that a lists data source has changed? >This one has always bugged me since Access has nothing built in to tell the >developer that the data in a table has changed, and certainly not for data >changes from workstation to workstation. > >John W. Colby >www.ColbyConsulting.com > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jürgen Welz >Sent: Wednesday, March 10, 2004 1:34 AM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Your favorite control behavior > > >Getting back to my favorite control behavior: > >I like list boxes to have a clickable heading that toggles sort direction >over each column in the list. For multi select list boxes, I like to have >label buttons at the bottom for selecting All, None or Inverting the >selection. > >I build these as subforms receiving property settings from the parent form >as to the number of columns, the column widths and the rowsource. These >subform lists resize themselves to the size of the subform allotted them on >the parent form. The clickable sort/select buttons are always labels that >appear depressed on mouse down and raised on mouse up. I also move a small >graphic arrow indicating the sort direction and which column is currently >sorted on top of the label clicked on. Using a label to receive the click >prevents focus from moving from the list or the parent form. I change the >itemdata property of the graphic to indicate the sort direction. The >concept looks a lot like the sorting in Outlook and some versions of >windows >explorer and the users immediately grasp the significance. As I don't like >to requery to fill these lists by direction, I always like to use arrays as >a rowsource and only requery when the list data has changed. (It has >always >been my contention that I'd rather run a line of code than retrieve a bit >over a LAN as the code executes faster than bits can travel). I have been >using disconnected data wherever possible, even in Access 97, and sorting >arrays rather than retrieving recordsets sorted one way and then another >and >this approach has nearly always been applied to my sortable lists. > > > >Ciao >Jürgen Welz >Edmonton, Alberta >jwelz at hotmail.com > >_________________________________________________________________ >MSN Premium includes powerful parental controls and get 2 months FREE* >http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=htt >p://hotmail.com/enca&HL=Market_MSNIS_Taglines > >-- >_______________________________________________ >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 _________________________________________________________________ MSN Premium with Virus Guard and Firewall* from McAfee® Security : 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines