How do I change the navigation pane grouping so tables independent database objects are grouped together?
Ngày đăng:
18/10/2022
Trả lời:
0
Lượt xem:
199
EDIT: Added more code to add other object types to the custom Nav group. Show The following code will assign tables to your custom Navigation Group. WARNING!! There is a 'refresh' issue of table 'MSysNavPaneObjectIDs' that I am still trying to resolve. If you create a new table and then try to add to your group - sometimes it works on the first try, other times it fails but will work after a delay (sometimes up to five or ten minutes!) At this moment, I got around the issue (when it fails) by reading info from table 'MSysObjects', then adding a new record to 'MSysNavPaneObjectIDs'. The code below simply creates five small tables and adds to Nav Group 'Clients' Modify the code to use your Group name / table names.
How do you change the navigation pane grouping in Access?With a custom category and group open in the Navigation Pane, right-click an object that you want to place in a new group. Point to Add to group, and then click New Group. A new group appears in the Navigation Pane. Enter a name for the new group, and then press ENTER.
How do you group the objects in the navigation pane by tables and related views?Answer: To view the tables and related objects in the Navigation Pane, click on the Navigation Pane menu and select "Tables and Related Views" from the popup menu. Now the Navigation Pane should group by table and display each object related to that table.
How do I change the navigation pane?To edit the navigation pane in Windows 11/10, press the Windows key + E hotkey to open Windows Explorer. Click the View tab. Click the Navigation pane button in the ribbon. In the drop-down menu, you can click to check or uncheck the “Navigation pane” option.
|