Programming With Microsoft Visual Basic 6.0

by Zak, Diane

• ISBN13: 9780760010716
• ISBN10: 0760010714
• Format: Paperback
• Copyright: 1998-12-01
• Publisher: Course Technology Ptr

Table of Contents

Preface	iii
Read This Before you Begin	xv
An Overview of Visual Basic	1	(1)
A History and a Demonstration	1	(14)
A Brief Description of Visual Basic	1	(1)
A Brief History of Programming Languages	2	(3)
Machine Languages	2	(1)
Assembly Languages	2	(1)
High-Level Languages	3	(1)
Procedure-Oriented High-Level Languages	3	(1)
The Introduction of Windows	4	(1)
Object-Oriented/Event-Driven High-Level Languages	5	(1)
OOP Terminology	5	(2)
A Visual Basic Demonstration	7	(3)
Using the Tutorials Effectively	10	(1)
Questions	11	(4)
tutorial 1 AN INTRODUCTION TO VISUAL BASIC	15	(74)
Creating a Copyright Screen	15	(2)
Previewing the Copyright Screen	16	(1)
Lesson A: Creating a New Project	17	(22)
Starting Visual Basic	17	(2)
The Visual Basic Startup Screen	19	(9)
The Main Window	19	(1)
The Form Window	19	(1)
The Toolbox Window	20	(1)
The Project Explorer Window	21	(2)
The Properties Window	23	(2)
Setting the Caption Property	25	(1)
Setting an Object's Name Property	26	(2)
Setting the BackColor Property	28	(1)
Setting the Project's Name Property	28	(1)
Saving a Visual Basic Project	29	(1)
Starting and Ending a Visual Basic Project	30	(1)
Opening a New Project	31	(1)
Opening an Existing Project	31	(1)
Exiting Visual Basic	32	(1)
Summary	32	(2)
Questions	34	(3)
Exercises	37	(2)
Lesson B: Working with Controls	39	(18)
Getting Help in Visual Basic	39	(4)
Using the F1 Key	42	(1)
Adding a Control to a Form	43	(1)
Sizing, Moving, and Deleting a Control	44	(1)
Adding Label Controls to the Copyright Screen	44	(1)
Setting the Properties of a Label Control	45	(1)
Setting the Left and Top Properties	46	(1)
Changing the Property for More than One Control at a Time	47	(1)
Saving Files Under a Different Name	48	(2)
Summary	50	(1)
Questions	51	(1)
Exercises	52	(5)
Lesson C: Writing Code	57	(32)
Adding an Image Control to the Form	57	(2)
Adding a Command Button to the Form	59	(1)
Writing Visual Basic Code	60	(4)
Setting the BorderStyle Property	64	(1)
Adding a Frame Control to a Form	65	(3)
Hiding and Displaying Controls	68	(4)
The Options Dialog Box	72	(1)
Adding a Scroller Control to the Form	73	(3)
Changing the Code Window Display	76	(1)
Printing a Visual Basic Application	77	(1)
Making an Executable (.exe) File	78	(2)
Summary	80	(1)
Questions	81	(2)
Exercises	83	(4)
Debugging	87	(2)
tutorial 2 DESIGNING APPLICATIONS	89	(72)
Creating an Order Screen	89	(7)
Solving the Problem Using a Procedure-Oriented Approach	90	(3)
Solving the Problem Using an Object-Oriented/Event-Driven (OOED) Approach	93	(3)
Lesson A: Planning an OOED Application in Visual Basic	96	(13)
Creating an OOED Application	96	(1)
Planning an OOED Application	97	(7)
Identifing the Application's Tasks	97	(2)
Identifing the Objects	99	(1)
Identifing the Events	100	(2)
Drawing a Sketch of the User Interface	102	(2)
Summary	104	(1)
Questions	105	(2)
Exercises	107	(2)
Lesson B: Building the User Interface	109	(20)
Preparing to Create the User Interface	109	(6)
Including Graphics in the User Interface	111	(1)
Including Different Fonts in the User Interface	111	(1)
Including Color in the User Interface	112	(1)
The BackStyle Property	113	(1)
The BorderStyle and Appearance Properties	114	(1)
Setting the Text Property	115	(1)
Adding a Text Box Control to the Form	115	(3)
Controlling the Focus with the TabIndex Property	118	(1)
Locking the Controls on a Form	119	(1)
Assigning Access Keys	120	(4)
Summary	124	(1)
Questions	125	(2)
Exercises	127	(2)
Lesson C: Coding, Testing, Debugging, and Documenting the Application	129	(32)
Coding the Application	129	(2)
Coding the Print Order Button	131	(4)
Assigning a Value to a Property During Run Time	131	(2)
Using the PrintForm Method	133	(1)
Using the SetFocus Method	134	(1)
Internally Documenting the Program Code	134	(1)
Coding the Clear Screen Button	135	(3)
Writing Visual Basic Equations	138	(1)
Coding the Calculate Order Button	139	(4)
The Val Function	143	(1)
Using the Format Function	144	(2)
The MinButton, MaxButton, ControlBox, and BorderStyle Properties	146	(2)
Testing and Debugging the Application	148	(1)
Assembling the Documentation	149	(1)
Summary	149	(1)
Questions	150	(1)
Exercises	151	(8)
Debugging	159	(2)
tutorial 3 USING VARIABLES AND CONSTANTS	161	(76)
Revising the Skate-Away Sales Application	161	(3)
Previewing the Completed Application	162	(2)
Lesson A: Creating Variables and Constants	164	(26)
Using Variables to Store Information	164	(4)
Data Types	164	(3)
Naming Variables	167	(1)
Declaring a Variable	168	(1)
Storing Data in a Variable	169	(1)
The Scope of a Variable	170	(1)
The Option Explicit Statement	171	(2)
Creating a Local Variable	173	(3)
Creating a Form-Level Variable	176	(3)
Creating a Global Variable	179	(3)
Adding a Code Module to a Project	180	(2)
Removing and Adding a File	182	(1)
Symbolic Constants	183	(3)
Summary	186	(1)
Questions	186	(2)
Exercises	188	(2)
Lesson B: Modifying the Skate-Away Sales Application	190	(24)
Storing Information Using Local and Form-Level Variables	190	(2)
Modifying the Calculate Order Button's Code	192	(6)
Concatenating Strings	198	(3)
The InputBox Function	201	(3)
The Newline Character	204	(1)
The Object Browser	204	(3)
Making a Command Button the Default Button	207	(1)
Summary	208	(1)
Questions	208	(2)
Exercises	210	(4)
Lesson C: Improving the Appearance of the Skate-Away Sales Application	214	(23)
Using a Dialog Box	214	(1)
Adding an Existing Form to the Application	215	(1)
Specifying the Startup Form	215	(1)
Loading and Displaying a Form	216	(2)
Adding a Code Module to a Project	218	(3)
Making a Form Resemble a Standard Windows Dialog Box	219	(2)
Adding the Copyright Form to the Project	221	(4)
Using a Timer Control	223	(1)
Removing a Coded Control from the Form	223	(1)
Changing the Appearance of the Mouse Pointer	224	(1)
Summary	225	(1)
Questions	226	(2)
Exercises	228	(6)
Debugging	234	(3)
tutorial 4 THE SELECTION STRUCTURE	237	(100)
Creating a Math Application	237	(4)
Previewing the Completed Application	238	(3)
Lesson A: The If... Then... Else and Select Case Statements	241	(39)
The Selection Structure	241	(1)
Writing Pseudocode for the Selection Structure	242	(1)
Using a Flowchart	243	(2)
Coding the Selection Structure in Visual Basic	245	(2)
Relational Operators	245	(2)
Example 1	247	(1)
Example 2	248	(2)
Logical Operators	250	(3)
Examples of the And and the Or Operators	252	(1)
Example 3	253	(2)
Example 4	255	(1)
The UCase Function	256	(1)
Nested Selection Structures	257	(2)
Example 5	259	(2)
The Case Form of the Selection Structure	261	(1)
The Select Case Statement	262	(3)
Example 1	265	(1)
Using To and Is in an Expressionlist	266	(4)
Example 2	266	(3)
Example 3	269	(1)
Summary	270	(1)
Questions	271	(4)
Exercises	275	(5)
Lesson B: More Visual Basic Controls	280	(27)
The Math Application	280	(2)
Using Visual Basic's Icons	282	(1)
Adding an Option Button Control to the Form	282	(5)
Grouping Option Button Controls	283	(4)
Adding a Check Box Control to the Form	287	(2)
Drawing a Control in a Frame	289	(3)
Locking the Controls and Setting the TabIndex Property	290	(2)
Coding the Level 1 and Level 2 Option Buttons	292	(2)
Creating a User-Defined Sub Procedure	294	(2)
The Call Statement	296	(2)
Coding the Addition and Subtraction Option Buttons	298	(1)
Creating a Default Option Button	299	(3)
Modifying the RandomNumbers User-Defined Sub Procedure	300	(2)
Summary	302	(1)
Questions	303	(2)
Exercises	305	(2)
Lesson C: Completing the Math Application	307	(30)
Static Variables	307	(1)
Coding the Verify Answer Button	308	(13)
The LoadPicture Function	312	(1)
The MsgBox Function	313	(6)
The SelStart and SelLength Properties	319	(1)
The Len Function	320	(1)
The GotFocus Event	321	(1)
Coding the Display Summary Information Check Box	321	(2)
Summary	323	(1)
Questions	324	(1)
Exercises	325	(9)
Debugging	334	(3)
tutorial 5 THE REPETITION STRUCTURE	337	(76)
Creating a Grade Calculation Application	337	(2)
Previewing the Completed Application	338	(1)
Lesson A: The Repetition Structure (Looping)	339	(32)
The Repetition Structure	339	(1)
The For Next (Automatic Counter) Loop	340	(4)
Example 1	342	(1)
Example 2	343	(1)
The Do While and the Do Until Loops	344	(10)
Flowchart and Pseudocode for the Do While and the Do Until Loops	346	(2)
Do While Example	348	(1)
Do Until Example	349	(3)
Another Example of the Do While Loop	352	(2)
Counters and Accumulators	354	(8)
Summary	362	(1)
Questions	363	(3)
Exercises	366	(5)
Lesson B: Using Control Arrays	371	(20)
The Grade Application	371	(3)
Creating a Control Array While Adding Controls to the Form	374	(3)
Making Existing Controls into a Control Array	377	(2)
The Enabled Property	379	(1)
Viewing the Code Window for a Control Array	380	(2)
Coding the Check Box Array	382	(2)
Coding a Control's Array's GotFocus Event	384	(1)
Summary	385	(1)
Questions	386	(2)
Exercises	388	(3)
Lesson C: Completing the Grade Application	391	(22)
Coding the Display Grade Command Button	391	(4)
The Change Event	395	(4)
Centering the Contents of a Label Control	399	(1)
Using the MsgBox Function to Communicate with the User	399	(2)
The Unload Event	401	(3)
Summary	404	(1)
Questions	404	(1)
Exercises	405	(5)
Debugging	410	(3)
tutorial 6 SEQUENTIAL ACCESS FILES, MENUS, AND REPORTS	413	(104)
The PAO Application	413	(4)
Previewing the Completed Applications	414	(3)
Lesson A: Sequential Access Data Files and Reports	417	(49)
Creating the PAO Application	417	(1)
Creating a List Box	418	(5)
The AddItem Method	420	(2)
The Sorted Property	422	(1)
The ListIndex Property	422	(1)
Data Files	423	(2)
Sequential Access Data Files	425	(1)
Coding the Enter Information Command Button	426	(1)
Opening a Data File	426	(3)
Writing to a Sequential Access File	429	(1)
Closing a Sequential Access File	430	(1)
Coding the Display Totals Button	431	(4)
The EOF Function	434	(1)
Reading a Record from a Sequential Access File	435	(1)
Updating the Appropriate Label Control	435	(3)
The Print Method	438	(11)
Changing the Type and Size of the Printer Font	441	(4)
Justifying and Aligning the Numbers in a Column	445	(4)
Completing the PAO Application	449	(3)
Modifying the Print Report Button's Click Event Procedure	450	(2)
Summary	452	(1)
Questions	453	(4)
Exercises	457	(9)
Lesson B: Menus	466	(25)
Creating the Text Editor	466	(1)
The MultiLine Property and the ScrollBars Property	467	(1)
Sizing a Control Along With the Form	467	(1)
Adding a Menu Control to the Form	468	(6)
Creating a Separator Bar	473	(1)
Creating the Edit Menu	474	(2)
Coding Menu Items	476	(1)
The Clipboard Object	477	(1)
The SetText, GetText(), and Clear Methods	477	(1)
The SelText Property	478	(1)
Coding the Edit Menu	478	(2)
Coding the Edit Menu's Copy Command	480	(1)
Coding the Edit Menu's Cut Command	481	(1)
Coding the Edit Menu's Paste Command	481	(1)
Summary	482	(2)
Questions	484	(3)
Exercises	487	(4)
Lesson C: String Manipulation	491	(26)
Visual Basic's String Manipulation Functions	491	(1)
The Left and Right Functions	491	(3)
The Mid Function	494	(2)
The Instr Function	496	(1)
Coding the Edit Menu's Find Command	497	(4)
Coding the Edit Menu's Find Next Command	501	(4)
Summary	505	(1)
Questions	505	(2)
Exercises	507	(7)
Debugging	514	(3)
tutorial 7 DIALOG BOXES AND ERROR TRAPPING	517	(60)
Completing the Text Editor Application	517	(3)
Previewing the Completed Application	518	(2)
Lesson A: Dialog Boxes	520	(19)
The Common Dialog Control	520	(2)
Displaying an Open Dialog Box	522	(4)
The Filter Property	524	(2)
The Filename Property	526	(1)
Displaying a Save As Dialog Box	526	(2)
Displaying a Print Dialog Box	528	(1)
The Flags Property	529	(2)
Displaying a Font Dialog Box	531	(2)
Displaying a Color Dialog Box	533	(2)
Summary	535	(1)
Questions	536	(1)
Exercises	537	(2)
Lesson B: Coding the Text Editor's File Menu	539	(18)
Opening the Text Editor Application	539	(1)
Coding the Text Editor Application	540	(1)
Coding the File Menu's Save As Command	541	(4)
The Print # Statement	543	(2)
Setting the CancelError Property	545	(3)
The On Error Statement and the Error-Handling Routine	546	(2)
Coding the File Menu's New Command	548	(4)
Summary	552	(1)
Questions	553	(2)
Exercises	555	(2)
Lesson C: Completing the Text Editor Application	557	(20)
Coding the File Menu's Save Command	557	(2)
Coding the File Menu's Print Command	559	(1)
Coding the File Menu's Open Command	560	(3)
The Input and LOF Functions	562	(1)
Coding the Form's Unload Event	563	(4)
Summary	567	(1)
Questions	567	(1)
Exercises	568	(4)
Debugging	572	(5)
tutorial 8 RANDOM ACCESS FILES	577	(68)
The Cole's Playhouse Application	577	(3)
Previewing the Application	578	(2)
Lesson A: Random Access Files	580	(24)
Random Access Files versus Sequential Access Files	580	(1)
Sequential Access vs. Random Access File Storage	581	(3)
The Type Statement	584	(3)
Coding the Code Module	586	(1)
Creating and Opening a Random Access File	587	(1)
Coding the Form's Load Event Procedure	587	(1)
Closing a Random Access File	588	(1)
Writing Records to a Random Access File	588	(4)
Coding the Enter Item Button	589	(3)
Initializing a Random Access File	592	(2)
Reading Records from a Random Access File	594	(2)
Coding the Display Item Button	594	(2)
Summary	596	(2)
Questions	598	(3)
Exercises	601	(3)
Lesson B: The Cole's Playhouse Application	604	(23)
The Cole's Playhouse Application	604	(4)
Coding the Cole's Playhouse Application	608	(1)
Coding the File Menu's New Command	609	(1)
Passing Information to a Sub Procedure	610	(1)
Using Visual Basic's Color Constants	611	(1)
Creating a User-Defined Procedure that Receives Data	612	(4)
Coding the File Menu's Open Command	616	(4)
Summary	620	(1)
Questions	621	(2)
Exercises	623	(4)
Lesson C: Completing the Cole's Playhouse Application	627	(18)
Coding the lblSeat Control Array	627	(3)
Referencing a Control in Another Form	628	(2)
Coding the Enter Ticket Button	630	(4)
The Trim Function	633	(1)
Coding the Cancel Ticket Button	634	(1)
Coding the Return to Main Button	635	(1)
Summary	636	(1)
Questions	637	(1)
Exercises	638	(4)
Debugging	642	(3)
tutorial 9 DATABASE ACCESS	645	(72)
Modifying the Cole's Playhouse Application	645	(3)
Previewing the Modified Cole's Playhouse Application	646	(2)
Lesson A: Using Visual Data Manager	648	(24)
Database Concepts and Terminology	648	(1)
Designing the Cole's Playhouse Database	649	(3)
Using Visual Data Manager to Create the Cole Database	652	(6)
Creating an Index	658	(1)
Including Data Validation Rules in a Table	659	(2)
Opening an Existing Database	661	(5)
Summary	666	(1)
Questions	666	(2)
Exercises	668	(4)
Lesson B: Using the ADO Data Control	672	(17)
Microsoft's UDA Approach to Accessing Data	672	(1)
The Cole's Playhouse Application	672	(1)
Using the ADO Data Control	673	(5)
Binding Controls to an ADO Data Control	678	(1)
Using the SQL Select Command	679	(4)
Summary	683	(1)
Questions	683	(2)
Exercises	685	(4)
Lesson C: Writing Code to Add, Delete, and Update Records	689	(28)
The Cole's Playhouse Application	689	(1)
The Recordset and Field Objects	689	(2)
The ADO Data Control's Refresh Method	691	(1)
Completing the Cole's Playhouse Application	691	(3)
Coding the lblSeat Array's Click Event	694	(3)
Coding the Return to Main Button	697	(1)
Coding the Enter Ticket Button	698	(2)
Coding the Cancel Ticket Button	700	(2)
Summary	702	(1)
Questions	703	(2)
Exercises	705	(8)
Debugging	713	(4)
tutorial 10 VARIABLE ARRAYS	717	(84)
Creating A Payroll Application	717	(3)
Previewing the Completed Application	718	(2)
Lesson A: Storing Data in a Variable Array	720	(36)
Variable Arrays	720	(2)
Advantages of Variable Arrays	721	(1)
Creating a One-dimensional Variable Array	722	(1)
Storing Data in a One-dimensional Variable Array	723	(1)
The President Application	724	(1)
Coding the President Application	724	(6)
The Form's Load Event Procedure	725	(1)
The Display Name Button	725	(3)
The Display Number Button	728	(2)
The Test Score Application	730	(8)
The Average Score Button	732	(1)
The Highest Score Button	733	(2)
The Update Scores Button	735	(3)
The Classroom Application	738	(6)
Summary	744	(1)
Questions	744	(6)
Exercises	750	(6)
Lesson B: The DataGrid Control and Object Variables	756	(27)
The Colfax Industries Payroll Application	756	(2)
The DataGrid Control	758	(10)
Improving the Appearance of the DataGrid Control's Data	761	(7)
Coding the DataGrid Control	768	(5)
Creating an Object Variable	770	(2)
Rounding Numbers	772	(1)
Summary	773	(1)
Questions	773	(3)
Exercises	776	(7)
Lesson C: Completing the Colfax Payroll Application	783	(18)
Storing the Federal Withholding Tax Tables in Two Two-dimensional Arrays	783	(4)
Creating a Function Procedure to Calculate the FWT	787	(4)
Invoking a Function Procedure	791	(1)
Summary	792	(1)
Questions	793	(1)
Exercises	793	(1)
Debugging	794	(7)
appendix a Creating a Web Page With Visual Basic	801	(9)
appendix b Visual Basic's Drag­And­Drop Feature	810	(5)
appendix c Using the Clipboard, DDE, and Ole	815	(23)
appendix d Creating Your Own Activex Control	838	(5)
index	843