Drew Wutka
DWUTKA at Marlow.com
Wed Mar 19 11:32:44 CDT 2008
Yep, sounds like they would work great for that. I am curious if Access has the same menu/popupmenu capability. One of the key processes of the Treeview is HitTest. You give it x,y coordinates (which the treeview mouse events (up, down, move) give you), and it returns the node that is at those coordinates. That's how I customize the menu that appears by right clicking on a node. Very handy. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Wednesday, March 19, 2008 10:39 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Continuous subform on a continuous subform Great treeviews! I have an Open Items List form for each person which can be categorized by Business Process - this would be a good place for a treeview! Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Wednesday, March 19, 2008 9:51 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Continuous subform on a continuous subform True, which is why I've really liked Treeviews. http://www.marlow.com/treeviewform.jpg is a form in one of the systems I have running. It's for Process Administration. You can view the data either by process owners or by processes. More importantly, you can edit the data behind the treeview from the treeview itself. In the picture linked above, I right clicked on 'Senior Leadership Network Permissions', and it gives me a menu 'Remove Senior Leadership Network Permissions From Barry Nickerson'. I don't build enough Access interfaces to know how easy or difficult it is to programmatically create/modify menus. In VB it's pretty simple. If I want to let them add a Process to a Process Owner (or vice versa) in this particular form I open a popup form with a combo box with the available list of Processes or Process Owners (depending on which view the list is in). I can also open a menu with that list as the menu items. Also, Treeviews let you edit their data (labels). I have a similar form with Request Types and Sub types. We can rename them just by editing the labels: http://www.marlow.com/treeviewform2.jpg The check boxes determine if the request type or request subtype is used. Single clicking on the label itself allows you to edit the type or subtypes name. What I like best, however, is that treeviews let you add a little visual representation of your data. http://www.marlow.com/treeviewform3.jpg that's our company phone list. I've clicked on my listing (which has a 'person' icon), and as you can see, the items below it are listed with an appropriate icon. Cell phone, regular phone, camera for the badge photo (clicking that expands the form and displays the photo to the right), envelope for sending an email, etc. I think it's a nicer interface. The previous version of this phone list, I had the data displayed in a Flexgrid. It worked, and displayed the data, but it was no where near as visually pleasing as the treeview version. (Nor as capable....with the items being 'nodes', I can list as many items as I want, without worrying about column widths....) Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, March 18, 2008 7:28 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Continuous subform on a continuous subform Unfortunately, I've never found a way to edit list controls ;-> and multiple columns are problematic. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Tuesday, March 18, 2008 4:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Continuous subform on a continuous subform > The usual way to handle this is to use multiple subforms at the same > level rather than nested. It's often easier to popup a continuous > subform from a button rather than embedding it. If you nest at the > same level, you pass the key value up to a control on the parent form, > and that's the link the other subform uses to filter its records. =======As a personal druther, I actually find it easier to work with list controls than subforms -- can't say why, I just do -- and they look cool too. It isn't an automate populating soluting like subforms, but rather, a drill-down solution. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.