AW: [AccessD] Drill-Down in Access

Michael Brosdorf michael.broesdorf at web.de
Tue Jun 29 14:14:10 CDT 2004


Unfortunately, reports in Access do not allow for drill-down.
I use the TList control from Bennet Tec. It is pretty easy to use, easy to
deploy to client machines and it is printable.


Michael

-----Ursprungliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Arthur
Fuller
Gesendet: Dienstag, 29. Juni 2004 17:49
An: 'Access Developers discussion and problem solving'
Betreff: [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




More information about the AccessD mailing list