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