Access 2010 - and Tabs

Discussion in 'Microsoft Access Getting Started' started by Commish, Aug 10, 2011.

  1. Commish

    Commish Guest

    I like having my tables, queries, forms, etc opening in the tabbed
    view.

    For my job, I am frequently using many databases, and having to set
    the default to show tabs is a pain.

    Is there a way to jailbreak Access to let me set tabs as the default?
     
    Commish, Aug 10, 2011
    #1
    1. Advertisements

  2. I'm confused. The default IS tabs: most people are looking for how to make
    the default the older Overlapping Windows approach.


    Doug Steele, Microsoft Access MVP
    http://www.AccessMVP.com/djsteele
    Co-author: "Access Solutions", published by Wiley
    (no e-mails, please!)


    "Commish" wrote in message
    news:...

    I like having my tables, queries, forms, etc opening in the tabbed
    view.

    For my job, I am frequently using many databases, and having to set
    the default to show tabs is a pain.

    Is there a way to jailbreak Access to let me set tabs as the default?
     
    Douglas J. Steele, Aug 11, 2011
    #2
    1. Advertisements

  3. Commish

    Commish Guest

    On Aug 10, 7:23 pm, "Douglas J. Steele"
    <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
    > I'm confused. The default IS tabs: most people are looking for how to make
    > the default the older Overlapping Windows approach.
    >
    > Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/djsteele
    > Co-author: "Access Solutions", published by Wiley
    > (no e-mails, please!)
    >
    > "Commish"  wrote in message
    >
    > news:...
    >
    > I like having my tables, queries, forms, etc opening in the tabbed
    > view.
    >
    > For my job, I am frequently using many databases, and having to set
    > the default to show tabs is a pain.
    >
    > Is there a way to jailbreak Access to let me set tabs as the default?


    Well, that's not the case in my situation. I have Access on 3
    computers - all of them have the radio button for "Overlapping
    Windows" selected when I open any file. I need to select the "Tabbed
    Documents" radio button and then close and re-open the file to use
    tabs. I am accessing these options from the "Access Options" and the
    "Current Database" windows.

    Is it possible that because I am frequently working with older
    documents that they bering their own set of defaults?
     
    Commish, Aug 29, 2011
    #3
  4. Are these MDB files that you're opening in Access 2010?

    "Commish" wrote in message
    news:...

    On Aug 10, 7:23 pm, "Douglas J. Steele"
    <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
    > I'm confused. The default IS tabs: most people are looking for how to make
    > the default the older Overlapping Windows approach.
    >
    > Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/djsteele
    > Co-author: "Access Solutions", published by Wiley
    > (no e-mails, please!)
    >
    > "Commish" wrote in message
    >
    > news:...
    >
    > I like having my tables, queries, forms, etc opening in the tabbed
    > view.
    >
    > For my job, I am frequently using many databases, and having to set
    > the default to show tabs is a pain.
    >
    > Is there a way to jailbreak Access to let me set tabs as the default?


    Well, that's not the case in my situation. I have Access on 3
    computers - all of them have the radio button for "Overlapping
    Windows" selected when I open any file. I need to select the "Tabbed
    Documents" radio button and then close and re-open the file to use
    tabs. I am accessing these options from the "Access Options" and the
    "Current Database" windows.

    Is it possible that because I am frequently working with older
    documents that they bering their own set of defaults?
     
    Douglas J Steele, Aug 30, 2011
    #4
  5. Commish

    Commish Guest

    On Aug 29, 7:43 pm, "Douglas J Steele"
    <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
    > Are these MDB files that you're opening in Access 2010?
    >
    > "Commish"  wrote in message
    >
    > news:...
    >
    > On Aug 10, 7:23 pm, "Douglas J. Steele"
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
    > > I'm confused. The default IS tabs: most people are looking for how to make
    > > the default the older Overlapping Windows approach.

    >
    > > Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/djsteele
    > > Co-author: "Access Solutions", published by Wiley
    > > (no e-mails, please!)

    >
    > > "Commish"  wrote in message

    >
    > >news:...

    >
    > > I like having my tables, queries, forms, etc opening in the tabbed
    > > view.

    >
    > > For my job, I am frequently using many databases, and having to set
    > > the default to show tabs is a pain.

    >
    > > Is there a way to jailbreak Access to let me set tabs as the default?

    >
    > Well, that's not the case in my situation. I have Access on 3
    > computers - all of them have the radio button for "Overlapping
    > Windows" selected when I open any file. I need to select the "Tabbed
    > Documents" radio button and then close and re-open the file to use
    > tabs. I am accessing these options from the  "Access Options" and the
    > "Current Database" windows.
    >
    > Is it possible that because I am frequently working with older
    > documents that they bering their own set of defaults?


    As a matter of fact, they are MDB files from the previous versions of
    Access.
     
    Commish, Aug 30, 2011
    #5
  6. "Default" only applies when you're creating the databases. Once they've been
    created, the interface is set. Since you created them in a previous version
    of Access that did not have the Tab view option, you're getting the non-tab
    interface. Afraid there's no option but to set it back yourself.

    "Commish" wrote in message
    news:...

    On Aug 29, 7:43 pm, "Douglas J Steele"
    <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
    > Are these MDB files that you're opening in Access 2010?
    >
    > "Commish" wrote in message
    > > "Commish" wrote in message

    >
    > >news:...

    >
    > > I like having my tables, queries, forms, etc opening in the tabbed
    > > view.

    >
    > > For my job, I am frequently using many databases, and having to set
    > > the default to show tabs is a pain.

    >
    > > Is there a way to jailbreak Access to let me set tabs as the default?


    As a matter of fact, they are MDB files from the previous versions of
    Access.
     
    Douglas J Steele, Sep 3, 2011
    #6
  7. Commish

    cyberman1

    Joined:
    Jun 21, 2012
    Likes Received:
    0
    Location:
    Effingham, NH in the USA
    In Access 2010 - the command is:

    CurrentDb.Properties("ShowDocumentTabs").Value = False to hide (true to show).

    It doesn't take effect until one closes and then reopens the file.
     
    cyberman1, Jun 21, 2012
    #7
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Stephen Glynn

    Tabs and subforms

    Stephen Glynn, Jan 22, 2006, in forum: Microsoft Access Getting Started
    Replies:
    4
    Views:
    227
    Stephen Glynn
    Jan 22, 2006
  2. Quentin David Jones

    Access window tabs on taskbar?

    Quentin David Jones, Feb 9, 2007, in forum: Microsoft Access Getting Started
    Replies:
    2
    Views:
    700
    Quentin David Jones
    Feb 9, 2007
  3. brad

    outlook 2010 beta

    brad, Feb 9, 2010, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    359
    John W. Vinson
    Feb 9, 2010
  4. anuj

    ACCESS 2010

    anuj, Mar 25, 2010, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    494
    Tom Lake
    Mar 25, 2010
  5. wilmer salazar de venezuela

    I NEED TO DESCARGAR THE PRODUCT KEY FOR MY MICROSOFT OFFICCE 2010

    wilmer salazar de venezuela, May 7, 2010, in forum: Microsoft Access Getting Started
    Replies:
    0
    Views:
    798
    wilmer salazar de venezuela
    May 7, 2010
  6. LAS

    Re: Access 2010 appcrash

    LAS, Mar 6, 2012, in forum: Microsoft Access Getting Started
    Replies:
    4
    Views:
    2,356
    John W. Vinson
    Mar 7, 2012
  7. troy23

    $19 - Microsoft Access-2010

    troy23, Oct 30, 2012, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    908
    Access Developer
    Oct 31, 2012
  8. Martin ©¿©¬

    How to Change a single Cell's Format in Access 2010

    Martin ©¿©¬, Oct 6, 2013, in forum: Microsoft Access Getting Started
    Replies:
    0
    Views:
    1,272
    Martin ©¿©¬
    Oct 6, 2013
Loading...