[AccessD] Scheduling Application - Changing Sort Order ofIndividual Items

Ahh I knew I had seen a $25 solution from Peter's Software it also 
handles sort reordering
http://www.peterssoftware.com/dd.htm


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