In step 1 on
page AC 436, copy the Homes9.mdb database located in the Tutorial.09\Cases folder on your local drive to a floppy disk. Keep the original file as a
backup.
In step 2 on
page AC 436, use pages AC 402 - AC 405 as guideline to create the 2 column
list box in this step. Make the list box about 3 inches wide and 1 3/4
inches high on the form. Use the List Box Wizard printing out each step used
in the Wizard. This is the first 5 pages of your assignment. Move the
label above the text box and change its caption to "Select a Lot".
When using the Query Builder as outlined in step 1 at bottom of page 403
make sure SubdivisionID is not shown in the fields in the QBE grid at the
bottom, deselect the Show/Hide check box. See Figure 9-14 on top of page AC
404 as guideline. Blank out the Column Widths property of the List Box. Set
the Bound Column property of the List Box to 2. Print out your Query Builder
screen that looks like Figure 9-14. This is page 6 of your assignment.
Right-click on the Query Builder screen and select SQL view on the short-cut
menu, print out the SQL statements listed on screen. This is page 7 of your
assignment. Use the following steps to print your pages. Press
Alt-Print Screen keys to copy the screen display to the clipboard. Open
Word, click Edit menu, then Paste to get screen capture image
into Word document. Type your first and last name, class and section number,
and date at the top of the page using Word's header feature. Steps: Click
the View menu, clickHeader and Footer drop-down menu, type
your first and last name, press the Tab key on the keyboard, type
class number (IFS 110) and section number or time class meets, press
the Tab key on the keyboard, enter current date by pressing
the Alt + Shift + D key combination on the keyboard. Click the
Close button the the Header and Footer floating toolbar.
Click Print Preview button, then click Print Button to print the page. Do
not save the Word document when prompted to do so.
In step 3 on
page AC 436, if you need to add the Microsoft DAO Object Library see steps
at bottom of page AC 405 and page AC 406. Set the Name property of the
command button as "cmdFind" and the Caption property as "Find
Record" so that the letter F is underlined as the keyboard access key
(Alt-F).
In step 4 on
page AC 436, Set the Name property of the command button as
"cmdCancel" and the Caption property as "Cancel" so that
the letter C is underlined as the keyboard access key (Alt-C). Make each
command button the same size.
In step 5 on
page AC 436, add a comment statement to the code in this step.
In step 6 on
page AC 436, use steps 1-7 on page AC 410 as a guideline.
In step 7 on
page AC 436, print the code for frmFindLots before testing the form using
the steps in step 2 above. This is page 8 of your assignment. When testing
the program open frmLots in form view, double-click the Address field, form
(frmFindLots) should open, print the screen at this point using the Print
Screen key as page 9 of the assignment, double-click on an address, the new
address should now be displayed in form frmLots.
Turn in these 9 pages
together with your disk containing the revised Homes9.mdb file in the
assignment folder with your name.