[AccessD] Gui for menu

MartyConnelly martyconnelly at shaw.ca
Thu Aug 4 17:29:17 CDT 2005


Well I know how this code from Peter is done. it is a treeview in the 
left pane and multiple subforms on the right
selection triggered by tags on the nodes. I am trying to use this method 
just now for displaying records taxonomy.
It does wonders on certain types of hierarchical data
I poached this method from Rebbeca Riordan. There is a downloadable mdb 
here
Along with the Smart Access article
It might be cheaper to buy Peter's unlimited license than try and 
rewrite Rebbeca's code to fit.
"Be still my beating heart" it does get complex with multiple subforms 
unless writing to a fixed pattern.

http://msdn.microsoft.com/library/en-us/dnsmart04/html/sa04k6.asp?frame=true

In the article she states

 all you need to do to implement an Explorer-style form in Microsoft Access.
The sample application uses simple sub-forms created using the form 
wizard for display of the product and beverage
details, but the detail forms can be arbitrarily complex. You can 
include tabs, nested subforms, whatever is required
for your application.
In fact, you can use this same basic structure as the primary navigation 
mechanism for your application instead of a
Switchboard. Just replace the data hierarchy in the TreeView with the 
hierarchy of functions in your application. You
can even store the functional hierarchy in one or more tables to allow 
the application to be configured at runtime.
Just store the name of the pane as a field, and load it at runtime.
Even though Microsoft Access doesn't support it directly, the 
Explorer-style form architecture is straightforward to
implement using the TreeView Common Control. This architecture displays 
much of the same information as a more
traditional Access form with the sub-form in datasheet view, but it's 
more effective when the user wants or needs to
see a list of the items at all levels of the hierarchy. This isn't 
common during data entry, but it's extremely useful
when browsing and maintaining information.


Charlotte Foust wrote:

>The control panel is made up of applets, so I suspect it would be hard
>to create its equivalent in Access.  If you don't want to go that far,
>you might take a look at the A Better Switchboard product offered from
>Peter's Software:  http://www.peterssoftware.com/abs.htm
>
>Charlotte Foust
>
>
>-----Original Message-----
>From: | Marcel Vreuls [mailto:vrm at tim-cms.com] 
>Sent: Thursday, August 04, 2005 1:36 PM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Gui for menu
>
>
>Hi,
>
>Does anyone use a nice menu solution/activex control they use for
>working with a panel menu within access. I am looking for a solution to
>create a menu with panels like the control panel menu in the XP
>configuration.
>
>Tnx, marcel
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list