Topics Search

Show or hide object tabs

Show or hide object tabs
Views: 421
Microsoft Office Access 2007 provides a new way to work with the tables, forms, reports, and other objects in a database. Instead of opening each object in a separate window, Access now places objects in a single pane and separates them with tabs. Tabs are the default behavior for all databases created with Office Access 2007.
In this article
* Understand tabs
* Why hide tabs?
* Show or hide object tabs without using overlapping windows
* Switch from tabs to overlapping windows
Sponsored Links:

Similar posts...


Show or Hide Tabs in Microsoft Access 2007

Show or Hide Tabs in Microsoft Access 2007 Icon
Access 2007 introduces the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look and feel of your database or more closely simulate the appearance of older versions of Access.

Routine to run/export queries

Routine to run/export queries Icon
Looking for some links to examples that do the following (or something close):

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.).

Hide the Ribbon When Access Starts

Hide the Ribbon When Access Starts Icon
By default, Microsoft Office Access 2007 does not provide a method for hiding the Ribbon. This topic describes how to load a customized ribbon that hides all of the built-in tabs. Learn how to hide the Ribbon when opening a database.

How can i hide tab items again after it loses focus?

How can i hide tab items again after it loses focus? Icon
I have created a form which contains a tabbed control with 3 tabs (Start, User 1 and User 2)

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 the Command Button "Caption" property be changed using VBA

Can the Command Button "Caption" property be changed using VBA Icon
I would like to use one Command Button to either display or hide a list. My thought is to set an Object value to either "0" or "1" and then an If/Then Statement to perform the action. I would also like to change the Button's "Caption" to something like either "Show" or "Hide"depending on the Object value. Otherwise I'll just have two Buttons stacked over each other and display the appropriate one depending on the Visible status of the list.

Form can't see the Tabs

Form can't see the Tabs Icon
I have several databases that I have inserted tabs with sub forms. When I open the form, I can't see the tabs. I have to use the scroll bar to move the window to where I can see the tabs.

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.

Big form with 5 tabbed control 1 tab via 1 table and the other tabs via another table

Big form with 5 tabbed control 1 tab via 1 table and the other tabs via another table Icon
I have a form with a 5 tabs in it via tab control, 4 of the tabs are based on one table and one of the tabs is based on another table. The two tables share a unique key, both named 'ID' that allow me to join the data from both tables successfully.

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.

Fields copying through tabs

Fields copying through tabs Icon
I created a form that has 4 tabs. I have 8 text boxes in the first tab that 7 of which copy over to the other 3 tabs that I can't delete without deleting the original.

Hide/show Ribbon Tabs/Areas

Hide/show Ribbon Tabs/Areas Icon
The user wants all the non-basic functionality of the ribbon hidden. To accomplish that by doing the usual stuff:

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?

Show or hide the status bar

Show or hide the status bar Icon
Learn: 1)Show or hide the status bar for all your Microsoft Access files. 2)Show or hide the status bar for a specific Access file.