Results 1 to 5 of 5
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Tabbed vs Overlapping views

    I just had to open a copy of the northwind.db to look at something and it came up with the standard tabbed view format.
    the reason I was in northwind was to look at how two queries interacted with each other, and I needed to change it to overlapping view so I could have multiple things open at the same time.

    now for a long time I had just assumed it was a personal preference on how to view things, but this got me thinking and wondering, what is the point of tabbed view?


    I couldn't come up with a single reason it would be preferable to be limited to viewing a single object at a time.

    just curious if i am missing some aspect of the tabbed view that makes things easier, or if it is just because I am still new to access and db that I need the multiple views to see whats going on.

    thanks for any thoughts

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,776
    - you have a form and its underlying table open. You're stepping through code and refreshing the table but when you want to go from one to the other, one of them is always on top. A larger window can completely cover the one you want to see, meaning you have to minimize or move before you can even activate. Easier to switch tabs. Beyond that, I don't see much advantage and prefer the look and capabilities of overlapping.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,409
    From a development perspective, tabbed view is a PITA. From a user perspective, it is similar functionality to a web browser which has a certain familiarity. If the tabs allowed multiple instances of a form, it would be even closer to web browser functionality. Unfortunately they don't. If you need that, you need to use popups....

  4. #4
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,002
    Agree with the above comments, I have customers with legacy databases that are designed around tabbed forms and developing in them is a real PITA.

    I never use them if I'm building from scratch, I control where windows appear and size them so they always are in a sensible position when they are opened.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,972
    Another vote for overlapping windows. The first thing I do when creating a new database is to change to that setting.
    It really should be possible to save that as the default setting. As it is, I often use a template dB with it set.

    The only real benefit I've heard was by Albert Kallal who suggested using tabbed documents with the tabs hidden.
    He then uses back/forward buttons to navigate between forms as in a browser.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Overlapping dates
    By soldat452002 in forum Queries
    Replies: 3
    Last Post: 03-18-2020, 05:13 PM
  2. Replies: 5
    Last Post: 10-11-2015, 01:28 PM
  3. Fields Overlapping
    By roarcrm in forum Forms
    Replies: 2
    Last Post: 04-13-2015, 10:34 AM
  4. Replies: 1
    Last Post: 02-16-2015, 12:10 PM
  5. Overlapping Subreports
    By gopherking in forum Reports
    Replies: 3
    Last Post: 11-09-2011, 07:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums