[AccessD] Drill-Down in Access

If you want to use Access, probably a third party grid is your best bet.
With a lot of effort and some esoteric SQL, you can use the VB
hierarchical flexgrid control, but it won't be directly editable, and
it's hard to control.  You can make Access use a custom control built in
VB.Net, I believe, but I haven't yet tried it.

Charlotte Foust

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Tuesday, June 29, 2004 7:49 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Drill-Down in Access


Is there a way to provide true drill-down in Access? By that I mean
something like shape you get when you create a simple two-table app with
a parent and a child, declare the relationship and then open the parent
table. You get the automatic (and beautiful, I might add) "outline"
presentation -- expand a parent and you can view all its children.

This works beautifully, and gives me almost exactly what I want. I can
add a third table, GrandChild, related to Child, and automatically get a
two-level drilldown.

If I add a second Child table and double-click the parent, Access asks
me which of the two children to add to the display. What I figured out
so far is this:

Select Child1, then AutoForm it. (GrandChild1 is automatically included
in the drill-down view.) AutoForm it and you get a pretty display. Save
the form as Parent1_frm.

Close the form and the table, then repeat, this time selecting Child2.
(Grandchild2 is automatically included.) Autoform it and you get a
pretty display. Save the form as Parent2_frm.

Pretty as it is, the main problem I have with this is that I'm allowing
direct table entry in the child and grandchild, and thus lose all the
cool event handlers. If I substitute a form for the Child table, I
immediately lose the drill-down effect -- which in the current app is
CRITICAL.

Q1: is there another way to get drill-down in Access, while also
retaining the events?
Q2: I note that there are (according to ads, at least) various grids
etc. available for .NET that seem to provide both drill-down and
events/validation. Maybe Access is the wrong FE for this kind of app? 

Note: what I really need to be able to do is prevent updates into a
couple of columns while permitting updates in a couple of other columns.
Binding a table gives me drill-down but no control. Binding a form, I
lose the drill-down.

Any suggestions/solutions?

TIA,
Arthur


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com