[AccessD] Select Multiple records on form

A.D.TEJPAL adtp at hotmail.com
Wed May 17 23:31:51 CDT 2006


    My sincere thanks Ken!  The feedback provided by you is valuable.

A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Ken Ismert 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, May 18, 2006 00:19
  Subject: Re: [AccessD] Select Multiple records on form

  A.D.:

  >> Sample db ContFormsKeyNavAndHighLightMultiSelect is now available at Rogers Access Library (other developers library). 
    
  I tried it, and it works as advertized. There is about a 1/2 second
  delay on my machine for highlighting. Scrolling drops the highlights,
  but they re-appear after about a half-second (but this is typical
  Conditional Formatting behaviour)

  -Ken


  -----Original Message-----
  From: A.D.TEJPAL [mailto:adtp at hotmail.com] 
  Sent: Tuesday, May 16, 2006 11:03 PM
  To: Access Developers discussion and problem solving
  Cc: ADT
  Subject: Re: [AccessD] Select Multiple records on form

  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