CS102, Fall 2000, Day 13, Thursday, November 30

Tutorial 5, Session 2  Building a form from scratch
Lots of language:  We start by putting in a bound control (see p. 5.19),  consisting of a text box for a Customer Num, and a label for it, and another bound control for Customer Name.  These are attached (''bound") to the fields we already have in our tables.  All the things we'll put on the form will be called "controls", and each will have a set of properties defining it.

• p. 5.19 The picture: I don't get the field list box automatically.  Clicking the Field List button on the Form Design toolbar will bring it up. (This is #2 on p. 5.21)
• p. 5.22-27 Finicky Microsoft tricks for messing with objects.  Pretty similar to other Microsoft stuff.

New thing: Properties of a Label include its Caption (what it "says").  Notice the name of the first label is Label0, and the Caption is Customer No:.
• Removing any section from a form: set its height to zero (throwaway line, bottom of text p. 5.27)
• p. 5.27on -Header and footer These act like those in a document--stay the same whatever the Details in between.
• p.5.29 #5 The label  box is very tiny; it will expand as you type to accomodate the text.
• You are creating an unbound control (see p. 5.19) here--when it displays text it's called a label.
• p. 5.30 #1 The "title label control"  is the box you just typed in; selecting it correctly gives you the gray form with handles, not the white box.
• p. 5.32-3 -Background color: My picture has a white background.  If yours does too, don't worry about it; you can use white for the fill/back color, or use another color.
• PRINT TO HAND IN page 1 only of your form, at the end of section 5.2 (p. 5.34)

• p. 5.35, resizing:  It's the grid part you want to resize (make wider), not the outside frame.
• p. 5.38 Subform:
• If you don't have the Advanced wizard to do the subform, or you're short of time, skip to p. 5.41, go into Design view, do # 5-8 to relabel the tabs.  Then skip to Using a Filter ... p. 5.42.  Save your form before starting the filtering.
• If you make the subform:
• p.5.41, bottom, deleting:  I had a terrible time getting the subform to come up by double clicking.  If you go back to the main menu (Restaurant:Database) and the Forms tab, Customer Information Subform should be there.  You can open it directly, make your change there.
• Using a filter with a form:
• p. 5.44 # 3 and 6; be sure you get the > (greater than sign) in front of the date..
• The usual "Save" and "Open" buttons change when you're doing a filter--they now include a funnel in the picture, and have become "Save as Query" and "Load from Query"
• PRINT TO HAND IN page 1 (there should only be 1) of the results of your query, at the end of section 5.3 (p. 5.47)
  If you made the subform, switch to the order tab (still in the query) and print that result instead.

• PRINT TO HAND IN page 1 only of your form, at the end of section 5.2 (p. 5.34)
• PRINT TO HAND IN page 1 (there should only be 1) of the results of your query, at the end of section 5.3 (p. 5.47)
  If you made the subform, switch to the order tab (still in the query) and print that result instead.