Topics Search

Show or hide object tabs

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

More topics

 

Show or Hide Tabs in Microsoft Access 2007

Preview
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

Preview
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 The Object List in 07

Preview
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 '07.
 

Hide tab macro

Preview
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

Preview
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

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

Option Control to hide/show page tabs

Preview
I am fairly new to access databases and am teaching myself as I go along. However I have now got myself stuck!

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 the tabs hidden when opening a new record and no selection has yet been made.
 

Hide "Home" tab on ribbon bar

Preview
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
 

Hide the Ribbon When Access Starts

Preview
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 to hide the shutter bar for good

Preview
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