Results 1 to 9 of 9
  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419

    Switch board VS navigation forms

    which is more effective and efficient.
    I have used switch board but not navigation.

    I don’t know so I ask. Thx

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    They both have their merits, but I personally dislike the inbuilt navigation forms, especially for beginners, as it hides how it works, and the referencing of the forms in not intuitive.
    They load each form as a tabbed subform on load. This is fine if you know that but leads to issues with referencing other forms if required.

    I think most developers "Roll their own" navigation / menu systems to suit the application they are creating, as it gives them complete control over what is happening.
    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 ↓↓

  3. #3
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    Thank you for the information and advice. 👍

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    +1 for what Minty said. I never liked switchboards, haven't even tried navigation forms. I build my own forms appropriate to each app.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,956
    Another vote for 'roll your own'. I have never used Switchboard wizard nor Navigation form. Had enough interaction with them assisting posters with their issues. There's a reason MS deprecated the Switchboard wizard. Used to be up front on the menu/ribbon, now it's hidden and have to go find and activate it.
    Last edited by June7; 04-01-2019 at 08:44 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,991
    And another vote for create your own.
    The MS switchboard was/is very difficult to manage.
    The built in navigation forms are a nightmare to code if you want to adapt the design in any significant way
    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

  7. #7
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    Thank you all for your advice. Good to know. Now I don’t have to be so tempted to figure out the navigation form.
    👍👍

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,818
    IMHO, drilling down to a form control on a navigation is bad enough. Add a subform or tab control on that form and yeeucch.
    Then there's the fact that a nav form only loads one form at a time. Don't expect to be able to retrieve data from form A when you switch to form B 'cause form A is gone. Probably one of the major issues that June7 might have been alluding to.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  9. #9
    Join Date
    Apr 2017
    Posts
    1,687
    As most of my apps are single-purpouse ones, I don't use neither. Instead I use a multi-page (usually unbound) Main form. On leftmost page is form which works as real app, on other pages are various registry, report, and setup forms.

    The main minus for this setup is, that you can't convert such design as web-based app - at least without designing the web from zero - because converters I'm aware of don't support multi-level subforms.

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

Similar Threads

  1. Navigation Menu Tab Switch
    By byulogia@gmail.com in forum Forms
    Replies: 1
    Last Post: 03-10-2019, 10:47 PM
  2. Replies: 3
    Last Post: 03-23-2016, 12:45 PM
  3. Navigation Buttons for Forms within Forms
    By Bkper087 in forum Access
    Replies: 1
    Last Post: 01-26-2015, 07:41 PM
  4. Switch board only allows 4 items
    By jaymin in forum Forms
    Replies: 1
    Last Post: 06-25-2012, 04:40 AM
  5. Replies: 1
    Last Post: 01-04-2011, 05:04 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