Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #9053

Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ?

From "Access Developer" <accdevel@gmail.com>
Newsgroups comp.databases.ms-access
Subject Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ?
Date 2014-02-21 19:43 -0600
Message-ID <bmqdmqF8etmU1@mid.individual.net> (permalink)
References <2b78699d-da3e-4ca1-8fff-7371bca040da@googlegroups.com> <kpRNu.77294$tP5.5682@fx08.iad>

Show all headers | View raw


If they provided that functionality in an automatic fashion, then good for 
them. It's similar to what we've implemented with command buttons, combo 
boxes, text boxes, etc..  But, er, if you have 15 x 15 choices, that is too 
complex a form... 'way too complex.  I've worked on many database 
applications in which the plain switchboard was just fine; others where some 
data input was added and useful.

The "Switchboard Manager" however, was overkill -- a complex solution to a 
simple problem, with multiple forms and a table to implement what could/can 
easily be created with a few forms and command buttons, it was not easily 
maintainable (generally not maintainable at all through the 'manager' that 
generated it).

I don't think the "Switchboard Manager" in 'classic Access' is what Albert's 
writing about.

 -- 
 Larry Linson
  Microsoft Office Access MVP
  Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"Albert D. Kallal" <PleaseNOSpamkallal@msn.com> wrote in message 
news:kpRNu.77294$tP5.5682@fx08.iad...
> wrote in message 
> news:2b78699d-da3e-4ca1-8fff-7371bca040da@googlegroups.com...
>
> From forums Pros & Cons reading, I still do not see an emerging 
> preference.
> What is your advice ?
>
> Thank you,
>
> j.P.
>
> -----
>
> For new applications, the switchboard s rather lame and is deprecated.
>
> Really rather poor anyway.
>
> For complex and LARGE applications?
>
> The new navigation form is a complete winner. The result is a web like 
> interface, but one that can REALLY handle complex menus.
>
> You can say have two rows of 15 options across the top, then any click 
> gives a 15 row choice below and ALSO a choice along the left side.
>
> These navigation forms essentially like a tab control with multiple tabs, 
> but the forms are loaded dynamic so there not a speed cost if you have 20 
> or 400 forms in your application.
>
> The other great advantage of this system is you can display  report or 
> forms in that system.
>
> I cannot provide screen shots since I am under contract for this 
> application, but it really amazing.
>
> The switchboard provided a choice to launch a form. The navigation form 
> system allows one to build a application around the system and it totally 
> different idea - but one that works VERY well.
>
> You can see a "tiny" bit of the screen shot in this PDF brochure:
>
> http://www.pdqestimating.ca/wp-content/uploads/2013/07/PDQ-Brochure_WEB.pdf
>
> In the second screen shot if you zoom in you see choices across the top 
> and then drills down along the left side.
>
> This menu system scales VERY well in terms of complex applications - 
> better then any menu system I have used.
>
> best regards,
>
> -- 
> Albert D. Kallal  (Access MVP)
> Edmonton, Alberta Canada
> PleaseNoSpam_kallal@msn.com
>
> the software is NDA, but you can see "a bit" of the screen shot here:
>
>
>
>
> 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? jpr.charron@gmail.com - 2014-02-19 10:01 -0800
  Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? "David Hare-Scott" <secret@nospam.com> - 2014-02-20 07:55 +1100
  Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? PW <emailaddyinsig@ifIremember.com> - 2014-02-20 10:21 -0700
    Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? "Phil" <phil@stantonfamily.co.uk> - 2014-02-20 17:58 +0000
    Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? Ron Weiner <rw@domain.com> - 2014-02-20 13:40 -0500
    Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? "Access Developer" <accdevel@gmail.com> - 2014-02-20 13:15 -0600
      Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? PW <emailaddyinsig@ifIremember.com> - 2014-02-21 14:11 -0700
  Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? "Albert D. Kallal" <PleaseNOSpamkallal@msn.com> - 2014-02-21 16:35 -0700
    Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? "Access Developer" <accdevel@gmail.com> - 2014-02-21 19:43 -0600
      Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? "Phil" <phil@stantonfamily.co.uk> - 2014-02-22 08:55 +0000
      Re: Menu Creation with Access 2010 - Switchboard vs Navigation Form Pros & Cons - What is the best solution ? "Albert D. Kallal" <PleaseNOSpamkallal@msn.com> - 2014-02-22 14:19 -0700

csiph-web