Results 1 to 7 of 7
  1. #1
    intrepid is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    24

    How to add a sort button to column headers?

    How do I add a sort button to column headers? As depicted, I want to have a button next to the column header to sort alphabetically.



    Click image for larger version. 

Name:	Drop down sort ex.png 
Views:	14 
Size:	10.6 KB 
ID:	19828

  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,967
    Is this a form? Is it in Datasheet View?
    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
    intrepid is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    24
    This is a form - "Multiple Items" quick form - in Form View.

    (Thank you for your replies, June).

  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,967
    Yes, but is it Single, Datasheet, or Continuous? Look at Default View property.

    I've never developed code for dynamic sort of records on form. I suppose it could set the OrderBy property.
    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
    intrepid is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    24
    I see, it is a Continuous form.

  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,967
    Okay, then I presume those label headers are in the form header section. Labels have a Click event.
    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
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I threw this together.....

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

Similar Threads

  1. Renaming Column Headers in Pivot Table
    By excellenthelp in forum Access
    Replies: 1
    Last Post: 10-24-2014, 01:50 PM
  2. Exporting to Excel - Column Headers
    By Xarkath in forum Access
    Replies: 2
    Last Post: 01-10-2014, 01:04 PM
  3. column report with headers along the side
    By ssalem in forum Reports
    Replies: 2
    Last Post: 06-20-2013, 02:22 PM
  4. Dynamic Column Headers but NOT CROSSTAB
    By jtkjames in forum Queries
    Replies: 1
    Last Post: 07-26-2010, 05:16 AM
  5. Access Report w/o Column Headers
    By stattech in forum Reports
    Replies: 8
    Last Post: 06-10-2010, 02:07 AM

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