Programmatically sort the objects in the Navigation Pane in Access 2010
Posted on 2011-09-20
In Microsoft Access 2010, I would like to be able to programmatically sort the objects in the Navigation Pane, but I have not been able to find the correct syntax to use.
To manually sort, the user needs to right click the Navigation Pane header and select select Sort By, then select the field they want to sort their objects by. But if you want to sort descending, the user needs to right-click again, select Sort By, and then select Descending. I want to create a macro, or use some VBA that I can associate with a button, so I can sort descending by last modified date with one click, rather than two right-clicks and four menu selections. I do this sort all day, always looking for the most recent queries I have been working on.