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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Stephen Glynn

    Tabs and subforms

    Stephen Glynn, Jan 22, 2006, in forum: Microsoft Access Getting Started
    Replies:
    4
    Views:
    159
    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:
    615
    Quentin David Jones
    Feb 9, 2007
  3. brad

    outlook 2010 beta

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

    ACCESS 2010

    anuj, Mar 25, 2010, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    378
    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:
    727
    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,091
    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:
    786
    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,143
    Martin ©¿©¬
    Oct 6, 2013
Loading...