Desktop Applications with Microsoft Visual Basic 6.0 MCSD Training Kit Book

A
Accessing records in Recordset, 255
Active class, 457
Active Server Pages (.asp), 394
Active window, 457
ActiveX. Also See Controls
    ActiveX Data Objects (ADO), 202, 203
    ADO data control. See ADO
    Break on Error, 347
    class modules, 179
    code components, 339
    components, 177, 457
    Controls, 47, 457
    converting a standard exe project, 387
    creating an Internet document, 386
    creating controls, 322
    creating properties, 326
    creating property pages, 327
    definition of ActiveX, 457
    document, 457
    Document Migration Wizard, 387
    documents for the Internet, 383
    external component in COM, 284
    Hide event, 386
    implementing control, 326
    Initialize event, 385
    InitProperties event, 385
    interface to OLE DB, 208-10
    OCX control, 466
    ReadProperties event, 385
    running and debugging an internet project, 391
    saving property values, 328
    Show event, 386
    siting a document, 384
    Terminate event, 386
    test application, 346
    testing code components, 346
    UserDocument event, 385
    UserDocument files, 386
    what is an ActiveX control?, 322
Add-in, 457
Address space defined, 457
AddressOf operator, 302
Administration Tools, 19
ADO
    adding records in Recordset, 228
    binding controls, 222
    checking Recordset position, 227
    coding data control, 227
    Connecting to a data source, 216
    creating Recordset property, 227
    criteria with partial values, 230
    data control overview, 215
    data link file, 216
    deleting Recordset, 228
    ODBC Data Source Name, 216
    Recordset SearchDirection, 231
    Recordset SkipRows, 231
    Recordset Start, 231
    RecordSource property, 227
    searching Recordset, 229
    setting ConnectionString, 217
    setting DataField, 222
    setting DataSource, 222
    setting RecordSource, 218
    update Recordset, 228
    using ADO, 215
    using the Data Form Wizard, 224
    verify Find Results, 230
ADO (ActiveX Data Objects), 457
ADO object model
    access records in Recordset, 255
    adding with a lock scheme, 267
    Command object, 245
    Connection events, 250
    Connection object, 244
    creating Connection object in code, 248
    data environment, 269-73
    deleting with SQL DELETE, 268
    differences from RDO and DAO, 245
    editing a Recordset, 267
    enabling events, 251
    Error collection, 246
    Explicit connection object, 254
    Field collection, 246, 256
    Filter property, 264
    finding a record, 263
    Implicit connection object, 255
    locking Recordset, 266
    modify data, 266
    navigating records, 260
    navigating Recordset, 262
    objects, 244
    overview, 244-52
    Parameters collection, 246
    Recordset object, 245
    Requery method, 261
    Resync method, 261
    retrieve data, 253
    retrieve with Command object, 256
    retrieving with Recordset, 253
    specify a cursor type property, 260
    use controls to present data, 261
    using Connection object, 247
    WithEvents keyword, 251
Affordances/Visual Clues, 33
Applet, 457
Application Structure, 10
Applications
    API (Application Programming Interface), 457
    compile, 415
    connectivity, 174
    creating an executable, 415
    defined, 457
    installing, 423
    multi-tier applications, 12
    N-tier, 466
    Online Help, 410
    single-tier applications, 11
    three-tier architecture, 470
    two-tier applications, 11
    Web deployment, 425
Argument, KeyASCII, 99
Arrays
    controls, 51-57
    defined, 457
    definition of a control array, 460
    menu control, 76
ASCII file, 458
ASP (Active Server Pages), 458
Associate, 458
Automation, 458

B
Back end, 458
Binary, 458
Break mode, 128
Browse, 458
Business services, 458
Buttons
    button objects, 65
    Call Stack, 138
    command button, 459
    on the debugging menu, 129
    Run To Cursor, 132
    Step Into, 130
    Step Out, 131
    Step Over, 131
By reference, 458
By value, 458

C
Calling
    Call Stack, 142
    Calling Chain, resume execution, 159
    CallTimer, 302
    DLLs, 300
    KillTimer, 302
    MyCallBack, 302
    Remote Procedure Call, 468
    SetTimer, 302
    Win32 APIs, 297
Centralized error handler
    creating, 164
    implementing, 164
Character code, 458
Characters, formatting, 105
Check box, 458
Checking out multiple files in VSS, 18
CHouse class, 186
Class, 458
Class builder
    creating a new class, 190
    creating class interface, 191
    loading, 190
    object models, 191
    object relationships, 192
    use of builder, 190
Class modules
    adding to a project, 179
    CHouse class use, 186
    creating, 183
    creating events, 187
    creating methods, 186
    custom events, 187
    declaring object variables, 179
    generic object variables, 181
    handling events, 188
    objects from components, 181
    property procedures, 183
    using ActiveX, 179
    using class modules, 179
    using external objects, 180
    using New Keyword, 181
    using RaiseEvent Keyword, 188
    using WithEvents Keyword, 189
Client, 458
Client object, 458
Client/server, 459
Client/server relationship in the Internet, 375
Clipboard, 459
Close, 459
CLSID (Class ID), 459
Code
    character code defined, 458
    reusing code in COM, 174, 175
    WebClass, 393, 399
Code component, 459
Collection, 459
Collections
    data source connection, 247
    Fields, 246
    Fields in object model, 256
    Parameters, 246
Color
    CHouse class, 186
    visual appeal, 34
COM (Component Object Model), 459
Command button, 459
Commands in Visual SourceSafe
    Check In, 16
    Check Out, 16
    Get Latest Version, 16
    Undo Check Out, 16
Compile
    Allow Unrounded Floating-Point Operations, 419
    Assume No Aliasing option, 418
    compiler options, 415
    conditional compilation, 420
    conditional compilation constants, 421
    create an executable, 415
    Create Symbolic Debug Info, 417
    native code, 415
    No optimizations, 417
    optimize for Fast Code, 417
    optimize for Small Code, 417
    optimizing with Favor Pentium Pro, 417
    P-code (pseudo code), 415
    Project properties, 421
    Remove Array Bounds Checks, 418
    Remove Floating-Point Error Checks, 419
    Remove Integer-Overflow checks, 418
    Remove Safe Pentium FDIV Checks, 419
    using Start with Full Compile, 348
Component defined, 459
Component Object Model (COM)
    active documents, 177
    ActiveX Code components, 339
    ActiveX components, 177
    ActiveX Control as a data source, 333
    ActiveX controls, 175, 177
    AddressOf operator, 302
    automation of components, 289
    Break in Class Module, 347
    Break on All Errors, 347
    Break on Error, 347
    Break on Unhandled Errors, 347
    callback procedures, 301
    calling DLLs, 300
    calling Win32 APIs, 297
    class builder, 190-93
    class modules, 176, 179-89
    component project templates, 320
    connecting to components, 284
    constituent controls, 323
    control classes, 323
    create ActiveX property pages, 327
    create property, 326
    create test application, 346
    CreateObject function, 292
    creating ActiveX controls, 322
    creating class module events, 187
    creating components, 177, 318
    creating methods, 186
    declaring custom events, 187
    declaring DLLs, 299
    declaring object variables, 290
    default property values, 329
    dependent objects (PublicNotCreatable), 344
    designing components, 318
    early binding, 290
    Error Trapping option, 347
    extend application with Win32 API, 298
    externally creatable objects, 345
    files associated with User Control, 324
    function pointer, 301
    GetObject function, 291
    GlobalMultiUse property value, 343
    GlobalSingleUse property value, 344
    handling events, 188
    implementing ActiveX Control, 326
    initializing property values, 329
    in-process components, 318
    In-Process vs. Out-of-Process, 319-20
    Instancing property of a class, 343
    instantiating an object, 291
    instantiation process, 289
    late binding, 290
    managing components, 289
    MultiUse and Multithreading, 345
    MultiUse property value, 343
    MultiUse vs SingleUse, 345
    New Keyword with a statement, 292
    object browser, 295, 348
    object programming, 175
    OOP tool, 175
    out-of-process components, 318
    overview, 174
    PublicNotCreatable property value, 343
    reading property values, 329
    registering a component, 284
    Regsvr 32 utility, 285
    reusing code, 174, 175
    save property values, 328
    setting references using type libraries, 287
    shutting down component, 348
    SingleUse property value, 344
    testing and debugging code components, 346
    thread, 319
    type libraries, 286
    using CHouse Class, 186
    Using Start with Full Compile, 348
    using Win32 API, 297
    Visual Basic, 176
    Visual Component Manager, 350-58
    Win32 DLLs, 297
    working with other software, 174
    WriteProperty method in WriteProperties event, 328
Components in COM. See Component Object Model (COM)
Components of Visual SourceSafe, 15
Composition
    overview, 31
    simplicity is the key, 31
Compound document, 459
Concepts, relational database, 204
Connecting to a Data Source, 216
Connection object created in code, 248
Consistency, 32
Constituent controls, 323
Container, 459
Context menu, 459
Context-sensitive help, 460
Controls
    ActiveX Control as a data source, 333
    ActiveX in class modules, 179
    ActiveX in COM, 175, 177
    add using the Add Method, 57
    adding custom controls, 48
    avoid overuse of controls, 33
    binding controls, 222
    coding control arrays, 53
    Constituent, 323
    control classes, 323
    controls arrays, 51
    creating at run time, 54
    creating COM ActiveX controls, 322
    creating error handler, 154
    creating properties for ActiveX, 326
    creating property pages for ActiveX, 327
    data access interface, 202
    defining Mask Edit, 109
    definition of a control, 460
    definition of a control array, 460
    ImageList, 61
    importance of positioning, 32
    input for form-level validation, 100
    ListView, 64
    Load statement, 54
    Masked Edit, 108
    menus and control arrays, 76
    removing, 49
    saving ActiveX property values, 328
    setting properties, 49
    StatusBar, 66
    textbox control properties, 104
    ToolBar, 65
    TreeView, 62
    Unload statement, 55
    User Control, 324
    using the controls collection, 58
    working with controls, 47
Cookie, 460
Create an instance, 460
Cursor, 460

D
Data access in Visual Basic, 202
Data Access Objects (DAO), 202, 460
Data control, 460
Data environment, 269
    create a connection, 269
    presenting records, 270
Data Form Wizard, 224
Data restriction, 108
Data services, 460
Data source, 460
Data Source Name (DSN), 460
Data type, 460
Data-aware, 460
Database, 19
    definition of a database, 460
    file-based, 462
    Open Database Connectivity (ODBC), 467
Database management and SQL, 204
DBMS (Database Management System), 460
DCOM (Distributed Component Object Model), 461
Debug object
    Debug.Assert, 137
    Debug.Print, 137
Debugging, 126
    ActiveX code components, 346
    an ActiveX document project, 391
    Break Mode, 128
    Create Symbolic Debug Info, 417
    Debug Object, 137
    debug the application, 126
    errors, 126-28
    IIS application, 399
    menu, 128
    Run To Cursor button, 132
    Set Next Statement, 132
    Show Next Statement, 132
    Step Into button, 130
    Step Out button, 131
    Step Over button, 131
    types of errors, 126
Default, 461
Delimiter, 461
Design
    building a design, 4
    COM components, 318
    conceptual design, 4, 459
    goals, 5
    logical design, 4, 465
    logical process, 7
    logically addressing problems, 6
    physical design, 5, 467
    principles, 30
    solutions, 3
Developer's Role, 6
DHTML
    advantages, 377
    DHTML applications, 375-82
    modifying HTML, 378
    Page Designer, 377
Dialog box, 461
DLL
    calling DLLs, 300
    declaring DLLs, 299
    definition of the dynamic-link library, 461
    GDI32, 298
    Kernel32, 298
    use in a multi-tier system, 13
    use in a two-tier system, 11
    User32, 298
    Win32 and COM components, 297
Document
    ActiveX, 457
    compound, 459
    multiple document interface, 465
    single document interface, 469
Document Migration Wizard, 387
Dynamic-link library. See DLL

E
Early binding, 461
Embedded object, 461
Encapsulation, 461
Enumerator tracks collection items, 44
Err.HelpFile properties, 411
Error handler
    Break in Class Module, 160
    Break on All Errors, 160
    Break on Unhandled Errors, 161
    centralized error handling, 164-65
    creating, 154
    disabling, 159
    enabling an error handler, 154
    Err object, 155
    handling errors, 155
    inline error handling, 162-63
    local error handler, 154
    options in Visual Basic, 160
    resume execution, 156
    use On Error GoTo statement, 154
    Visual Basic handles run-time error, 154
Error statement, 461
Error trapping, 461
Error trapping options
    Break in Class Module, 160, 347
    Break on All Errors, 160, 347
    Break on Error, 347
    Break on Unhandled Errors, 161, 347
Error-handling routine, 461
Errors
    Break on Error, 347
    centralized error handling, 164-65
    clearing inline Err object, 163
    debugging, 126
    disabling inline handler, 163
    error handler, 154-56
    error trapping, 347
    Errors-Calling Chain, 158
    handling run-time errors, 154
    identify logical errors, 128
    inline error handling, 162-63
    local error handler, 154
    logic, 128
    resume execution from Calling Chain, 159
    run-time, 127
    shutting down In-Process component, 348
    syntax, 126
    use On Error GoTo statement, 154
Event
    definition of an event, 462
    event-driven, 462
    procedures, 462
Event procedures
    Activate/Deactivate, 40
    Change, 106
    class builder, 190
    class modules handling, 188
    Connection events, 250
    custom events, 187
    definition of an event procedure, 462
    enabling ADO events, 251
    GotFocus, 96
    Hide, 386
    how they are used in forms, 38
    in class modules, 187
    Initialize, 39, 385
    InitProperties, 329, 385
    KeyDown & KeyUp, 99
    KeyDown & KeyUp events, 105
    KeyPress, 99
    KeyPress event, 105
    Load, 40
    LostFocus, 96, 97
    QueryUnload, 40
    ReadProperties, 385
    Show, 386
    siting ActiveX documents, 384
    Terminate, 41
    Terminate, 386
    Unload, 41
    UserDocument, 385
    Validate, 111
    WriteProperties, 328
Executable file, creating, 415
Expressions
    adding Watch expressions, 140
    column, 139
    edit/delete Watch expressions, 141
    identifying Watch types, 141
    Quick Watch, 141
    setting Watch expressions, 139
    test & evaluate, 134
Extension, 462

F
Field-Level validation
    AutoTab property, 110
    CausesValidation property, 111
    Change event, 106
    description, 95
    display & print control contents, 110
    events, 105
    Format property, 110
    formatting/validating characters, 105
    Mask Edit control, 109
    Mask property, 109
    Masked Edit control, 108
    PasswordChar property, 105
    setting Locked property, 105
    setting MaxLength property, 104
    Text and Clip Text property, 110
    textbox control properties, 104
    Validate event, 111
    validating data when entered, 104
    validation functions, 108
Fields in a relational database, 205
File-based database, 462
Files
    Active Server Pages (.asp), 394
    archiving projects, 20
    ASCII file, 458
    associated with User Control, 324
    branching and sharing files, 17
    Cabinet files, 423
    definition of a text file, 470
    file extensions, 462
&