Results 1 to 3 of 3
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    Is it possible...?

    Hi All,



    I had an idea for the new database I'm working on; and I'm wondering if its possible to add a macro to a table (or maybe the DB in general) that will automatically alphabetize the table (on one field) after the user has finished entering the data.

    So, I'm asking:

    1. Is it possible? And if so;

    2. What code would I need to make it happen? And,

    3. How would I enter that in the Macro field?

    Many thanks,

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It is not necessary nor would it work. Simply create a Select query of the table and choose the sorting order. Then only use the query from then on. The underlying data engine treats all tables as a bucket of records and unless specified with an Order Clause will return the records as rapidly as possible in whatever fashion it chooses.

  3. #3
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114
    Thank you RuralGuy,

    BTW, love the gif.

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

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