| |
| |
| Acknowledgements | |
| |
| |
| Introduction | |
| |
| |
| |
| User Interface | |
| |
| |
| |
| Getting Control of Your Form | |
| |
| |
| Centering a Form | |
| |
| |
| Two Windows APIs | |
| |
| |
| Controlling the Resizing of a Form | |
| |
| |
| Controlling the Movement of a Form | |
| |
| |
| |
| Mouse Magic with Your Form | |
| |
| |
| Subclassing Mouse Messages to Control the Resizing and Moving of a Form | |
| |
| |
| Using a Mouse to Move a Form with SendMessage | |
| |
| |
| Disabling the Close Button Without Affecting the System Menu | |
| |
| |
| Confining the Mouse to the Form | |
| |
| |
| Animating Your Cursor | |
| |
| |
| |
| Customizing the System Menu | |
| |
| |
| Deleting an Item on the System Menu | |
| |
| |
| Disabling an Item on the System Menu | |
| |
| |
| Prompting Before Executing Close Item of System Menu | |
| |
| |
| Adding an Item to the System Menu | |
| |
| |
| |
| Menu Magic | |
| |
| |
| Dynamically Resizing a Menu | |
| |
| |
| Putting Pictures on Your Menu | |
| |
| |
| Creating Designer Menus | |
| |
| |
| |
| Toolbars | |
| |
| |
| Creating a Floating Toolbar | |
| |
| |
| Creating a Docking Toolbar | |
| |
| |
| Creating a Flat Toolbar | |
| |
| |
| |
| Combo and List Boxes | |
| |
| |
| Creating a Combo Box Smart Search Feature | |
| |
| |
| Extending Smart Search Capability to the List Box | |
| |
| |
| Finding Multiple Matches in a List Box with Smart Search | |
| |
| |
| Retrieving Multiple List Selections Using SendMessage | |
| |
| |
| Creating Taller Combo Boxes | |
| |
| |
| Auto-Resizing the Combo Box Width | |
| |
| |
| |
| ActiveX Controls | |
| |
| |
| Buy vs. Build | |
| |
| |
| ActiveX--What's In a Name? | |
| |
| |
| Converting a "Smart Search" Combo Box into an ActiveX Control | |
| |
| |
| Adding Property Pages | |
| |
| |
| |
| Business Objects | |
| |
| |
| |
| The Windows Registry | |
| |
| |
| Brief (We Promise) History of the Registry | |
| |
| |
| Structure of the Registry | |
| |
| |
| Visual Basic Registry Functions | |
| |
| |
| Limitations of Visual Basic Registry Functions | |
| |
| |
| Overview of Windows API Registry Functions | |
| |
| |
| Viewing the Registry | |
| |
| |
| Writing to the Registry | |
| |
| |
| |
| Database Connectivity | |
| |
| |
| Setting Up an ODBC Data Source | |
| |
| |
| Connecting to a Database Through an ODBC Data Source | |
| |
| |
| Connecting to a Database Through a DSN-less Connection | |
| |
| |
| Creating a Recordset to Retrieve Data to a Form | |
| |
| |
| Creating a Recordset to Fill a List Box | |
| |
| |
| Creating a Recordset to Fill a Grid | |
| |
| |
| Calling a Simple Stored Procedure Using ADO | |
| |
| |
| Using Transactions with ADO | |
| |
| |
| Obtaining Database Schema Information | |
| |
| |
| |
| Manipulating Strings | |
| |
| |
| Prepare Text with Quotes | |
| |
| |
| Ensure URL Parameters Are Passed Properly | |
| |
| |
| Find and Replace a Single Character Within a String | |
| |
| |
| Find and Replace a String | |
| |
| |
| Add Leading Zeros to Numbers | |
| |
| |
| Remove Leading Zeros for Display Purposes | |
| |
| |
| Capitalize the First Character of a Sentence | |
| |
| |
| Display Currency in Words | |
| |
| |
| Prepare Text for the Internet | |
| |
| |
| Placing All the Functions in an ActiveX DLL | |
| |
| |
| |
| Manipulating Drives and Files | |
| |
| |
| Finding Out How Much Disk Space Is Free | |
| |
| |
| Finding Out If a File Exists | |
| |
| |
| Copying a File | |
| |
| |
| Copying an Entire Directory and Its Subdirectories | |
| |
| |
| Deleting an Entire Directory and Its Subdirectories | |
| |
| |
| Finding a File's Path Name | |
| |
| |
| Retrieving the Short Path Name for a File | |
| |
| |
| Retrieving the Short Name for a File | |
| |
| |
| Placing All the Functions in an ActiveX DLL | |
| |
| |
| |
| ActiveX Servers | |
| |
| |
| DLL vs. EXE, or Speed vs. Safety | |
| |
| |
| Creating a Splitter Bar ActiveX DLL | |
| |
| |
| |
| Automation Using VBA-Compliant Applications | |
| |
| |
| OLE Container Control | |
| |
| |
| Visual Basic for Applications Edition | |
| |
| |
| Referencing an Object | |
| |
| |
| Early Binding | |
| |
| |
| Late Binding | |
| |
| |
| Object Browser | |
| |
| |
| COM and DCOM | |
| |
| |
| Automation Tips | |
| |
| |
| Creating a Summary Page of Microsoft Outlook Information | |
| |
| |
| Using Microsoft Excel as a Report Writer | |
| |
| |
| Using Automation for a Mail Merge with Microsoft Word | |
| |
| |
| |
| The Internet and Distributed Computing | |
| |
| |
| |
| Internet Components | |
| |
| |
| Internet Technology Without VB | |
| |
| |
| An Extremely Simple IIS Application | |
| |
| |
| An IIS Application with Database Access | |
| |
| |
| Sequencing in IIS Applications | |
| |
| |
| Process Validation with DHTML | |
| |
| |
| |
| Integration with Microsoft Transaction Server and MSMQ | |
| |
| |
| Windows DNA | |
| |
| |
| Transaction Processing | |
| |
| |
| MTS Services | |
| |
| |
| Message Queues | |
| |
| |
| Creating an MTS Component | |
| |
| |
| Deploying an MTS Component | |
| |
| |
| Using the MTS Component from VB | |
| |
| |
| |
| Windows API and Subclassing | |
| |
| |
| Identifying Which Windows API Functions to Use | |
| |
| |
| Obtaining the Correct Syntax for Constants and Declarations | |
| |
| |
| Conditional Compilation | |
| |
| |
| Subclassing | |
| |
| |
| Index | |