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


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

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

From "Phil" <phil@stantonfamily.co.uk>
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-22 08:55 +0000
Organization Aioe.org NNTP Server
Message-ID <le9omm$gn6$1@speranza.aioe.org> (permalink)
References <2b78699d-da3e-4ca1-8fff-7371bca040da@googlegroups.com> <kpRNu.77294$tP5.5682@fx08.iad> <bmqdmqF8etmU1@mid.individual.net>

Show all headers | View raw


On 22/02/2014 01:43:58, "Access Developer" wrote:
> 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:
>>
>>
I use a Treeview type navigation form and although on the sample at

http://www.flickr.com/photos/philofwaltonspics/12691803103/

it onle appears 3 levels deep, there is no limit to the number of menus, sub
menus & forms or reports. As you can see, I have expanded some nodes, so I
supose it really looks like a standard windows folder setup

Phil

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

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