[AccessD] Scheduling Application - Changing Sort Order ofIndividual Items

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/

 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com