MartyConnelly
martyconnelly at shaw.ca
Thu Jan 19 12:39:34 CST 2006
This Drag and Drop method should get you halfway there http://support.microsoft.com/kb/287642/en-us see also in frmsmp97.mdb Simulating Drag n Drop Form --- Example 2 form ACC97: Microsoft Access 97 Sample Forms Available in Download Center http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f175066%2fen-us%2f Mcgillivray, Don [IT] wrote: >Larry, > >I have something that may get you where you need to go. I'm sure that by the standards of many listers it's a bit kludgey, but it works in the context where I need it. I can send you a small sample DB off list with a couple of tables and a form that demonstrates my solution. > >Don > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek >Sent: Thursday, January 19, 2006 7:50 AM >To: accessd at databaseadvisors.com >Subject: [AccessD] Scheduling Application - Changing Sort Order ofIndividual Items > >Hi: > >I'm in the process of adapting a scheduling program for a manufacturer to Access (they currently do this in Excel). > >Basically, the application will have a list of products on a form, and the user must be able to move the individual products up and down in the sort order via drag and drop or button click. Is this possible in Access? > >ProductName Scheduled Order >Widget 1 1st >Widget 3 2nd >Widget 5 3rd >Widget 8 4th > >For example, I need to be able to quickly move Widget 8 to 2nd, and have Widget 3 and Widget 5 automatically slide down to 3rd and 4th respectively. > >Thanks in advance. > >Larry Mrazek >lmrazek at lcm-res.com >http://www.lcm-res.com/ > > > > -- Marty Connelly Victoria, B.C. Canada