Visual BASIC Programming
Summer 2002

Practice questions from old EXAMS and Quzzes, but ignore the stuff we DID NOT COVER this summer.

Your LAST assignment - movies database assignment, is due by August 2nd, last day of class.

Finding the MINIMUM or the MAXIMUM value from a collection of unsorted values.

Handout from Monday, July 29th class with information on databases.

Download the Movies97.mdb database from here to your C: or Z: or A: drive.

Sorting and using arrays. Reading raw text files.

Reading input files and storing values in an array. Determining the average height by obtaining a sum and a count. Wednesday, July 24th, 2002.

Selection sorting the players by height. Using the CurrentX property to determine Print position on the Form object. Thursday, July 25th, 2002.

Reading a file into a ListBox control: ListBox and using its Sorted property to obtain the sorted by height players.

Friday, July 26th two new procedures added to illustrate use of ListBox control, and to help understand the existing code of the Sorted ListBox and reading Text files problem. Email note you received,

Arrays and files assignment, due on MONDAY, not Friday. See page 257, Project 2 from textbook.

Racing Rectangles in Excel using VBA to run the race, determine the winner, and make the winner dance.

Visual Basic (VBA) for Applications and Excel spreadsheets. You can take the PowerPoint published presentation to full screen. Look at the bottom panel notes pages for some slides too. Most of this was handed out on July 22nd, Monday.

Assignment and Friday 07/19/2002 lab review: Base 5 to base 10 conversions assignment and resources and handouts.

Shapes menus assignment, with its two forms (one for Border Width):

Your Shapes menus assignment and menus screen snapshots of the running application.
Learn about CROPPING after using PrintScreen without the Alt key, which captures the entire screen, not just the active window.
More about CROPPING to get the popupmenus, after using PrintScreen, without the Alt key.

Listbox techniques - NEW on Thursday afternoon. This example a further summary of the Wednesday, July 10th class example and the Thursday, July 11th lab followup. It contains lots of hints and techniques for your assignment, especially for the TWO ROW SUMMARY approach for the ListBox of daily sales.

Quiz Friday, Assignment due Friday, July 12th. This email note is a summary of the Wednesday, July 10th class and contains lots of hints and techniques for your assignment.

Fixing Wright Hall windows and Visual Basic by using cowboy.cns.uni.edu remove-profile command.

Drag and Drop concepts from the rock, paper and scissors application. Tuesday, July 9th class handout. vbEnter, vbLeave and vbOver are not covered.

Count Down programs from July 1st and July 2nd classes.

Integer Division, Mod and RGB color extraction from the Long color value. Group exercise from Tuesday, July 2nd. Master the Mod, the \, and the color graphics stored as a Long value concepts. Also study the use of the MouseUp event and its four arguments. Also the first class example of a user defined FUNCTION in Visual Basic.

HANDS-ON CLASS TODAY - New location.
ON THURSDAY JUNE 27th class will be in Wright 112 lab, Wright 112 lab, Wright 112 lab.
Do NOT go to Wright 339 lab today. We are in WRIGHT 112 LAB!

Tuesday 06/25 hands-on class ListBox and Graphics/Colors and Timers example program. You received this as a handout on 06/26/Wednesday.

June 26th email note: Contains extending due date till Friday, quiz on Friday, and Dancing U N I control array example code and Thursday hands-on class preview.

QUIZ ON FRIDAY, June 21st and Friday June 28th.

File Browser for Graphics files and the Pattern property values *.ico;*.bmp;*.gif;*.jpg;*.wmf shown in the Properties window at Design time. Good review of Tuesday, June 18th lab.

Assignment #2 is from pages 98 and 99 of the textbook. Here is Assignment #2, involving finishing up the Shrub and Turf Lawn Care program, as well as the Gas Mileage Testing program.

Assignment #1 is from pages 54 and 55 of the textbook. Here is Assignment #1, involving a Shrub and Turf Lawn Care program, as well as a Gas Mileage Testing program.

Friday, June 14th hands-on class Initial Maker program code and screen snapshots. CONTAINS HELPFUL ALT+PrintScreen information too. Note: The more complete code with the KeyPress events that watch for the vbKeyReturn Enter key to be pressed, and then do SetFocus, will be handed out and discussed on Monday. We have hands-on classes on Tuesday and Thursday for week #2 and week #3.

READING ASSIGNMENT for the first week of class. Besides reading over the handouts and lecture notes, read chapters 1, 2 and 3. We will cover chapter 3 eaarly during week #2.

Email note about class #1 and the Properties, Methods, and Events categories. Do NOT worry about understanding RGB or Rnd*255 yet!

Handout and PowerPoint slides for lectures #1 and #2. You have most of this material as a handout.
This example program will be discussed and demonstrated for at least two lectures. Begin reading chapters 1 and 2 of the textbook.

Design time and VB code from Monday, June 10th - day #1 example.

RUN time example. The FORM_CLICK() event has happened at least 4 times, right?

Visual BASIC Programming Summer 2002

Visual BASIC Programming
Summer 2002