Table Of ContentTo access the contents, click the chapter and section titles.
Advanced Visual Basic Techniques
(Publisher: John Wiley & Sons, Inc.)
Author(s): Rod Stephens
ISBN: 0471188816
Publication Date: 06/01/97
Brief Full
Advanced
Search this book:
Search
Search Tips
Introduction
Part One—Application Basics
Chapter 1—ExpenseReporter from a User’s
Point of View
Using ExpenseReporter
Field Validations
Managing Controls
Print Preview and Printing
Managing Files
Help
Key Techniques
Creating Scrolling Areas
Arranging Controls
Creating Controls Dynamically
Enhancing Field Navigation
Selecting a Document Interface
Managing SDI Documents
Setting DataModified
IgnoreModify
Using DataModified
Loading and Saving Files
SaveDataAs
SaveData
Open
Files Specified in the Command Line
New
Designing Menus
Mnemonics and Accelerators
Menus That Present Dialogs
Separators
Standard Menus
Providing Recent File Lists
File List Menu Items
UpdateRecentFileMenu
SaveRecentFiles
LoadRecentFiles
AddRecentFile
RemoveRecentFile
Summary
Chapter 2—Building the ExpenseReporter
Key Techniques
Providing Feedback
Validating Data
Validating Forms
Output-Only Text Boxes
Formatting Text
Printing
The Printer Object
Print Previewing
Managing Two Scroll Bars
Printing with a Dialog
Providing Printer Setup
Providing Help
Types of Help Systems
Building a Help File
Using a Help File in Visual Basic
Providing Context-Sensitive Help
Windows 3.x Style Help
Windows 95 Style Help
Displaying About Dialogs and Splash Screens
Summary
Chapter 3—AppointmentBook
Using AppointmentBook
Selecting Dates
Viewing Appointments
Creating Appointments
Modifying or Deleting Appointments
Loading and Saving Data
Purging Old Data
Displaying Help
Displaying Context-Sensitive Help
Viewing the About Dialog
Keeping Pieces Synchronized
Key Techniques
Using Bit Masks
Defining Bit Masks
Combining Bit Masks
Bit Masks in AppointmentBook
Using the MVC Paradigm
Models
Views
Controllers
View/Controllers
MVC in AppointmentBook
Creating Fonts
Using CreateFont
Scrolling Large Amounts of Data
Setting Alarms
Creating Nonrectangular Forms
Presenting Help
Building a Help Browser
Building Help Documents
Summary
Part Two—Add-Ins
Chapter 4—PropertySetter
Installing PropertySetter
Using PropertySetter
Key Techniques
Understanding OLE
Creating Add-Ins
Setting Project Options
Creating the Add-In Class
Creating Sub Main
Creating the Server DLL
Summarizing Add-In Creation
Testing Add-Ins
Summary
Chapter 5—Aligner
Using Aligner
Key Techniques
Providing AfterClick
Aligning Controls in Columns
Aligning Controls in Rows and Columns
Summary
Chapter 6—Scroller
Using Scroller
Key Techniques
Creating Add-In Submenus
Creating the Scrolling Area
Creating Controls
Setting Control Containment
Arranging Scrolling Area Controls
Summary
Chapter 7—AddInMaker
Using AddInMaker
Key Techniques
Managing AddInMaker’s Dialog
Building Sub Main
Building ConnectAddIn and DisconnectAddIn
CreateConnectAddIn
CreateDisconnectAddIn
Creating Command Classes
Summary
Part Three—Databasics
Chapter 8—PeopleWatcher
Using PeopleWatcher
Key Techniques
Understanding Databases
Database Engines
The Data Manager
Using the Data Control
The Data Control
Binding Other Controls
Selecting Records
Coding for the Data Control
Using Data Access Objects
Creating Recordsets
Understanding PeopleWatcher
Managing the Outline Control
Displaying Appropriate Commands
Editing Records
Editing Images
Accepting and Canceling Changes
Validating Data
Customizing the Interface for Users
The DBUser Class
Field Validation
Testing Database Applications
Summary
Chapter 9—Query
Using Query
Key Techniques
Creating Databases
Composing SQL Commands
CREATE
DROP
ALTER
SELECT
INSERT
UPDATE
DELETE
Processing SQL Statements
ProcessAllCommands
StripCommands
ProcessCommand
ProcessSelect
Privileges
Summary
Chapter 10—PeopleWatcher Remote
Key Techniques
Accessing Remote Databases Directly
Using Remote Databases with Data Controls
Attaching Remote Tables
Attaching Programmatically
Using Data Managers
Improving Network Performance
Summary
Part Four—Client/Server Applications
Chapter 11—TimeSync
Using TimeSync
Key Techniques
Step 1: Testing within the Client
TimeSync Step 1
Step 2: Testing Locally
Building the Server
Building the Client
Testing
Step 2 Summary
Step 3: Testing Remotely
Compile the Server
Install the Server
Register the Server
Grant Server Access
Start the Automation Manager
Register the Server
Run the Client
Trouble Shooting
Using RegClass
Summary
Chapter 12—QueryServer
Using QueryServer
Key Techniques
Building ReportList
QueryServerForm
ReportListForm
ParameterForm
ReportForm
Building Librarian
Building SQLServer
A Typical SQLServer
Free-Format SQL
Summary
Chapter 13—AsyncServer
Using AsyncServer
Key Techniques
Building Asynchronous Servers in Visual Basic
Requesting Reports
Getting Report Parameters
Imitating Modality
Requesting Reports
Generating Reports
Scheduling the Report
Starting the Report Object
Building the Report
Displaying Results
Displaying the ReportForm
Displaying the Report
Displaying Messages
Summary
Part Five—ActiveX
Chapter 14—The Alarm Control
Using the Alarm Control
Key Techniques
Working with Control Projects
The Test Application
The ActiveX Control
Running the Test Application
Managing Control Display
Implementing Property Procedures
Setting Default Property Values
Using Ambient Properties
Deferring Execution during Initialization
Reading and Writing Property Values
Delegating Standard Properties
Property IDs
The Enabled Property
Raising Events
Summary
Chapter 15—Bar Gauge
Interacting with Bar Gauge
Programming Bar Gauge
Key Techniques
Managing Bar Gauge Properties
Min, Max, KeyChangeAmount, and Value
BackColor and ForeColor
Style
Appearance
Drawing Bar Gauge
Managing the Mouse
MouseDown
ComputeValue
MouseMove
MouseUp
Handling Keyboard Events
Modifying Bar Gauge
TicGauge
WidGauge
PicGauge
Dial
A Combined Gauge
Summary
Chapter 16—Histogram
Using Histogram
Programming Histogram
Key Techniques
Managing Control Arrays
Scrolling Data
Delegating to a Control Array
Supporting Indexed Properties
Raising Indexed Events
Summary
Part Six—ActiveX on the Web
Chapter 17—ActiveX Controls on the Web
Using ActiveX Controls on Web Pages
Key Techniques
Ensuring Safe Use
Certificate Authorities
Displaying ActiveX Controls
The OBJECT Statement
Learning Class IDs
An Example Page
Updating Labels
Selecting Colors
Loading Data Asynchronously
Loading Asynchronous Data
Loading Pictures on the Web
Summary
Chapter 18—WebSurvey
Using WebSurvey
Key Techniques
Building the Web page
Radio Buttons
Tables
Select Controls
Text Areas
Text Boxes
Check Boxes
Sending Data across the Web
InetXfer
Receiving Data across the Web
Packing and Unpacking Data
AppendSegment
RemoveSegment
Summary
Chapter 19—SiteMapper
Using SiteMapper
Key Techniques
Retrieving Web Documents
Parsing URLs
Understanding URLs
ParseURL
Expanding URLs
Mapping Web Sites
