[AccessD] Continuous subform on a continuous subform

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.





More information about the AccessD mailing list