Results 1 to 6 of 6
  1. #1
    darklite is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    41

    adding a sort control button


    I have a form where document links are constantly added. I'd like to be able to sort them automatically using a button. Is there a way to add a control button that will do an a-z sort of a form? I don't know any VB, so I'm limited to the wizard that doesn't offer this. Thanks. Hope I explained it well enough.

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    How are the links displayed on the form?

  3. #3
    darklite is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    41
    They're displayed in a text field. I should correct myself; they're not the actual links, but the names of the links like this: PRICE LIST 2007. Each time a new item is added, employees have a hard time finding it. It would be better in alphabetical order. Thanks.

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Could you possibly store this info in a table and use a subform to display them? The query on your subform could then order by ascending.

    Other than this, I dont know of a way to get textboxes to organize themselves in alpha order on a form. I doubt it's even possible.

  5. #5
    darklite is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    41
    Thanks, I appreciate the help. I didn't build the database, I just inherited it, and eveyrbody's asking for the sort function on it. Thanks for your time spent.

  6. #6
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Just because you inherited it, doesn't mean you cant improve it

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

Similar Threads

  1. Adding Pop-ups via Command Button
    By jlclark4 in forum Forms
    Replies: 1
    Last Post: 01-05-2011, 02:41 PM
  2. Replies: 3
    Last Post: 10-28-2010, 07:02 AM
  3. a-z sort for control button
    By darklite in forum Access
    Replies: 7
    Last Post: 05-28-2010, 04:49 AM
  4. Macro Button to Sort Field A-Z
    By rdirosato in forum Access
    Replies: 1
    Last Post: 03-11-2010, 10:32 PM
  5. Adding Command Button To Form
    By uneek78 in forum Forms
    Replies: 7
    Last Post: 03-27-2009, 07:43 PM

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