Advanced VB 6

Advanced Visual Basic 6.0, a continuation of the introductory course, is taught via lectures and demonstrations followed by hands-on exercises which are supervised by the instructor. Throughout this process, participants will be exposed to the advanced features of Visual Basic and object-oriented programming.

Course Duration

Four or five days. Some topics are omitted to create the four-day version.

Upon completion of this Course, Students will…

• Be able to create an appropriate new Visual Basic project by selecting from the appropriate project templates
• Be able to modify existing and create new project templates · Be able to create an ActiveX Control in Visual Basic
• Be able to control ActiveX servers (such as Microsoft Excel or Microsoft Word) programmatically
• Be able to create a Visual Basic Add-In
• Understand how to create and use Visual Basic user-defined objects
• Understand the Visual Basic exception-handling mechanism and be able to use it to its fullest advantage
• Be able to examine new third-party controls and explore their properties and available methods-even if there is inadequate documentation
• Understand Visual Basic's universal formatting scheme as applied to the Format function, SQL, Excel, and other places in the Microsoft world
• Be able to programmatically create a database, complete with tables and indexes (5-day only)

Outline

Working with Objects

• Review of VB Objects
• Designing Objects
• Documenting Objects
• Working with the System Registry
• User-Defined Events

Working with Advanced Controls

• Using the StatusBar Control
• The ImageList Control
• The Toolbar Control
• The TreeView Control
• The ListView Control
• Creating an Explorer-Style Form

Working with Exceptions

• The Call Stack
• The On Error and Resume Statements
• The Err and Error$ Built-in Functions
• Hierarchical Error Trapping
• Programmer-Defined Errors
• In-Line Error Checking

Working with Text Formatting and Validation

• Overview
• Creating a Masked Edit Control
• Formatting in Visual Basic
• Setting the Masked Edit properties
• Masking Characters
• Customization Properties
• Text Manipulation Properties
• The ValidationError Event

Working with Project Automation

• Using the Project Templates and Wizards
• How to Create a Project Template
• Creating an Add-In

Working with ActiveX Automation

• Dynamic Data Exchange*
• Compound Document Options
• The OLE Control
• Implementing the Clipboard commands for embedded and linked objects
• ActiveX Automation Options
• Controlling Excel from Visual Basic
• Creating an ActiveX control in Visual Basic

Working with Databases*

• Data Control vs. Database Object

• Database Creation Choices
• Creating a Database with the Database Object
• Adding a Table to a Database
• Creating a TableDef Object
• Creating a Field Object
• Adding a Field to the Fields Collection
• Creating an Index Object
• Adding an Index to the Indexes Collection
• Adding a TableDef to the TableDefs Collection
• How to Enumerate a Collection
• Using the Data Report designer

* Five-day course only