[AccessD] Select Multiple records on form

Ken Ismert KIsmert at TexasSystems.com
Wed May 17 13:49:13 CDT 2006


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