Microsoft Mastering : Microsoft Visual Basic 6. 0 Fundamentals Book

A
ActiveX controls
    adding, 209
    using CommonDialog in, 213
    using Microsoft Windows common controls in, 210
ActiveX data objects (ADO)
    incorporating features in, 225
    relational database concepts in, 226
ADO Data controls, 223, 228
    accessing data, 228
    adding new records, 239
    binding controls, 232
    Data Form Wizard, 244
    deleting records, 241
    manipulating data, 238
    modifying and updating records, 239
    searching for records, 241
    using available bound controls, 234
    using Recordset, 238
applications
    creating, 18, 48
    creating with code, 20
arguments
    named, 77
    passing to procedures, 121
    using with MsgBox, 72
arrays, 103
    dynamic, 105
    fixed-size, 103
    multidimensional, 105
automatic code completion, 71
automatic conversion of data types, 109
AutoTab property, 261

B
bookmarks, 65
Break mode
    Debug.Assert in, 170
    setting breakpoints, 169
    Stop statements in, 169
    using in debugging, 167, 168
breakpoints, 186
button, disabling or enabling using code, 52
ButtonClick event, creating code in, 304

C
called procedure, viewing, 64
calls list, examining, 191
Call Stack, tracing program flow in, 183
class modules, 58
Clip Text property, 261
code
    adding to disable or enable a button, 52
    automatic completion features, 71
    and interacting with the user, 71
    using from the Help file, 22
    working with, 55
code documentation, 66
    adding comments to, 67
    line-continuation characters in, 66
    Visual Basic naming conventions in, 68
Code Editor window, 10, 58
    layout, 58
    Object list box, 60
    Procedure list box, 61
    Split Bar, 62
    using, 10, 58
    viewing multiple code modules, 60
code formatting, 66
    indenting, 66
    line-continuation characters in, 66
    setting options, 69
    Visual Basic naming conventions in, 68
code navigation
    and bookmarks, 65
    displaying procedures using Object Browser, 63
    and finding text, 63
    viewing a called procedure, 64
code statements, 76
    named arguments in, 77
    predefined Visual Basic constants in, 76
Code window. See Code Editor window
collection object, 334, 335
    and object variables, 336
combo box. See ComboBox
ComboBox, 198
    populating a list with, 198
    removing items from list with, 200
    seeing an example using, 201
    setting or returning current selection with, 199
    sorting the list using, 201
CommandButton, 46
comments, adding to code, 67
CommonDialog control, 213
comparison operators, 142
constants, 30, 112
control arrays, 339, 346
    creating controls dynamically in, 342
    editing active controls, 344
    and event procedures, 341
    setting volume control options in, 349
    and user interfaces, 347
    writing code for Form_Load events in, 348
control properties, 42
controls, 19, 40, 195, 196
    ActiveX, 209
    adding to forms, 41
    in collections, 334
    ComboBox, 198
    CommandButton, 46
    and file management, 206
    Frame, 203
    insertable objects, 214
    labels in, 43
    ListBox, 198
    OptionButton, 203
    selected text in, 204
    setting properties in, 42
    standard, 196, 205
    TextBox, 45
    Timer, 207
conversion functions, 110
creating programs, 14

D
Data Form Wizard, 244
    creating Customer Information Form with, 247
    creating Order Information Form with, 248
data manipulation
    adding new records, 240
    deleting records, 241
    modifying and updating records, 239
    searching for records, 241
    using ADO Data controls, 238
    using Recordsets, 238
data types
    and conversion functions, 110
    converting, 109
    and localization issues, 112
    selecting, 94
    and Visual Basic variables, 93
date function, 123
DateDiff function, 125
DateSerial function, 125
Debug window, outputting text to, 191
debugging, 165
    Break modes, 167
    Debug.Assert, 170
    Immediate windows, 176    
    outputting text to Debug window, 191
    procedures, stepping into and over, 188
    setting breakpoints, 169
    Stop statements, 169
    toolbar, 170
    tracing program flows with Call Stack, 183
    types of errors, 166
    Visual Basic tools, 185
    Watch windows, 172
default project, 365
Deployment Wizard, 368
design principles. See user interface design principles
design time, setting properties, 29
development environment, 6
development resources, 367
Dim statement, 96
displaying procedures using Object Browser, 63
distributing applications
    deploying, 359, 362
    packaging, 360
    setup files, 363
Do…Loop structures, 152, 153
drag and drop, 316, 317
    adding, 326, 328
    adding a path, 330
    changing drag icons, 322
    changing drag images, 320
    creating interfaces, 327
    dragging controls, 317
    dropping controls, 318
    mouse events in, 316
    in OLE, 323
dynamic arrays, declaring, 105

E
ending applications, 82
environment options, 68
Err object, 277
error handling, 274, 287
    creating functions, 289
    creating routines, 288
    implementing error traps, 276
    and inline errors, 280
    using different styles of, 281
error trapping
    and calling chain, 278
    Err object, 277
    and error handling, 274, 279
    general trapping options, 284
    and run-time errors, 274
errors, debugging, 166
Event-driven programming, 11
event procedures, 114
events, 33
executable files, 15
exiting loops, 156

F
field-level validation
    InputBox function, 254
    modifying keystrokes, 254
    trapping keystrokes, 255
    Validate event, 256
files    
    building executables, 15
    project, using, 15
finding text in code, 63
fixed-size arrays, declaring, 103
For…Next statement, 154
Form Designer, 8
form events, 82
    validating data in, 266
form-level validation
    for all fields, 265
    enabling OK buttons, 264
    using form-level keyboard validation, 263
form modules, 56
form variables, declaring, 102
Format function, 126
    named formats    , 127
    printing dates and times    , 127
    syntax, 126
Format property, 260
forms
    adding controls to, 41
    adding main, 86
    adding Message Box to, 89
    appearing as modal or modeless, 79
    closing, 88
    displaying, 78
    ending applications, 82, 88
    events, 39, 82
    hiding, 80
    managing, 78
    methods, 39
    setting properties in, 34, 38
    unloading, 80
    working with, 34, 55, 85
Frame control, 203
functions
    DateDiff, 125
    DateSerial, 125
    Format, 126
    writing, 134

G
general procedures, 115, 117

I
icons, adding, 53
If…Then statements, 144-47
Immediate window, 176
    examining variables in, 189
    and Locals window, 182
    running code in, 190
indenting code, 66
input validation
    adding code, 270
    verifying numeric data, 271
InputBox, 75, 254
insertable objects, 214
installing applications, 371

K
keystrokes
    KeyDown, 255
    KeyPress, 254
    KeyUp, 255

L
labels, 43
line-continuation character, 66
list box. See ListBox
ListBox, 198
    populating lists using, 198
    removing items from list using, 200
    setting or returning current selections using, 199
    sorting lists using, 201
local variables, declaring, 101
localization issues, converting data types, 112
Locals window, 182
logic errors, finding on your own, 193
logical operators, 142
logon
    creating the screen, 49
    validating information, 159
looping structures, 150
    Do…Loop, 152, 153
    exiting loops, 156
    For…Next, 156

M
Mask property, 260
Masked Edit control, 259
    AutoTab property, 261
    clearing, 262
    Format property, 260
    Mask property, 260
    Text and Text Clip properties, 261
    ValidationError event, 262
menus
    adding code to, 298
    adding items to form, 296
    creating, 294, 306
    Menu Editor, 295    
    pop-up, 299
    terminology, 294
Message Box, 89
methods, 31
Microsoft Visual Basic
    constants, 30, 76, 112
    creating applications in, 48
    creating programs in, 14, 365
    data types, 93
    development environment, using, 6
    Enterprise Edition, 4
    features of, 2
    finding reference materials in, 17
    Form Designer, using, 8
    fundamentals of, 25
    Learning Edition, 3
    naming conventions in code, 68
    Professional Edition, 4
    project types, 6
    terminology, 5
    tools for debugging, 185
modal forms, 79
modeless forms, 79
module files, 136
module variables, declaring, 102
modules
    understanding, 56
    viewing multiple code, 60
mouse events, 316
MsgBox, 72
    adding formatting to, 138
    arguments in, 72
    returned values in, 74
multidimensional arrays, 105

N
named arguments, 77
naming variables, 95

O
Object Browser, displaying procedures using, 63
Object list box, using in Code Editor window, 60
objects, 26, 28
OLE DB, 224
OptionButton, 203
Option Explicit statement, 98
options
    setting for code formatting, 69
    setting for environment, 68
order information form, using Data Form Wizard, 248

P
Package Wizard, 368
Procedure list box, using in Code Editor window, 61
procedure types, 113
procedures
    calling general, 117
    event, 114
    general, 115
    passing arguments in, 121
    stepping into and over, 188
    types of, 113
    working with, 113
    writing, 132
program execution, controlling, 141
program flow
    controlling, 158
    tracing with Call Stack, 183
programming
    procedural vs. event-driven, 11
project files, 15
Project Explorer window, 9
properties
    setting at design time, 29, 38
    setting at run time, 30
    setting for controls, 42
public variables, declaring, 102

R
reference materials, 17
removing applications, 371
returned values, using with MsgBox, 74
returning property values, 31
run time, setting properties, 30

S
scope of variables, 99
Select Case statement, 148
    using to test ranges, 149
    using to test returned values, 150
Select statement, 237
settable properties
    at design time, 34
    at run time, 34
setup programs, 369
Split Bar, using in Code Editor window, 62
SQL. See Structured Query Language (SQL)
standard controls, 198
    and file management, 206
    understanding advanced controls, 205
standard modules, 57
Standard toolbar, 10
Static variables, 101
Status bars
    adding, 309
    implementing, 301
Structured Query Language (SQL), 236
    using the Select statement, 237
Summary button, 221

T
testing ranges, using Select Case statements, 149
testing returned values using Select Case statements, 150
text, finding in code, 63
Text property, 261
text strings, manipulating, 129
text box properties, restricting data entry in, 259
TextBox, 45
time function, 123
Timer control, 207
toolbars
    adding, 310
    creating, 303
    creating code for ButtonClick event, 304
    debugging, 170
    standard, 10
Toolbox, 7

U
understanding form events, 82
unloading forms, 80
user-defined data types, 107
user interface, 217
    creating menus for, 294
    creating toolbars, 303
    creating to test functions, 133
    enhancing, 293
    implementing, 218
    implementing status bars, 301
    understanding design principles of, 352
user interface design principles
    consistency, 354
    direct user manipulation, 354
    feedback, 356
    forgiveness, 356
    minimal modal interactions, 352
    personalization support, 353
    simplicity, 355
    user assistance, 357
    user control, 352
    visual design, 357
user interaction, using dialog boxes, 71
user values, retrieving, 220

V
Validate event, 256
validation. See field-level validation
ValidationError event, 262
variables, 92
    converting data types in, 109
    creating user-defined data types in, 107
    declaring, 96, 99, 101, 102
    declaring using Static, 101
    Dim statement in, 96
    examining in Immediate window, 189
    monitoring with Watch expressions, 192
    naming, 95
    Option Explicit statement in, 98
    scope of, 99
    and selecting data types, 94
    using arrays in, 103
    and Visual Basic data types, 93
Visual Basic. See Microsoft Visual Basic

W
Watch expression
    adding, 172
    deleting, 175
    editing, 175
    monitoring variables, 192
    using Quick Watch, 176
Watch window
    using a Watch expression, 172
    using in debugging, 172