Results 1 to 11 of 11
  1. #1
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145

    I would like to have a drag and drop feature!

    Thsi is what my database looks like and I was wondering if there was a way to have a drag and drop feature that will allow me to drag certain records on the form and drop them above another or take one and move it down. It currently sorts by the Sort column. or If there is a way where I can click a record and move it up above the next record i would just like to be able to sort by the sort value then in the sort value sort all of the other values meaning if i had 10 records with sort value 2 then they will all be in a random order I want to be able to move them up also?


    Click image for larger version. 

Name:	Capture.JPG 
Views:	17 
Size:	246.3 KB 
ID:	16442

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    AFAIK, that is not possible in Access. Record order is determined by sort criteria applied to field(s).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    Well do you think that there is a way that i can have an up down type thing to where if i click the record it will move in front of the one above it?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    No, same reason. Would need a field that holds a value for sorting. Would have to change value all records affected. Accomplishing this programmatically is not easy.

    Why don't you set multi-field sort criteria in the query or form Order By property?
    Last edited by June7; 05-12-2014 at 06:40 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    I think that is what I am going toi have to do, Thank you, What about decimals if I make the field a decimal field and have it to where they can make it 2.1 2.2 2.3 2.4 and so forth?

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Yes, make the field a Number Double type.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    so after I make it a number double you think I can have decimals that will allow for the extra sort values?

  8. #8
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    how do you make it a number double I only get a number type not a double???

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Look at the property settings at bottom of the table designer.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    can you send me a snapshot? Im sorry I just cant find it

  11. #11
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    1. open table in design view

    2. select the field in upper section of designer

    3. look at the section at bottom of designer called Field Properties

    4. set the Field Size property to Double
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Drag and drop images into form
    By togo in forum Access
    Replies: 7
    Last Post: 11-05-2012, 08:51 AM
  2. Drag and Drop into Textbox
    By jagvent in forum Forms
    Replies: 1
    Last Post: 12-20-2010, 09:31 AM
  3. Drag n Drop BETWEEN textbox and web browser
    By kirklandwater123 in forum Programming
    Replies: 4
    Last Post: 10-29-2010, 01:23 AM
  4. Drag and Drop Between Textboxes. Please Help!
    By kcpope in forum Programming
    Replies: 2
    Last Post: 10-19-2010, 05:03 PM
  5. Drag N Drop example between 2 listboxes
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 10:10 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums