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 >---------------