McSd Guide to Developing Desktop Applications With Microsoft Visual Basic 6.0 Advanced Topics

by Ekedahl, Michael V.

• ISBN13: 9780760011478
• ISBN10: 0760011478
• Edition: 2nd
• Format: Paperback
• Copyright: 1999-08-17
• Publisher: Course Technology

Summary

This Microsoft-approved title prepares individuals for the "Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 Certification Exam" (# 70-176).This book covers all new features of Visual Basic 6.0, including the Install Wizard, HTML Help, Deployment Wizard, and all new and revised controls. It also includes topics not required for the exam but necessary for effective solution development.

Table of Contents

Installing and Configuring Visual Basic for the Desktop	1	(68)
Installing Visual Basic for the Desktop	2	(23)
Installing Visual Basic	2	(19)
Installing Server Components	21	(2)
Questions	23	(2)
The Basics of Visual Basic	25	(23)
A Review of Visual Basic	25	(3)
The Structure of a Visual Basic Program	28	(3)
The Visual Basic Integrated Development Environment	31	(3)
Opening and Saving Projects	34	(2)
Understanding Properties	36	(2)
The Name Property	38	(1)
Properties --- Design Mode Versus Run Mode	39	(1)
Using the Properties Window	40	(2)
The Label Control	42	(1)
Responding to an Event	43	(2)
The Code Window	45	(1)
Questions	46	(2)
Configuring Visual SourceSafe	48	(21)
The Purpose of Visual SourceSafe	48	(1)
Installing Visual SourceSafe	49	(1)
Configuring Visual SourceSafe	50	(12)
The VSS Interface	62	(1)
Summary	63	(2)
Questions	65	(1)
Exercises	66	(3)
Fundamentals of Event Driven Programming	69	(72)
Understanding Visual Basic Syntax	70	(24)
Previewing the Completed Program	70	(3)
The Structure of a Visual Basic Program	73	(2)
Procedures	75	(1)
Understanding Call by Reference and Call by Value	75	(1)
Scope	76	(4)
Understanding Mouse and Keyboard Events	80	(5)
The Basics of Form Events	85	(2)
Control Arrays	87	(5)
Questions	92	(2)
Working with Menus	94	(28)
Adding a Menu to an Application	94	(2)
Using the Menu Editor	96	(3)
Adding a Pop-Up Menu to an Application	99	(3)
The InputBox and MsgBox Functions	102	(19)
Questions	121	(1)
Working with Collections of Controls and Handling Errors	122	(19)
Collections	122	(4)
Creating an Error Handler	126	(4)
Summary	130	(3)
Questions	133	(1)
Exercises	134	(7)
Creating Data Services Using ADO	141	(70)
Using Visual Basic Controls to Interact with a Database	142	(31)
Previewing the Completed Program	142	(3)
Fundamental Database Concepts	145	(1)
A Conceptual Overview of ActiveX Data Objects and OLE DB	146	(3)
Introducing ActiveX Controls	149	(2)
The ADO Data Control	151	(2)
Connecting to a Database with the ADO Data Control	153	(6)
Creating Bound Controls	159	(8)
The Recordset Object	167	(4)
Questions	171	(2)
Using the Recordset Object to Manipulate Data	173	(38)
Using ADO Programmatically	173	(13)
Programming the Recordset Object	186	(1)
Determining a Recordset's Functionality	186	(4)
Locating Specific Records	190	(3)
Understanding Bookmarks	193	(2)
Looping Through the Records in a Recordset	195	(1)
Making Changes to Data	195	(1)
Adding Data	196	(2)
Changing Data	198	(1)
Deleting Data	198	(1)
Validating Field Input	199	(1)
Summary	200	(2)
Questions	202	(2)
Exercises	204	(7)
Accessing a Database with SQL and ActiveX Controls	211	(62)
Introduction to the SQL Programming Language	212	(31)
Previewing the Completed Application	212	(4)
The SQL Language	216	(3)
Retrieving Data with the SELECT Statement	219	(5)
Restricting the Rows Returned with the WHERE Clause	224	(2)
Selecting Records Using Ranges and Patterns	226	(2)
Selecting Specific Fields	228	(2)
Handling Database Errors	230	(2)
Performing Action Queries	232	(1)
The INSERT Statement	233	(4)
The UPDATE Statement	237	(2)
Deleting Database Records	239	(1)
Transactions	240	(1)
Questions	241	(2)
Using the DataList, DataCombo, and DataGrid Controls	243	(30)
The DataList and DataCombo Controls	243	(4)
The DataGrid Control	247	(3)
Changing the Behavior of the Arrow and Tab Keys	250	(1)
Formating the DataGrid Control	251	(6)
Selecting Records Dynamically	257	(1)
Modifying Data with the DataGrid Control	258	(1)
Events Pertaining to the DataGrid control	259	(2)
Validating Changes in the DataGrid Control	261	(2)
Creating Columns at Run Time	263	(1)
Linking Multiple DataGrid Controls	264	(1)
Summary	265	(2)
Questions	267	(1)
Exercises	268	(5)
The Windows Common Controls (Part 1)	273	(60)
The Tree View Control	274	(35)
Previewing the Completed Program	274	(2)
Introducing the Windows Common Controls	276	(3)
Storing Images in the ImageList Control	279	(4)
Introduction to Drill-Down Interfaces	283	(2)
The Tree View Control	285	(4)
The Node Object	289	(2)
Adding a Node to the TreeView Control	291	(3)
Creating the Root-Level Node	294	(2)
Creating Child Nodes	296	(8)
Navigating the Node Hierarchy	304	(3)
Questions	307	(2)
Working with the ListView Control	309	(24)
The ListView Control	309	(5)
Integrating the ListView and TreeView Controls	314	(3)
Defining the View	317	(1)
Arranging the Icons	318	(1)
Using Report View	319	(1)
The ColumnHeader Object	320	(3)
Column Selection	323	(1)
Summary	324	(2)
Questions	326	(1)
Exercises	327	(6)
The Windows Common Controls (Part 2)	333	(64)
Using the Toolbar and DTPicker Controls	334	(32)
Previewing the Completed Application	334	(3)
Reviewing Fundamental Concepts	337	(2)
Improving a User Interface with the Toolbar Control	339	(1)
Creating the Toolbar and Its Buttons	340	(1)
Setting the General Characteristics of the Toolbar	341	(13)
Using the DTPicker Control	354	(10)
Questions	364	(2)
More Common Controls	366	(31)
Using the UpDown Control	366	(3)
Using the ImageCombo Control	369	(4)
The Slider Control	373	(3)
The FlatScrollBar Control	376	(2)
The ProgressBar Control	378	(2)
Improving the User Interface with a Status Bar	380	(7)
Summary	387	(2)
Questions	389	(1)
Exercises	390	(7)
Multiple Document Interface Programming	397	(60)
Creating a Multiple-Document Interface Application	398	(24)
Previewing the Completed Application	398	(3)
Characteristics of MDI Programs	401	(1)
Menus and MDI Programs	402	(2)
Forms as Classes	404	(7)
Destroying Form Instances	411	(5)
Other Ways to Keep Track of Forms	416	(1)
The Me Keyword	416	(1)
The Forms Collection	416	(1)
The Screen Object	417	(1)
Arranging MDI Forms	418	(2)
Questions	420	(2)
Programming the RichTextBox, CommonDialog, and Toolbar Controls	422	(35)
Reading and Writing Files with the RichTextBox Control	422	(2)
Opening and Saving Files with the CommonDialog Control	424	(2)
Understanding the CancelError Property	426	(1)
Opening Files with the CommonDialog Control	427	(6)
Saving Files Using the Common Dialog Control	433	(1)
Formatting the Contents of a Rich Text Box	434	(4)
Working with Fonts	438	(3)
Justifying Text	441	(1)
Printing Output	442	(3)
Changing Colors	445	(1)
Programming the Toolbar	446	(1)
Understanding the Windows Clipboard	447	(2)
Summary	449	(2)
Questions	451	(1)
Exercises	452	(5)
Designing and Implementing Component-Based Applications	457	(44)
Designing a Component-Based Program	459	(23)
Previewing the Completed Application	459	(1)
Computer Programs-A Historical Perspective	460	(2)
Developing Software for a New Distributed System	462	(1)
The Three-Tiered Approach	463	(3)
Changing Roles	466	(1)
Changing Technologies	466	(3)
The Three Views of Component-Based System Design	469	(1)
Conceptual Design	470	(4)
Logical Design	474	(2)
Physical Design	476	(1)
Allocating Services to Components	477	(1)
Component Distribution	477	(2)
Component Interface Specification	479	(1)
Network Distribution Plan	479	(1)
Questions	480	(2)
Implementing the Design Using Existing Components	482	(19)
Creating Automation Objects	482	(11)
Summary	493	(2)
Questions	495	(1)
Exercises	496	(5)
Reusing Code with Class Modules	501	(58)
Fundamentals of a Class Module	502	(37)
Previewing the Completed Application	502	(2)
An Introduction to Components	504	(3)
Component Object Modules	507	(2)
The Roles of Author and Developer	509	(1)
Anatomy of a Class Module	509	(3)
Creating a Class Module	512	(3)
Creating the Properties of a Class	515	(2)
Hiding Data in the Class	517	(1)
Creating Properties with Property Procedures	518	(3)
Implementing Read-Write Properties with Property Procedures	521	(2)
Passing Arguments to Property Procedures	523	(1)
Implementing Properties with Parameters	523	(4)
Using Object References in Property Procedures	527	(1)
Read-Only Properties	528	(1)
Write-Once Properties	529	(2)
Class Events	531	(1)
Methods	532	(1)
Class Module Enumerations	533	(4)
Questions	537	(2)
Supporting Multiple Question Types	539	(20)
A Behind the Scenes Look at Class Modules	539	(3)
Debugging Class Modules	542	(2)
Enhancing the Class	544	(1)
Polymorphism Using the Implements Statement	545	(1)
The Abstract Class	546	(3)
Implementing the Abstract Class	549	(1)
The Implements Statement	550	(1)
Setting Procedure Names for the Implemented Class	550	(2)
Abstract Class Initialization	552	(1)
Summary	552	(2)
Questions	554	(1)
Exercises	555	(4)
Creating a Collection Hierarchy	559	(66)
Creating a Collection of Objects	560	(33)
Previewing the Completed Application	560	(4)
Designing an Object Hierarchy	564	(4)
Creating a First Collection	568	(2)
Three Approaches to Creating an Object Hierarchy	570	(4)
Adding an Employee Object to the Employees Collection	574	(2)
Removing an Employee Object from the Employees Collection	576	(2)
Counting the Employee Objects in the Employees Collection	578	(1)
Enhancing the Class---The House of Sticks	579	(5)
Enhancing the Class---The House of Bricks	584	(4)
Creating a Default Method or Property	588	(1)
Enabling ``For Each'' Support	589	(2)
Questions	591	(2)
Understanding Project Types	593	(16)
Expanding the Object Hierarchy	593	(1)
Using the Class Builder Utility	594	(1)
More About the Project	595	(1)
Working with Project Groups	596	(1)
Adding a Project to a Project Group	597	(2)
Setting the Startup Project	599	(1)
Creating a Client-Server Project Group	599	(1)
Types of Projects Supported by Visual Basic	600	(1)
A Word About Executing Programs	600	(4)
Class Instancing	604	(2)
An Introduction to Multithreading	606	(1)
Questions	607	(2)
Creating a Persistent Collection Hierarchy	609	(16)
Creating an Object Hierarchy with Persistent Data	609	(8)
Summary	617	(2)
Questions	619	(1)
Exercises	620	(5)
Creating an ActiveX Control	625	(56)
The Basics of ActiveX Control Creation	626	(18)
Previewing the Completed Application	626	(2)
Creating ActiveX Controls	628	(1)
ActiveX Terminology	629	(1)
Creating ActiveX Control Objects	629	(4)
Design Time Versus Run Time	633	(3)
Predefined User Control Objects	636	(1)
Constituent Controls	637	(3)
Creating Multiple Constituent Controls	640	(2)
Questions	642	(2)
Events, Properties, and Methods	644	(24)
Properties, Events, and Methods	644	(1)
User Control Events	644	(4)
Understanding User Control Events	648	(2)
Object Focus	650	(4)
Exposing Properties to the Developer	654	(1)
Fundamentals of Properties	655	(1)
The PropertyChanged Method	656	(1)
Delegating Properties	657	(2)
Aggregating Properties	659	(1)
Persistent Properties	660	(1)
The PropertyBag Object	661	(3)
Read-Write and Read-Only Properties	664	(2)
Questions	666	(2)
Creating Better Properties	668	(13)
Improving the Behavior of the Properties Window	668	(2)
Enumerated Properties	670	(2)
User-Defined Enumerations	672	(1)
Creating Data-Aware Controls	673	(2)
Using the ActiveX Control Interface Wizard	675	(1)
Summary	676	(1)
Questions	677	(1)
Exercises	677	(4)
Extending ActiveX Control Features	681	(46)
Adding Property Pages to an ActiveX Control	682	(26)
Previewing the Completed Application	682	(7)
Creating Property Pages	689	(3)
Standard Property Pages	692	(4)
User-Defined Property Page Modules	696	(8)
Multiple Selected Controls	704	(1)
Debugging ActiveX Controls	704	(2)
Questions	706	(2)
Enabling a Control for Use on the Internet	708	(19)
Using ActiveX Controls on the Web	708	(1)
Static and Dynamic Web Pages	709	(1)
A Brief Introduction to HTML	709	(3)
OBJECT Tags	712	(1)
Distributing an ActiveX Control	712	(1)
Licensing a Control	713	(1)
Control Security	714	(1)
Obtaining a Digital Signature	715	(1)
The Property Page Wizard	716	(1)
The Package and Deployment Wizard	717	(5)
Summary	722	(2)
Questions	724	(1)
Exercises	725	(2)
ActiveX Documents	727	(42)
Creating an ActiveX Document Project	728	(24)
Previewing the Completed Application	728	(2)
The Role of ActiveX Documents	730	(1)
ActiveX Document Design Guidelines	730	(1)
Creating an ActiveX Document	731	(2)
ActiveX Document Menus	733	(4)
Executing an ActiveX Document	737	(1)
Testing the Document	738	(2)
Lifetime of an ActiveX Document	740	(1)
Persistent Properties	741	(3)
Multiple ActiveX Document Applications	744	(1)
Internet Explorer Navigation	744	(4)
Controlling Navigation	748	(1)
Understanding the Viewport	748	(2)
Questions	750	(2)
Using the Office Binder as an ActiveX Document Container	752	(17)
Office Binder as a Container	752	(1)
Introducing the Microsoft Office Binder	753	(1)
Determining the Container	754	(1)
Accessing Office Binder Programmatically	755	(9)
Testing Office Binder	764	(1)
Summary	765	(1)
Questions	766	(1)
Exercises	767	(2)
Using Internet Controls	769	(42)
Sending Mail Using the WinsockControl and the Simple Mail Transfer Protocol	770	(25)
Previewing the Completed Application	770	(3)
An Introduction to the Internet	773	(1)
Internet Numbers and IP Numbers	773	(1)
TCP/IP	774	(1)
Internet Services	775	(1)
Implementing Internet Services	776	(2)
The Winsock Control	778	(4)
The Error Event	782	(1)
Internet Standards (RFCs)	783	(1)
SMTP	783	(4)
Processing Incoming Data	787	(6)
Questions	793	(2)
Transferring Files with the Internet Transfer Control	795	(16)
The Internet Transfer Control	795	(2)
Synchronous Versus Asynchronous Transmission	797	(1)
Implementing an FTP Client	798	(1)
Implementing the File Transfer Protocol	798	(3)
Processing Responses from the Internet Transfer Control	801	(6)
Network Timeouts	807	(1)
Summary	807	(1)
Questions	808	(1)
Exercises	809	(2)
DHTML and HTML Help	811	(54)
Developing a Dynamic HTML Application	812	(25)
Previewing the Completed Applications	812	(2)
Dynamic HTML	814	(3)
DHTML Application Structure	817	(8)
Understanding the DHTML Event Model	825	(2)
Setting Element Styles	827	(6)
Navigating Through DHTML Applications	833	(1)
Compiling the DHTML Project	834	(1)
Questions	835	(2)
HTML Help	837	(28)
Previewing the Completed Application	837	(1)
Introducing HTML Help	838	(1)
Installing HTML Help Workshop	839	(1)
Structure of a Help System	840	(1)
Creating an HTML Help System	840	(3)
Defining the Table of Contents	843	(4)
Defining the Index	847	(1)
Compiling the Help System	848	(1)
Adding Links to the HTML Pages	849	(1)
Using the HTML Help ActiveX Control	850	(2)
Creating a Context-Sensitive Help File	852	(3)
Connecting the Help System to the Program	855	(1)
Developing What's This Help	856	(4)
Summary	860	(2)
Questions	862	(1)
Exercises	863	(2)
Understanding the Windows Application Programming Interface	865	(50)
Programming the Windows Registry	866	(14)
Previewing the Completed Application	866	(2)
Introducing the Windows Registry	868	(2)
Registry Functions	870	(4)
Viewing the Registry Using RegEdit	874	(3)
Deleting Registry Entries	877	(1)
Registering a Server	877	(1)
Remote Component Registration	878	(1)
Questions	878	(2)
The Basics of Windows Dynamic Link Libraries	880	(35)
Dynamic Link Library Defined	880	(2)
Referencing a Dynamic Link Library	882	(1)
Declaring a DLL Procedure	883	(2)
Creating Aliases	885	(1)
Locating a DLL Procedure	886	(3)
Using By Val and ByRef Arguments in DLL Procedures	889	(1)
Calling a DLL	890	(1)
Managing Temporary Files	891	(1)
Passing Strings to DLL Procedures	892	(5)
Passing Properties	897	(1)
Callback Functions	897	(4)
Asynchronous Notification Using Events and Callbacks	901	(1)
Asynchronous Notification Using Events	902	(2)
Asynchronous Notification Using Callbacks	904	(3)
Executing Other Programs	907	(2)
Summary	909	(1)
Questions	910	(2)
Exercises	912	(3)
Program Deployment and Maintenance	915	(1)
The Visual Basic Compiler	916	(11)
Previewing the Completed Application	916	(1)
The Visual Basic Compiler	917	(5)
Conditional Compilation	922	(3)
Questions	925	(2)
Visual Component Manager	927	(15)
The Purpose of Visual Component Manager	927	(1)
Organization of Visual Component Manager	928	(2)
Publishing a Component	930	(7)
Locating Components	937	(1)
Adding Components to a Project	938	(1)
Creating Additional Repositories	939	(1)
Questions	940	(2)
The Package and Deployment Wizard	942	(1)
Introducing the Package and Deployment Wizard	942	(1)
Floppy Disk and CD-ROM Deployment	942	(6)
Deploying Packages to the Web	948	(1)
Preparing a Digital Signature	949	(1)
Establishing Safety Settings	950	(1)
Component Licensing	950	(1)
Preparing an ActiveX Control for Web Deployment	951	(2)
Deploying the Package	953	(1)
Understanding Application Updates	954	(1)
Summary	955	(1)
Questions	956	(2)
Exercises	958
APPENDIX A DEBUGGING	A-1	(1)
Section A Programming Errors	A-2	(1)
Identifying Programming Errors	A-2	(1)
Preparing a Programming for Debugging	A-3	(1)
Visual Basic Debugging Tools	A-6	(1)
Tracing Program Execution	A-7	(1)
Setting Breakpoint	A-9	(1)
Using the Immediate Window	A-10	(1)
Using the Watches Window	A-11	(1)
Using the Locals Window	A-14	(1)
Summary	A-14