Your program will have a 2nd form, with a FlexGrid control for
displaying the movie names from the Stars table.
It will have
a default of showing the movie names sorted into ascending
order by name.
(When this 2nd Form is 1st displayed, it
will show all the movie names (from the Stars table), sorted
alphabetically by film, i.e. by Stars.film field).
The other two menu choices on this form will be
to show the movie names sorted by length of the movie name, and
to show the movie names sorted into descending order sorted by
the movie name (field name is film in both the Stars table and
the Quotes table).
What do these 3 queries look like? Click
here to see.
The movies.mdb database file is located on the P: drive, in the
jacobson folder, in the 030 folder (of the P: drive jacobson
folder). The path is P:\jacobson\030\movies.mdb for the Wright
Hall computer labs.
If you would like to try to ftp the movies.mdb file to your
PC, click here: movies.mdb. The
movies.mdb database is Access 97, not Access 2000! Do NOT convert it,
or Visual Basic will NOT be able to read it (with the VB data control).
See the Thursday, July 26th example
Two Forms application.
When the user wishes to change the Border Width of the Shape1
object, a 2nd dialog box (frmWidth) is shown.
Add the countRecords() Sub and the updateCaption() Sub logic
to your Movies guessing game main form. Form_Initialize() event
procedure will also be needed.
Note: The Monday, July 30th
Northwind.mdb handout and lab exercise have all the techniques for
displaying the message Record 12 of 98 in the
Data1 control for your movies guessing game main form.