Level 1 - Programming Fundamentals of Visual Basic 6.0
Your First Visual Basic Program
- Welcome to Visual Basic!
- A Simple Project
- Using the Application Wizard
Adding Controls to Forms
- Visual Basic Controls
- Creating and Manipulating New Controls
- Changing Design Time Control Properties
- Visual Basic Built-In Controls
- Control Design Tips
Understanding Events
- Introducing Events
- Event Procedures
- The Form Load Event
- The Form Resize Event
- Command Button Click Event
- Text Box Change Event
- The Timer Control Event
- GotFocus/LostFocus Events
Working With Forms and Controls
- Setting Properties at Run Time
- Setting Form Properties
- Setting Control Properties
- Using Active X Controls
- Adding ActiveX Controls to a Project
- Using ActiveX Controls
Creating and Using Menus
- Menus in Visual Basic
- Using the Menu Editor
- Working with Menus
- Manipulating Menus at Run Time
- Reusing Menus
Compiling and Distributing Applications
- Finishing Touches
- Project Properties
- Native Code vs. p-code
- Creating Your Executable
- Using the Package and Deployment Wizard
Working with VBA
- Creating a Simple Procedure
- Variables and Parameters
- Data Types
- Using Constants
- Investigating Built-In Functions
- Branching Structures
- Looping Structures
Handling Errors
- Handling Syntax Errors
- Handling Run-Time Errors
- The Error Handling Standard
- Taking a Closer Look
- Who Handles Errors?
Debugging Applications
- Handling Logic Errors
- Watch Expressions
- The Call Stack
- The Debugging Process
More VBA Issues
- Scope, Lifetime and Precedence
- Passing by Value and by Reference
- Arrays
- Optional Arguments
More Forms and Control Issues
- Using Multiple Forms
- List Boxes Revisited
- Control Arrays
Adding Simple Database Support
- Support for Data Access in Visual Basic 6.0
- Using the ADO Data Control
- Binding Controls to Data
- Writing Code for Data Control
More VBA Issues
- Scope, Lifetime and Precedence
- Passing by Value and by Reference
- Arrays
- Optional Arguments
More Form and Control Issues
- Using Multiple Forms
- List Boxes Revisited
- Control Arrays
Adding Simple Database Support
- Support for Data Access in Visual Basic 6.0
- Using the ADO Data Control
- Binding Controls to Data
- Writing Code for Data Control
Level II - Programming Visual Basic Applications
An Introduction to Objects
- What is an Object?
- The Object Browser
- System Objects
- Introducing Object Variables
- Classifying Objects
- Referring to Objects
- Using the Global Forms Collection
- Working with External Objects
Managing Data with ADO
- What is ADO?
- Getting Started with ADO
- The ADO Object Hierarchy
- The ADO Connection Object
- Working with Recordset Properties and Methods
- The Command Object
- Updating Recordset Data
ADO and Unbound Forms
- Forms and ADO
- Displaying Data on the Form
- Changing Data on the Form
- Finding Data on the Form
- Using a Default Recordset
- Maintaining State Information
Using User Interface Data Tools
- What's Wrong with the ADO Data Control?
- Taking Advantage of the Data Environment
- The Hierarchical FlexGrid Control
- Creating Reports in Visual Basic
Using Form Modules
- What's a Form?
- Adding Form Methods
- Adding Form Properties
- Implementing Dialogs
- Creating Multiple Instances of a Form
- Life Cycle of a Form
Creating Your Own Objects
- Introduction to Class Modules
- Starting and Stopping
- Properties Aren't Always So Simple
- Working with Text Files
- Using the Class Builder
Working with Collections
- Collection Overview
- Using the Collection Object
Creating MDI Applications
- What is a MDI?
- Creating an MDI Application
- Working with MDI Applications
- Using Windows Common Controls
Working with Windows API
- What is a Windows API?
- API Declarations
- Using the API Viewer/WIN32API.TXT
- Declaring User-Defined Data Types
- Working with Strings
- Talking to Controls (Using SendMessage)
- Resources
Optimizing Visual Basic Programs
- Getting Started with Optimization
- Testing Hypotheses
- Where Do You Look?
- Optimizing Code Speed
- Optimizing Display Speed
- Optimizing Apparent Speed
- Optimizing Size in Memory
Adding Professional Touches
- Storing Program Options
- Using the Common Dialog Control
- Adding Standard Forms
- Creating Your Own Templates
Level III - Advanced Visual Basic 6.0 Programming Concepts
Controlling Applications Using Automation
- What is Automation?
- Working with Other Applications
- Example: Building an Excel Chart
- Introducing With Events
Creating Automation Components
- Creating and Using an ActiveX Code Component
- Raising Events from ActiveX Components
- Registering ActiveX Components
- Handling Errors in ActiveX Components
- In-Process vs. Out-of-Process Components
- Understanding Instancing
Advanced Class Module Issues
- Creating a Collection Class
- Creating Default Members
- Creating an Enumeration Function
- Adding Enumerated Types
Building ActiveX Controls
- What is an ActiveX Control, Anyway?
- Creating the ProgressMeter Project
- Adding the TestMeter project
- Drawing the ProgressMeter
- Running the ProgressMeter at Design Time
- Setting up the Control's Resize Event Procedure
- Working with the ProgressMeter's Properties
- Using the ActiveX Control Interface Wizard
- Giving the ProgressMeter a Property Page
- Adding Events to the ProgressMeter Control
- Compiling the ProgressMeter Control
- Distributing the ProgressMeter Control
- ActiveX Controls and the Internet
Advanced ADP Topics
- Reviewing OLE DB and ADO
- Managing Connections
- Working with Data
- Creating Recordsets in memory
- Persisting Recordsets
- Retrieving Multiple Resultsets
Appendix Topics (Covered as time permits)
- The Reddick VBA Naming Convention
- Class Module Issues
- DHTML Applications
- Using Polymorphism
- Introduction to ADO
- Client/Server Quick Overview
- More Advanced ADO
- New VBA Functions
- Useful Shortcuts
|
