Visual BASIC (810:030)
- New on April 20th, 2001 Movie
GUI interface with a MsgBox showing the player's guess was wrong.
Shows the DataSource and DataField property values for Label2.
(The only label that needs to have a meaningful name is lblMovieName,
for the cmdCheckAnswer_Click() event code to refer to).
- New on April 19th, 2001 SQL Query to
put in your Data1 data control at Design time. Very nice
annotated
Alt+PrintScreen snapshot of the Data1 Properties window.
- New on April 19th, 2001 lstCategory_Click VB code is now made
simpler. Use this instead of what is on your handout.
- Compare the lstCategory_Click event code to the SQL laden version!
Named Queries make the code
simpler and we can escape the scary SQL by creating
and naming the 3 queries in Access in the movies.mdb database.
-
Here is a screen snapshot of the
code for Movie Guessing game that is due by Thursday, April 20th
by 10 p.m. You need to get a recent copy of Movies.mdb on your Z: drive
or on your A: diskette to take home. If you attend the Thursday, April
13th lab session class and want to work at home, you will need
to get the latest version of Movies.mdb on a diskette. It has the table
names Stars and Quotes instead of Lead Actor and Lead Actress and Famous Lines.
- Here are the screen snapshots of the Visual Basic
movies database application.
The material below here on flexgrid and on Visual Data Manager is NOT
part of the Movies guessing game assignment.
- Here is the Microsoft FlexGrid
control note. Use it to replace the Microsoft Data Bound Grid
Control, if you are working in Wright Hall. It has equivalent
functionality. This assignment is due on November 3rd.
-
Add-Ins menu, Visual Data Manager command and the
movies.mdb database file.
- The Set Table Joins command button is used from the Query Builder
dialog box. See the image to the right.
The Join Tables dialog box at the top of this page is invoked from the
Query Builder dialog by the Set Table Joins button.
-
Read Hour 15: Visual Basic Database Basics