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