Access Form: Drag and drop items to create order?

Posted on 2014-08-19
Last Modified: 2014-08-20
I have no idea if this is possible, but I figure if anyone knows, it will be someone here.

I have a set of records in my database that need to be in a particular order in a report. There is no alphabetical order or id number that can be used in this case. The order of the records will also change occasionally when other records are added.

Currently, have a form in Datasheet view that I can use to do this, but I am using an added field titled "OrderNumber" to change the order. However, this way is clumsy and confusing.

I would really like the user to use some kind of 'drag and drop' method to set the order of the records, but I have no idea if this is possible.

Is there a way to do this? If not, does anyone have any suggestions? I don't know if this is even possible. I am not sure where to start with this.
Question by:Megin
    LVL 75

    Accepted Solution


    I used Peter's DnD app many times ... nothing short of amazing.  Download the sample db and check it out.

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    BTW ... there is a re-ordering sample in the fully functional demo db.


    Author Closing Comment

    Thank you for the suggestion!

    I checked it out and purchased it. It appears to be something that will solve this problem.

    However, I am not sure how to use it yet.  I am going to try to figure it out, but I will probably be posting a question about the DnD app in the next few days. ;)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now