Quickly Generate Shape Commands

If you happen to have a copy of Visual Basic 6.0, you can use the Data Environment Designer to visually create SHAPE commands. Using this tool can save you time, especially when you need to create complex shapes containing grandchildren and aggregations. You can also use the hierarchical FlexGrid ActiveX control to quickly display your shaped recordset.

ftNATR

R Ana Trujillo Emparedados y helados

OrderDate Order # Freight

Now it's time for a special project. In Custom Project 16-4 you will create a shaped recordset that contains both children and grandchildren. Next, you will display this recordset on the Access form in the ActiveX TreeView control (see

Creating and Manipulating Databases with ADO

Figure 16-12 for the final output). This project will also introduce you to using aggregate functions within your shaped recordsets.

0 0

Post a comment