Show or hide object tabs
In this article
* Understand tabs
* Why hide tabs?
* Show or hide object tabs without using overlapping windows
* Switch from tabs to overlapping windows
Thank you for taking the time to report an issue.
What's wrong... Please write below.
1. user would create a whole bunch of queries themselves (using Access)
2. form that lets the user runs these queries to display results and/or
3. Would be good if user could select multiple queries and get multiple
resultsets to display or be exported to
an excel file with multiple worksheets. Example: user selects 5 queries and wants an excel file made with 5 tabs with the 5 different outputs of the queries, or the outputs of the 5 queries show in a form with multiple tabs in Access (hide/show tabs, set recordsources at runtime etc.).
I have added a password protect code to the tabs (User 1 and User 2) so that when clicked, the user is prompted for a password.
I have created the user input as a string and have hidden the tab content by using a tag on each item and the visible command. the content remains hidden and returns to the start tab.
If the correct password is entered, the items with the specified tag become visible.
Its only a very basic password protection and isn't protecting vital content but I have a problem I would like to fix.
This is the issue.
If I select the user 1 tab and enter the password correctly, then I click the user 2 tab and enter the password correctly THEN click the User 1 tab again.I am prompted again for thepassword (which is fine), but all the items on the tab are still visible.
I want to be able to re-hide the tab items when it loses focus so if I switch back to the tab, it is clear. I am unsure on how to do this.
The code is entered on the OnChange Property of the tabset.
Another option I was thinking of was to hide the other user tabs when the password is entered correctly on the selected tab. Not sure how to do that either.
Can you also tell me how to add a control key to be able to navigate to a tab without using the mouse? This last one is an extra but I thought it would be cool.
I have been trying everything to attempt to synch the 'ID' on the first table (the 4 tabs of data) with the 'ID' on the second table (the 1 tab of data) together so that the one tab will always and only show data that goes with the primary table (the 4 tabs).
I have tried to use filter on the form and it doesn't work or render an error.
There will always be exactly a 1-to-1 relationship between the two tables.
File >> Options >> Current Database >> Allow Full Menus (unchecked)
Everything worked as expected, but we came across an issue. The user needs to open a report in "print preview" and they need to be able to export their report to excel. The"print preview" ribbon tab is there, but it is not showing the "Data" area, where all the export options are.
How can I do this without a costume ribbon?
Maybe there is a way of manipulating which areas of the ribbon/tabs/areas/controls are enabled from VBA?