Topics Search

Show or hide object tabs

Show or hide object tabs
Views: 420
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.
 

Hide The Object List in 07

Hide The Object List in 07 Icon
How do I hide the Object List in 07? My user keeps fooling with it and causing general havoc. Consequently, when she opens it, I want the Switchboard to show and not the object list.

This was easy to do in '03 so I suppose Microsoft had to make it unintuitive in
 

Hide tab macro

Hide tab macro Icon
I'm (trying to) create an access database containing a form with multiple tabs. My objective is to make a button with a module that will hide (make not visible or disable) one of the tabs if a combobox has a specific value. Essentially, I want to hide the tab 'qA' if the combobox has a value of 'AA'. The problem appears to be referring to the correct tab within the form. I've been trying to do this for a couple of hours and have been through many error messages
 

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

Option Control to hide/show page tabs

Option Control to hide/show page tabs Icon
I am creating a form where I have an option group with 7 options and a tab control with 7 pages. What I want to happen is when a user selects an option only the corresponding page tab is displayed, all the others are hidden. I would also want all the tabs hidden when opening a new record and no selection has yet been made.
 

Hide "Home" tab on ribbon bar

Hide "Home" tab on ribbon bar Icon
I'm getting ready to deploy my database and I would like to Hide the "Home" tab and replace it with a custom tab with just the bare minimum of options. I have alreadyused the access options to hide the other tabs that re normally visible, but can't find how to hide the "Home" tab
 

How to hide the shutter bar for good

How to hide the shutter bar for good Icon
Im currently using the blow to show hide the shutter bar (object viewer pane on the left). However I've just realised that if the user pushes F11 the sutter opens opens if hidden. How can I ensure that at runtime the shutter bar isn't available, at all, no matter what, zilch access to viewing objects, never ever.

If Me.CmdHidePane.Caption = "Hide Pane" Then
Me.CmdHidePane.Caption = "Show Pane"
DoCmd.SelectObject acForm, , True
RunCommand acCmdWindowHide
Else
Me.CmdHidePane.Caption = "Hide Pane"
DoCmd.SelectObject acForm, , True
 

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.
 

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.
 

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.

[CODE]

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.