-
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,
-
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.
-
Thank you RuralGuy,
BTW, love the gif.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules