[AccessD] Select Multiple records on form

A.D.TEJPAL adtp at hotmail.com
Tue May 16 23:03:22 CDT 2006


Mark,

    Sample db ContFormsKeyNavAndHighLightMultiSelect is now available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    It would be helpful if on opening the db, you first go through the tips (click the command button captioned "Show Tips").
 
Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Mark A Matte 
  To: accessd at databaseadvisors.com 
  Sent: Tuesday, May 16, 2006 22:20
  Subject: Re: [AccessD] Select Multiple records on form


  A.D

  Thanks...I must have done something wrong...when I click on a record...it is selected for about 3 seconds and then the formatting "goes away", simply put.  If I use a smaller recordset...I don't see the formatting at all.  I will check out the example.

  Thanks Again,

  Mark A. Matte


  >From: "A.D.TEJPAL" <adtp at hotmail.com>
  >Reply-To: Access Developers discussion and problem 
  >solving<accessd at databaseadvisors.com>
  >To: "Access Developers discussion and problem 
  >solving"<accessd at databaseadvisors.com>
  >CC: ADT <adtp at airtelbroadband.in>
  >Subject: Re: [AccessD] Select Multiple records on form
  >Date: Tue, 16 May 2006 22:12:36 +0530
  >
  >Mark,
  >
  >     So long as the group of records remain in a selected state, and after you have released the mouse button, the code provided by me earlier, ensures continued highlighting of such records in a special color, till the selection gets undone (e.g. user clicking on any control).
  >
  >     For your ready reference, selection of records is done as follows:
  >         (a) Single record - Click on record selector.
  >         (b) Multiple records at a time - Click on record selector of top 
  >desired record and drag the mouse to record selector of bottom desired record. (Alternatively, you can hold down shift key and then click the record selector for bottom desired record, or use Dn Arrow key to expand the selection suitably).
  >         Note - Using Up/Dn arrow keys alone, when a group of records is already in selected state, moves the whole selection mask accordingly.
  >
  >     Apparently, something might be amiss in actual implementation of 
  >suggested solution at your end. It might be helpful to look at the sample db mentioned in my previous post. It is in Access 2000 file format and is working smoothly on Access 2003 installation. On Access 2K, time lag is encountered as stated earlier, but results are consistent.
  >
  >Best wishes,
  >A.D.Tejpal
  >---------------


More information about the AccessD mailing list