Click here for ObjectSpace: Business- to- Business Integration Company
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Visual Basic 6 Programming Blue Book: The Most Complete, Hands-On Resource for Writing Programs with Microsoft Visual Basic 6!
(Publisher: The Coriolis Group)
Author(s): Peter G. Aitken
ISBN: 1576102815
Publication Date: 08/01/98

Bookmark It

Search this book:
 
Previous Table of Contents Next


Index

Symbols
& (ampersand)
access key specifier, 53
long type declaration character, 67
string concatenation operator, 81
* (asterisk)
multiplication operator, 59, 80
wildcard character, 370
@ (at sign)
currency type declaration character, 67
\ (backslash)
integer division, 80
^ (caret)
exponentiation operator, 80
, (comma)
field delimiter, 351
location of Print # statement, 353–355
“ (double quotation mark)
field delimiter, 351
E+ characters, format specifier, 111
= (equal sign)
assignment operator, 58
“equal to” comparison operator, 83
! (exclamation point)
single type declaration character, 67
> “greater than” comparison operator, 83
>= “greater than or equal to” comparison operator, 83
< “less than” comparison operator, 83
<= “less than or equal to” comparison operator, 83
- (minus sign)
subtraction operator, 80
<> “not equal to” comparison operator, 83
% (percent sign)
integer type declaration character, 67
+ (plus sign)
addition operator, 80
string concatenation operator, Basic, 81
# (pound sign)
double type declaration character, 67
format specifier, 111
? (question mark)
wildcard character, 370
; (semicolon)
location of Print # statement, 353–355
Print method modifier, 335
/ (slash)
division operator, 80
_ (space+underscore)
line continuation character, 85
0 (zero character)
format specifier, 111
A
Abs function, 111
Absolute coordinates, 332
Accessing Windows API, 666–668
Access keys, menu items, 267
AccessType property, 486
Activating OLE objects, 241
ActiveForm property, 298
ActiveX, 183–197
class module, 184–185
and client/server applications, 622–623
project types, 134
vs. DDE, 201
ActiveX class, 185
ActiveX client, 185
ActiveX component, 136
ActiveX control events, 445–448
ActiveX Control Lister (ACLIST), 461–462
ActiveX controls, 8–9, 47–48, 159, 438–462
See also Custom controls.
adding a property page, 454–458
adding properties, 452–453
compiling, 458–459
creating, 439–443
distributing, 460
project type, 134
responding to events, 448–452
running at design time, 444–445
testing, 443
testing options, 452
using in other projects, 459–460
using on the Web, 460–462
ActiveX Data Objects. See ADO.
ActiveX DLL project type, 134
ActiveX DLLs (Dynamic Link Libraries), 623
ActiveX Document DLL project type, 134
ActiveX Document EXE project type, 134
ActiveX EXE, 623
creating, 196–197
project type, 134
ActiveX object, 185
ActiveX server, 185–196
ActiveX server types, 623–624
Adding
buttons to Toolbars, 579–581
Command Buttons, 29, 103–105
images to ImageList control, 160–161
Label controls, 24–25
menus, 266–269
property procedures, 189
Addin project type, 134
Addition operator (+), 80
Additive primary colors, 325
AddNew method, 519
ADDRESS demonstration project, 493–507
adding a basic module, 496–497
chameleon command buttons, 498–502
designing the form, 494–496
initializing the program, 502–505
List form, 506–507
planning the database, 493–494
using multiple forms, 497–498
Adjusting. See Changing.
ADO (ActiveX Data Objects), 532–533, 534
Data control, 533, 547
and data-aware controls, 548
error numbers, 598
model, 545–547
in designing a relational database application, 551–555
objects, 545–547
ADO Data control, 603
ADO Data control properties, 603
Algebraic logic, 95–96
Alias for DLL procedures, 668
Alias keyword, 668
Align command, 44
Aligning
controls, 44–45, 46
text, 670–671
Alignment setting, 102
Align property, 575
ALIGNTXT demonstration project, 670–675
AllowCustomize property, 576
AllowZeroLength property, 566
And (logical operator), 84
Animations, simple, creating, 318–321
ANSI, 357
ANSI codes, 596
API (Applications Programming Interface), 533
See also Windows API.
Text Viewer, 416
Applications
decision-support, 542
deploying, 661–663
packaging, 659–661
transaction-processing, 542–543
Applications framework, 6–7
Applications Programming Interface. See API.
Application Wizard, 128–129, 134
Apply button, property page, 456
ApplyChanges event, 457
Architecture
centralized, 618
file server, 618, 620
Arguments, 110
Arithmetic operators, 80–82
Array index, 72
Arrays, 72–76
ASCII codes, 596
ASCII files, 264, 357
Assigning unused error number, 641–642
Assignment operator (=), 58, 79
Asterisk (*), multiplication operator, 59, 80
Asynchronous communications ports, 400
AtEndOfLine property, 358
AtEndOfStream property, 358
Atomic data, 553–554
Attribute classes, 538
Attributes property, 382–384
AutoActivate property, 241
AutoEnable property, 427
Automatic link update, 202
Automatic object references, 307
Automation Manager, 625
AutoRedraw property, 304
AvailableSpace property, 375
B
Baby Editor project, 263–289
code writing, 271–289
planning, 264–265
visual design, 265–270
BackColor property, 43, 337
Back end, 530
BackStyle property, 337
.BAS file extension, 39
Basic modules, adding to database programs, 496–497
Basic procedure, 32–33
Basic statements. See Statements.
Baud rate, 403
Baud rate parameter, 400
Binary access files, 345
Binary access mode, when to use, 367–368
Binary files
reading and writing data, 365–367
using, 364–367
Binary search algorithm, 540
Binding, 548
Bitmap image format, 309
Bitmap pictures, displaying, 324
.BMP file extension, 309
Bookmark property, 522
Boolean data type, 83
Boolean variable, 102
Boolean variable type, 68, 70
BorderColor property, 337
BorderStyle property, 43, 102, 302, 337
BorderWidth property, 337
Bound, 548
BoundText properties, 603
Break mode, 650
and callback function, 677
and Immediate window, 655
Breakpoints, 649–650
Bugs, 648
Built-in collections, 157–159
Business rules, 620–621
ButtonClick event, 429, 580
ButtonCompleted event, 429–430
ButtonEnabled property, 427
ButtonGotFocus event, 429
ButtonHeight property, 576
ButtonLostFocus event, 429
Button object properties, 578–579
Button property, 575
Buttons collection, 576–577
Buttons tab, 575–576, 577–579
ButtonWidth property, 576
Byte numeric variable type, 64–65
Byte variable type, 68
C
Calculator project, 95–124
creating the calculator, 100–119
enhancing the calculator, 119–124
planning, 95–100
visual interface, 102–105
writing the code, 105–124
Callback API function, 675–680
Callback demonstration project, 678–680
Callback function, 417
Callback function
and break mode, 677
Call statement, 666–667
CanEject property, 427
CanPlay property, 427
CanRecord property, 427
CanStep property, 427
Capability command, 420
Caption property, 26, 29, 43, 52–53, 499, 578
Captions, changing, 29
CausesValidation property, 571–572, 597
Centralized architecture, 618
Changed property, 456–457
Change event, 35, 386–387
Changing
to another drive, 371
to another folder, 371
button fonts, 104–105
captions, 29
Font property, 51
form position, 42–44
form size, 29, 42–44
multiple controls, 45
position of controls, 43–45
properties, 26, 42–43
shape of controls, 24–25
size of controls, 24–25, 43–45, 46, 58–59
text properties, 49–51
value of any variables and properties, 655
ChDir statement, 371
ChDrive statement, 371
Check Box control, 47, 549
Checked property, 270
Child forms, MDI, 295–296, 574–575
Child nodes, 162
Chr$ function, 279, 596
Circle method, 306–307, 329–330
CIRCLES demonstration project, 330
Class Builder utility, 139–147
Classes, 7, 138–151
See also Components; Objects.
Collection, 153–159
demonstration project, 139–147
FileSystemObject (FSO), 355–359
OLE object, 229–230
relationship to objects, 139
Class_Initialize procedure, 190
Class Module Builder dialog box, 139–140
Class modules, 184–185
properties, 186–187
Class property, 230
Class_Terminate procedure, 190
Click event, 217, 314
Client, 530
Client application, 229
Client registration utility, 624
Client/server architecture, 620
Client/server databases, 543
Client/server models, 619–622
Client/server programming, 617–627
Clipboard
copying to, 123
and creating DDE links, 206–209
data formats, 207
Clipboard.GetText, 274
Clipboard object, 123, 207–209, 273–275
Clipboard.SetText, 274
Close command, 415
Close method, 359
Close statement, 348
Closing, files, 348
.CLS file extension, 187
Code
Basic, 14
connecting to the interface, 33–36
viewing, 33, 35
writing, 31–33
Code editing mode, 31
Code Editing window, 33, 35
Code module, 29
Codes
module level, 108, 127
procedure level, 108, 127
CollatingOrder property, 567
Collection class, 153–159
Collection object, creating, 154
Collections
built-in, 157–159
Buttons, 576–577
ColumnHeaders, 179–180
Columns, 550
Controls, 157–158
Drives, 375–377
Errors, 546
Fields, 546
Folders, 375
Forms, 157–158
ListImages, 160
ListItems, 178
Nodes, 162–163
Parameters, 546
Printers, 157, 341
Properties, 546
SelectedControls, 456
Colors
dithering, 329
inverting, 324
RGB function, 325–329
RGB values, 324
specifying, 325
text, 54, 57–58
COLORS demonstration project, 326–329
ColumnHeaders collection, 179–180
Column property, 358
Columns collection, 550
Combo Box control, 47, 549, 584–586
COM (Component Object Model), 184
and client/server applications, 622–623
interfaces, 532
ComEvEOF event constant, 406
ComEvReceive event constant, 406
ComEvRing event constant, 406
ComEvSend event constant, 406
Command argument, to DDE source application, 220
Command Button control, 23, 46
Command buttons
adding, 29, 103–105
chameleon, in a database program, 498–502
Command object, 532, 545
Command property, 427
Commands
Align, 44
Capability, 420
Close, 415
Components, 135–137
GET, 470–471
HEAD, 470
MCI, 414–416
MCI button, 428–429
modem, 409
Paste Link, 209–213
Paste Special, 235–236
POST, 470
PUT, 470
References, 137–138
Seek, 419
sending to another program, 220
Step, 656
Comm control, 401–409
properties, 402–405
COMMDEMO demonstration project, 406–409
Comments, 77
CommEvent property, 405
Common controls, Windows, 159–181
Common Dialog controls, 277–281
opening files, 278–281
Printers, 341
selecting fonts, 287–289
ShowSave method, 283
CommPort property, 403
Communication control. See Comm control.
Communication events, 406
Comparison expression, 87
Comparison operators, 83–84, 85
Compiling, 125–127
ActiveX controls, 458–459
to Native-code, 126–127
to P-code, 126
Component Object Model. See COM.
Components, 7–9, 133–151
See also Classes; Objects.
availability, 137–138
exposed, 135
registering, 196
types, 136–137
Components command, 135–137
COM ports, 400
Compound keys, 554
Compound primary keys, 538
Concatenation operator, 80–81
Connection object, 532, 545
ConnectionString property, 611
Connection string syntax, 611
Constants, 64, 76–77, 100–102
global, related to DDE, 208
intrinsic, 161
to test for buttons and shift keys, 314–315
Container applications
OLE terminology, 229–233
Container property, 299
Context and watch expressions, 653–654
Control arrays, 119
Index argument, 103, 106
Control component, 136
Control names, referring to a different form, 525
Controls, 9, 22
ActiveX, 8–9, 47–48, 159, 438–462, 458–459 (See also Controls/custom)
adding labels, 24–25
ADO Data, 533, 547, 548, 603
aligning, 44–45, 46
available, 48
binding to the data table, 518–519
changing position, 43–45
changing properties, 26
changing shapes, 24–25
changing size, 24–25, 43–45, 46, 58–59
Check Box, 47, 549
Combo Box, 47, 549, 584–586
Comm, 401–409
Command Button, 23, 29, 46
Common Dialog, 277–281, 283, 287–289, 341
as containers, 300
custom, 8–9, 47–48 (See also Controls/ActiveX)
Data, 509–511
Data-aware, 510–511, 548–550
Data-bound, 510
DataCombo, 550
DataGrid, 549–550, 586
DataList, 550, 603–606
deleting, 43
DirListBox, 386
DriveListBox, 387
Enterprise Edition, 135
FileListBox, 384–385
file-related, 384–397
fixed-sized, 302
Frame, 51–52
Image, 318, 319, 549
ImageList, 160–161
Label, 23, 24–25, 47, 549
Line, 336–337
List Box, 47, 549
ListView, 178–181
locking, 46
MaskedEdit, 549
MSComm (See Controls/Comm)
Multimedia, 426–434
multiple selected, dealing with, 456
names, 42
OCX, 438
OCX files, 137
OLE, 549
OLE container, 232
Option Button, 47
overlapped, 45–46
Picture Box, 47, 308–318, 549
PictureClip, 321–324
placement on forms, 41–42
Printers Common Dialog, 341
RemoteData, 534
RichTextBox, 549
selecting, 43
setting size and positions, 301
Shape, 337
TabStrip, 173–177
Text Box, 23, 26–29, 47, 549
Timer, 320, 422
TreeView, 161–173
WebBrowser, 487–488
Controls collection, 157–158
Conversations, DDE, 201–202
Coordinates, 332–333
Coordinate system, 295–296
CopyFolder method, 377
COPYLINK demonstration project, 216–218
Copy method, 377, 383
Counter numeric variable, 88–89
CreateEmbed method, 237–238
CreateLink method, 237–238
Creating
ActiveX controls, 439–443
ActiveX EXE programs, 196–197
classes, 138–139
collection objects, 154
embedded objects, 237–238
executable files, 124–127
file objects, 381–382
folders, 371
MDI forms, 574
multipage dialog boxes, 173–177
objects, 148–149
procedures, 109–112
Setup programs, 657–658
simple animations, 318–321
toolbars, 574
CRLF (carriage return line feed) combination, 279–280
field delimiter, 351
CurDir function, 371
.CUR file extension, 309
Currency numeric variable type, 64–65
CurrentX property, 332–333
CurrentY property, 332–333
Cursor, 530
image format, 309
Custom controls, 8–9, 47–48
See also ActiveX controls.
Common Dialog, 277–281
Custom coordinates, defining, 305–308
CVErr function, 643–644
D
DAO (Data Access Objects), 533–534
Data
atomic, 553–554
sending to another program, 220–221
Data Access Objects. See DAO.
Data arrays, 119
Data-aware controls, 510–511, 548–550
Database development tools, 545–550
Database engine errors, using, 597–598
Database management system. See DBMS.
DatabaseName property, 518
Database programming terminology, 538–539
Database programs, initializing, 502–505
Databases
accessing without ADO Data control, 547
client/server, 543
creating at runtime, 548
creating using Visual Data Manager, 511–516
defined, 492
development of, advantages of Visual Basic, 544
flat file, 536
front end applications, 541–543
legacy, 544
multiuser, 619
relational, 536–540
relational, designing the application, 551–555
relational vs. flat file, 536–538
supported file formats, 508
validation methods, 595–599
Database tables
defining the structure, 514
extracting information, 541
modifying, 515
Database terminology, 529–534
Database tools, 507–527
Data-bound controls, 510
DataCombo control, 550
Data control, 509–511
ADO, 533
DataField property, 518, 548
DataGrid control, 549–550, 586
DataList control, 550, 603–606
Data loss, preventing, 276–277
Data object model, 545–547
Data Project, 134
Data source, 530
DataSource property, 518, 548
DataUpdatable property, 567
DateCreated property, 378, 383
DateLastAccessed property, 378, 383
DateLastModified property, 378, 383
Date variable type, 68, 70
DBMS (Database management system), 619–620
DCOM (Distributed Component Object Model), 623
DDE conversation, 201–202
DDE (Dynamic Data Exchange), 199–225
and objects, 202–204
terminology, 201–202
transferring data, 219–225
vs. ActiveX, 201
vs. OLE, 201, 231–232
DDE events, 204–206
DDE links, 200–202, 207–218
information, 207–209
copying to Clipboard, 215–216
initiating, 203–204
updating, 202
using Clipboard, 206–209
Debugging programs, 647–656
controlling execution during, 656
Debug menu, 656
Debug.Print method, 99, 119
Debug.Print statement, 649
Decision structures, 85–87
Decision-support applications, 542
Declare statement, 667–669
keyword components, 668–669
Declaring
API functions as procedures, 669–670
constants, 100–102
public variables, 100–102
variables, 67–70, 187
DefaultValue property, 567
Deferring error trapping, 639–640
Delete method, 378, 383, 519
Deleting
files, 370
folders, 370
Demonstration projects
ActiveX server, 185–196
ADDRESS, 493–507
Baby Editor, 263–289
Calculator, 95–124
callback, 678–680
CIRCLES, 330
classes, 139–147
COLORS, 326–329
COMMDEMO, 406–409
COPYLINK, 216–218
DRIVESDEMO, 376–377
FancyCmdButton, 439–460
FINDFILE, 387–397
FOLDERDEMO, 378–381
FRONTEND, 221–225
FSODEMO, 359–361
GRAPEVINE, 556–563
ITC_DEMO, 471–475
mortgage calculator, 22–36
MUSIC, 511–527
OLE automation with embedded objects, 255–259
OLE automation with nonembedded objects, 253–255
OLE container application, 242–248
PAINTPIC, 312–318
Paste Link, 209–213
PICTURECLIP, 322–324
PICTUREDEMO, 318–321
Playing with Properties, 49–60
PRINT1, 339–340
Screen display, 300–302
SOUND1, 421–425
SOUND2, 431–434
SuperString class, 147–151
Text box project, 49–60
TreeView control, 167–173
Windows API, 670–675
Dependent tables, 539
Deploying your applications, 661–663
Description property, 578
Designer, 49
Designer component, 136
Design grid, 44
Design-time, 10
Destination application, 201–202, 229
Destination control properties, 202–204
DHTML application, 134
Dialog boxes, New Project, 18, 38–39
.DIB file extension, 309
Dim keyword, 497
Dim statement, 67, 127, 148
Directory List Box, 386
Dir function, 373
DirListBox control, 386
Disabling menu items, 275–276
DISPLAY_FORMAT constants, 101
DisplayHasData flag, 107
Displaying
bitmap pictures, 324
events associated with forms, 303–304
metafile pictures, 324
text, 334–336
DisplayResult procedure, 109–112
Distributed Component Object Model. See DCOM.
Distributing programs, 656–663
Dithering colors, 329
Division operator (/), 80
DLL files, 136
DLL procedure alias, 668
DLL procedure names, 668
DLLs (Dynamic link libraries), 666
Document property, 486
Do...Loop, 89–91
Done event, 430
Double numeric variable type, 64–65
Drag-and-drop
inserting objects, 239
DragDrop event, 428
DragOver event, 428
DrawMode property, 333–334, 337
DrawStyle property, 333
DriveLetter property, 375
DriveListBox control, 387
Drive object, 374–377
Drive object properties, 375–376
Drive property, 378, 383, 387
Drives collection, 375–377
DRIVESDEMO demonstration project, 376–377
DriveType property, 375
DropHighlight property, 165
Dynamic arrays, 75–76
Dynamic Data Exchange. See DDE.
Dynamic link libraries (DLLs). See DLLs.
Dynaset-type Recordset, 520–521
E
Early binding, 148
Elseif keyword, 86
Else keyword, 86
Embedded objects, creating, 237–238
.EMF file extension, 309
Empty value, 98
Enabled property, 270, 275, 427, 576, 578
Enabling menu items, 275–276
Encapsulation, 143
End of file detection, 280, 352–353
End statement, 34, 56–57, 501
Enterprise Edition controls, 135
Entity, 538
Entity class, 538
Entity occurrences, 538
Enum...End Enum statement, 78, 252
Enums, 78–79, 252
EnumWindows API function, 676
EnumWindows API procedure, 678–679
EOF function, 280, 352–353
Eqv (logical operator), 84
ERR object, 636–639, 640
ERR object properties, 636–639
Error-handling codes, 644–645
ErrorMessage property, 431
Error number, assigning unused, 641–642
Error object, 546
Error property, 431
Errors
raising, 640–641
returning from functions, 643–644
runtime, handling, 631–645
syntax, 631–632
trapping, 633–635
user-defined, 641–644
Errors, ITC, 471
Errors collection, 546
Error trapping, deferring, 639–640
Error value, 98
Event detection, 12, 22
Event-driven communication, 402
Event-driven programming, 10
Event handler. See Event-handling procedures.
Event-handling procedures, 12–13, 34, 35–36, 56–59
See also Events.
names, 12, 35–36, 57
Event procedures. See Event-handling procedures; Events.
Events, 10–13
See also Event-handling procedures.
ActiveX control, 445–448
ApplyChanges, 457
associated with loading, showing, sizing and unloading forms, 304
ButtonClick, 429, 580
ButtonCompleted, 429–430
ButtonGotFocus, 429
ButtonLostFocus, 429
Change, 35, 386–387
Click, 217, 314
communication, 406
DDE, 204–206
Done, 430
DragDrop, 428
DragOver, 428
FileListBox, 385
Form_Resize, 272, 301–302
icResponseCompleted, 469–470
icResponseReceived, 469–470
Initialize, 147, 447
InitProperties, 447
KeyPress, 596
LinkClose, 205
LinkError, 205
LinkExecute, 206
LinkNotify, 205
LinkOpen, 204–205
Load, 300, 506
LostFocus, 597
MouseDown, 313–314
MouseUp, 314
Multimedia control, 428–430
OnComm, 405–406
Paint, 304, 447
PathChange, 385
PlayCompleted, 429
QueryUnload, 501
ReadProperties, 447
Resize, 447
SelectionChanged, 455
StateChanged, 466–468
StatusUpdate, 430
Terminate, 447
Unload, 501
Validate, 571–573, 597, 600
WriteProperties, 447
Execute method, 470–471, 476–478
EXEName property, 214
Exit For statement, 89
Exponentiation operator (^), 80
Exposed components, 135
Expression, 80
F
FancyCmdButton demonstration project, 439–460
Field object, 545
Field properties, 565–569
Fields, 538
database, 492
repeating, 558–560
in sequential files, 349–352
Fields collection, 546
File access
modes, when to use, 367–368
types, 344–346
FileAttr function, 373–374
File extensions
.BAS, 39
.BMP, 309
.CLS, 187
.CUR, 309
.DIB, 309
.DLL, 136
.EMF, 309
.FRM, 39
.GIF, 309
.ICO, 309
.JPEG, 309
.JPG, 309
.OCX, 48, 136
.TXT, 264
.VBP, 40
.WMF, 309
FileListBox control, 384–385
FileListBox events, 385
File management statements, 370–374
Filename property, 385
File numbers, 346–348
File objects, 374, 381–384
File pointer, 364–365
File position, 364–365
File-related controls, 384–397
demonstration project, 387–397
Files
closing, 348
deleting, 370
executable, creating, 124–127
finding, 373–374
new, starting, 281–282
opening, 278–281, 346
saving, 282–287
Files collection, 375, 377, 382
File server architecture, 618, 620
Files property, 378
FileSystemObject (FSO), 355–359
FileSystem property, 375
File Transfer Protocol. See FTP.
File types
restricting listing, 278
FillColor property, 337
FillStyle property, 337
Filter property, 278–279
FINDFILE demonstration project, 387–397
creating the form, 388–390
exploring the recursive algorithm, 395–397
writing the code, 390–395
FindFirst method, 522
FindLast method, 522
FindNext method, 522
FindRecord procedure, 521–522
Fixed-length strings, 69
Fixed-sized controls, 302
Flags, 83, 102
DisplayHasData, 107
Flags property, selecting fonts, 287
Flat file databases, 536
Floating point numbers, 64–65
FOLDERDEMO demonstration project, 378–381
Folder object, 374–375, 377–381
properties, 378
Folders
creating, 371
deleting, 370
Folders collection, 375
Font property, 51, 104–105
Fonts
changing properties, 51
selecting, 287–289
For Each...Next statement, 156
ForeColor property, 43, 54, 57–58
Foreign keys, 539
Format function, 111
Format specifier string, 111
Form design mode, 31
Form Design window, 20
Form Editor toolbar, 46
Form Grid Settings, 44
Form Layout window, 21
Form_Load events
Baby Editor project, 271–272
Form module, 39
Form_Resize events, 272, 301–302
Forms, 9, 22 See also Windows (screen); individual form names.
adding to an existing project, 290
adjusting sizes, 29
changing caption, 29
changing size and position, 42–44
controls placement, 41–42
displaying associated events, 303–304
hiding, 291
loading associated events, 303–304
MDI, 574–575
multiple, 289–293
non-MDI, 574
Picture Box, multiple, 574–575
properties, 42–43
saving, 30
Forms collection, 157–158
For...Next loop, 88–89, 306
Frame control, 51–52
Frame objects, 176–177
Framework, applications, 6–7
FreeSpace property, 375
.FRM file extension, 39
Front end. See Client.
FRONTEND demonstration project, 221–225
FSODEMO demonstration project, 359–361
FSO file management, 374–384
FSO text file access, 355–359
FTP_DEMO demonstration project, 478–486
FTP (File Transfer Protocol), 464, 475–487
commands, 477–478
FTP Logons, 475–476
Full-module view, 35
Function pointer, 676
Function procedures, 284–285
Functions, 108–109
callback, 675–680
Callback, 417
Chr$, 279, 596
CurDir, 371
CVErr, 643–644
EOF, 280, 352–353
FileAttr, 373–374
InputBox, 522
QBColor, 325
Seek, 364–365
string processing, 293
G
General Button tab, 575–576
General error-handling code, 644–645
General procedures. See Procedures.
GetChunk method, 468–470, 477
GetClassName API function, 678
GET command, 470–471
GetFile method, 381
GetFormat method, 207–208
Get statement, 363–364, 365
GetText method, 108
GetWindowsText API function, 678
GetWindowTextLength API function, 679
.GIF file extension, 309
Global keyword, 128
Global variables. See Public variables.
GRAPEVINE demonstration project, 556–563, 567–593, 598–616
completing the Invoices form, 613–615
connecting to the Invoices table, 610–613
connecting to the Items table, 606–607
creating the database, 560–563
data validation, 598–601
designing tables, 557–558
designing the Customers form, 581–584
designing the List form, 586
designing the Wines form, 584–586
entering orders, 601–602
fundamental program structure, 573–574
Invoices form, 601–606
preliminary form design, 574–586
repeating fields, 558–560
Select Wine form, 607–610
setting field properties, 567–569
writing the code, 586–593
Grid of cells, 549
H
Handles, 24, 42
HEAD command, 470
Height property, 298–299
Hide method, 291, 303
HTML (Hypertext Markup Language), 464–465
HTTP (Hypertext Transfer Protocol), defined, 464–465
Hungarian notation, 66
Hypertext Markup Language. See HTML.
Hypertext Transfer Protocol. See HTTP.
I
.ICO file extension, 309
Icon image format, 309
Icons, choosing, 125
Icon view (ListView control), 178–179
IcResponseCompleted event, 469–470
IcResponseReceived event, 469–470
If structure, 85–86
IIS Application, 134
Image control, 318, 549
vs. Picture Box control, 319
ImageList control, 160–161
ImageList property, 576
Image property, 578
Images. See also Pictures.
composite, storing, 321–324
creating from scratch, 324–325
displaying at nodes, 164
drawing, 324–325
formats for Picture Box, 309
storing, 318–321
Immediate window, 655–656
Imp (logical operator), 84
InBufferCount property, 404
InBufferSize property, 404
Index definition, 514
Indexes (database), 539
defining, 569–571
Index property, 164, 165–166
Infinite loop, 92
Initialization procedure, 190
Initialize event, 447
Initialize event procedure, 147
Initiating
DDE links, 203–204
InitProperties event, 447
In-place activation
OLE object, 232
In-process servers, 623
InputBox function, 522
Input buffer (Comm control), 404–405
InputLen property, 404
Input property, 404–405
Input # statement, 350–352
Insertable Object component, 136–137
Insertable objects, 29, 48–49
Inserting, OLE objects, 233–236
Insert method, 145–146
InsertObjDlg method, 238
Insert procedure, 143
Instancing MultiUse property, 186
Instr function, 115
Integer division, 80
Integer numbers, 64–65
Integer numeric variable type, 64–65
Integer variable (stack pointer), 99
Integrity, referential, 571
Interface
ActiveX, 185
visual, 22
Internet programming, 463–464
Internet Transfer Control. See ITC.
Interval property, 320
Intrinsic constants, 161
IsReady property, 376
IsRootFolder property, 378
ITC_DEMO demonstration project, 471–475
ITC (Internet Transfer Control), 464–487
error types, 471
for HTTP, 464–475
for HTTP transfers, 471–475
properties, 486–487
using for FTP, 475–487
Item (DDE conversation), 201–202
J
Jet database engine, 508, 509, 511
Joins, 541
JPEG image format, 309
.JPG file extension, 309
JustLoaded flag, 277
K
Key field, primary, 554
KeyPress event, 596
Key property, 578
Keys
compound, 554
compound primary, 538
foreign, 539
primary, 538–539, 552
surrogate, 554
Keystrokes, blocking, 596
Keywords
Alias, 668
Dim, 497
Private, 668–669
Public, 497, 668–669
Kill statement, 370
L
Label control, 23, 24–25, 47, 549
adding, 24–25
Late binding, 148–149
Left property, 298
Legacy databases, 544
Length property, 145–146
Line continuation character, 85
Line control, 336–337
Line Input statement, 279
Line method, 324–329
Line property, 358
Line wrapping, 85, 335–336
LinkClose event, 205
LinkError event, 205
LinkExecute event, 206
LinkExecute method, 220
LinkItem property, 202–203
LinkMode property, 202–204, 217
LinkNotify event, 205
LinkOpen event, 204–205
LinkPoke method, 221
Links
DDE, 200–202
pasting from a program, 214–215
pasting into a program, 206–213
LinkTimeout property, 203
LinkTopic property, 202–204
Link update, automatic, 202
List Box control, 47, 549
List form (database program), 506–507
ListImages collection, 160
ListItem object, 178
ListItems collection, 178
ListView control, 178–181
Literal constants, 76–77
Load event, 300, 506
Loading
forms, associated events, 303–304
pictures during program design, 308–309
pictures during program execution, 309–310
Load statement, 303
Loc function, 364–365
Locked property, 102
Locking controls, 46
Logical expressions, 82–83, 85
Logical operators, 84–85
Logical units, 296
Long numeric variable type, 64–65
Loops
and arrays, 119
Infinite, 92
nested, 91–92
Loop structures, 88–93
LostFocus event, 597
M
Mainframes, 618
Main window, 19, 20, 21
Manual link update, 202
MaskColor property, 161
MaskedEdit control, 549
Matrix of cells, 549
MCI
button commands, 428–429
commands, 414–416
MCI (Media Control Interface), 413–434
MciSendString function, 416
MDI form, 574–575
MDI forms, creating, 574
MDI (Multiple Document Interface), 295–296, 574–575
Media Control Interface. See MCI.
Me keyword, 291
Menu Editor, 266–270
Menus
adding, 266–269
enabling and disabling items, 275–276
pop-up, 42
Messages
displaying, 285
Windows, 11–12
Metafile image format, 309
Metafile pictures, displaying, 324
Methods
ActiveX classes, 190–192
AddNew, 519
associated with objects, 10
Circle, 306–307, 329–330
Close, 359
Copy, 377, 383
CopyFolder, 377
CreateEmbed, 237–238
CreateLink, 237–238
Debug.Print, 99, 119
Delete, 378, 383, 519
Execute, 470–471, 476–478
FindFirst, 522
FindLast, 522
FindNext, 522
GetChunk, 468–470, 477
GetFile, 381
GetFormat, 207–208
GetText, 108
Hide, 291, 303
Insert, 145–146
InsertObjDlg, 238
Line, 324–329
LinkExecute, 220
LinkPoke, 221
MoveFolder, 377
OpenURL, 465–466, 476
Overlay, 161
Print, 334–336
PrintForm, 340
Pset, 330–332
Raise, 640–641
ReadAll, 359
ReadFromFile, 240
Read(n), 359
Recordset, 521
RecordSet object, 587–588
SaveToFile, 240
Scale, 305–306
SetData, 215
SetText, 215–216
Show, 291, 303, 500, 506
ShowOpen, 279
ShowSave, 283
SkipLine, 359
Skip(n), 359
TextStream object, 359
Update, 240–241
WriteBlankLines(n), 359
WriteLine(s), 359
Write(s), 359
Microsoft Internet Explorer, 443
Microsoft Scripting Runtime, 356
MinButton property, 102
MixedState property, 578
MkDir statement, 371
MMControl, 429
Modem commands, 409
Modems and serial ports, 401
Mode property, 427
Modes
code editing, 31
form design, 31
Mod (modulus operator), 80
Module level code, 108, 127
Modules, 20, 39–40, 252
code, 39
form, 39
naming, 40
saving, 39–40
Modulus operator (Mod), 80
Mortgage calculator project, 22–36
code writing, 31–33
connecting the code to the interface, 33–36
visual interface design, 24–30
MouseDown event, 313–314
MousePointer property, 43, 297–298, 576
MouseUp event, 314
MoveFolder method, 377
Move method, 377, 383
MoveNext method, 519
MPC (Multimedia PC) standard, 412–413
MSComm control. See Comm control.
MsgBox function, 117, 285–286
flags argument, 285–286
MultiLine property, 102
Multimedia
defined, 412
devices, 413
errors, 421
Multimedia control, 426–434
errors, 431
events, 428–430
properties, 427–428
Multimedia errors, 421
Multimedia PC. See MPC.
Multimedia sound, 414
Multiple Document Interface. See MDI.
Multiple forms, 289–293
in database programs, 497–498
Multiple selected controls, dealing with, 456
Multiple-tier client/server models, 621–622
Multiplication operator (*), 59, 80
Multitable select, 541
Multiuser databases, 619
MUSIC demonstration project, 511–527
binding controls to the data table, 518–519
designing the main form, 516–518
using Visual Data Manager, 511–516
MvarLength variable, 142
MvarValue variable, 142
N
Name AXDEMO property, 187
Name property, 27–29, 53, 215, 378, 383
controls, 42
menu items, 267
modules, 40
Name statement, 373
Naming
enumeration members, 79
event-handling procedures, 57
modules, 40
variables, 65–67
Native-code, compiling to, 126–127
Nested loop, 91–92
Network OLE, 623
NewEntry Boolean variable, 106
New files, starting, 281–282
New Project dialog box, 18, 38–39
Node object, 162–166
Nodes, 164–166
Nodes collection, 162–163
NoMatch property, 522
Non-MDI form, 574
Notify link update, 202
Notify property, 430
NotifyValue property, 430
Not (logical operator), 84
Null modem, 400
Null value (Variant variable type), 98
Numeric variables, 64–65
O
Object, data unit using OLE, 229
Object Browser, 193
object information, 250–253
Object Linking and Embedding. See OLE.
Object-oriented file management, 374–384
Object-oriented programming (OOP), 8
Object references, automatic, 307
Objects, 7, 9–10
See also Class;
Components; Forms.
ADO (ActiveX Data Objects), 532–533, 534
available information, 250
Clipboard, 123, 207–209, 273–275
Collection, 154
Command, 532, 545
Connection, 532, 545
creating, 148–149
and DDE, 202–204
Drive, 374–377
embedded, creating, 237–238
ERR, 636–639, 640
Error, 546
Field, 545
File, 374, 381–384
Folder, 374–375, 377–381
Frame, 176–177
insertable, 29, 48–49
inserting with drag-and-drop, 239
kinds, 9
ListItem, 178
methods, 10
Node, 162–166
OLE, 233–236, 239–241
Parameter, 546
Picture, 318–321
creating simple animation, 318–321
Printer, 337–340
properties, 9–10, 20–21, 22
Property, 546
RecordSet, 587
Recordset, 518, 520–521, 545
relationship to classes, 139
screen, 297–298
TextStream, 356–359
UserControl, 439–440
viewing, 33
Object variable type, 70
OCX controls See ActiveX controls; Custom Controls.
OCX files, 48, 136
ODBC (Open Database Connectivity), 533–534
OLE automation, 137, 248–259
with embedded objects demonstration project, 255–259
with nonembedded objects demonstration project, 253–255
OLE automation objects
creating, 249–250
methods, 253
properties, 253
OLE container
application demonstration project, 242–248
inserting objects, 233–236
OLE Container control, 232
OLE Control, 549
OLE DB, 532
OLE (Object Linking and Embedding), 184, 227–259, 437
terminology, 229–248
vs. DDE, 201, 231–232
OLE objects
activating, 241
activation, 232
classes, 229–230
inserting, 233–236
retrieving, 240
saving, 239
OLE servers
deleting, 233
uninstalling, 233
OLE Type, restricting, 235
OleTypeAllowed property, 235
OnComm event, 405–406
On Error Resume Next statement, 639–640
On Error statement, 633–635
On Local Error statement, 225
OOP (Object-oriented programming), 8
Opcode argument, PaintPicture method, 311
OpenAsTextStream method, 383
Open command, 415
Open Database Connectivity. See ODBC.
Opening
files, 278–281, 346
Open statement, 346
OpenURL method, 465–466, 476
Operators
arithmetic, 80–82
assignment, 58
comparison, 83–84
logical, 84–85
precedence, 81–82
string manipulation, 80–81
Option Button control, 47
Option Explicit, 68
to avoid program bugs, 648
OrdinalPosition property, 566–567
Orientation property, 428
Or (logical operator), 84
OutBufferCount property, 404
OutBufferSize property, 404
Out-of-process servers, 623
Out of scope variable, 127
Output buffer (Comm control), 404–405
Outputlist argument (Print method), 334–335
Output property, 404
Overlapped controls, 45–46
Overlay method, 161
P
Package and Deployment Wizard. See PD Wizard.
Packaging your application, 659–661
Paint event, 304, 447
PAINTPIC demonstration project, 312–318
PaintPicture method, 310–318
Parameter object, 546
Parameters collection, 546
ParentFolder property, 378, 383
Parent forms, MDI, 295–296
Parent nodes, 162
Parity parameter, 401
Parity settings, 403
Password property, 475–476, 486
Paste Link command, 209–213
Paste Link demonstration project, 209–213
Paste Special command, 235–236, 238
PasteSpecialDlg method, 238
Path
of current application, 372
current vs. application’s path, 372
determining on current drive, 371
relative vs. absolute, 382
PathChange event, 385
Path property, 372, 376, 378, 383, 385, 386
PatternChange property, 385
Pattern property, 385
P-code, compiling to, 126
PD Wizard (Package and Deployment Wizard), 658–663
Picture Box control, 47, 308–318, 549
vs. Image control, 319
Picture Box forms, multiple, 574–575
PictureClip control, 321–324
PICTURECLIP demonstration project, 322–324
PICTUREDEMO demonstration program, 318–321
Picture object, 318–321
Pictures See also Images.
loading during program design, 308–309
loading during program execution, 309–310
Picture tab, 575–576
Pixel, 297
PlaceholderWidth property, 578
Play command, 415
PlayCompleted event, 429
Playing with Properties project
adding code, 56–60
executing the program, 59–60
interface design, 49–55
Polling, 402
Pop-up menus, 42
Ports, serial, 400
POST command, 470
Preserve keyword, 75–76
Primary colors, 325
Primary keys, 538–539, 552
compound, 538
field, 554
Primary tables, 539
PRINT1 demonstration project, 339–340
Printer object, 337–340
Printers collection, 157, 341
Printers Common Dialog control, 341
PrintForm method, 340
Print method, 334–336
Print # statement, 353–355
Private keyword, 78, 109, 127, 668–669
Private variable declarations, 187
Procedure arguments, 108–110
Procedure level code, 108, 127
Procedures, 108–112, 119
Basic, 32–33
Class_Terminate, 190
creating, 109–112
DisplayResult, 109–112
event-handling, 12–13, 34, 35–36, 56–59
FindRecord, 521
function, 284–285
initialization, 190
Property Get, 143, 188
Property Let, 143, 188
Property Set, 188
SetTextAlign, 670–671
termination, 190
Procedure view, 35
Program design, inserting OLE objects, 234–235
Programmable data objects, 248
Programs See also Demonstration projects; Projects.
debugging, 647–656
distributing, 656–663
exiting, 34
running, 33
Project Explorer window, 20
Project file, 40
Project icons, 125
Projects, 20 See also Demonstration projects; Programs.
multiple forms, 289–293
saving, 30, 39–40
starting, 38–39
types, 133–135
Properties, 49–51, 52–55
AccessType, 486
ActiveForm, 298
ADO Data control, 603
Align, 575
AllowCustomize, 576
AllowZeroLength, 566
AtEndOfLine, 358
AtEndOfStream, 358
Attributes, 382–384
AutoActivate, 241
AutoEnable, 427
AutoRedraw, 304
AvailableSpace, 375
BackColor, 43, 337
BackStyle, 337
Bookmark, 522
BorderColor, 337
BorderStyle, 43, 102, 302, 337
BorderWidth, 337
BoundText, 603
Button, 575
ButtonEnabled, 427
ButtonHeight, 576
Button object, 578–579
ButtonWidth, 576
CanEject, 427
CanPlay, 427
CanRecord, 427
CanStep, 427
Caption, 26, 29, 43, 52–53, 499, 578
CausesValidation, 571–572, 597
Changed, 456–457
changing, 26, 42–43
changing values, 655
Checked, 270
Class, 230
CollatingOrder, 567
Column, 358
Command, 427
Comm control, 402–405
CommEvent, 405
CommPort, 403
Container, 299
CurrentX, 332–333
CurrentY, 332–333
DatabaseName, 518
DataField, 518, 548
DataSource, 518, 548
DataUpdatable, 567
DateCreated, 378, 383
DateLastAccessed, 378, 383
DateLastModified, 378, 383
DefaultValue, 567
Description, 578
determining position and size, 298–302
Document, 486
DrawMode, 333–334, 337
DrawStyle, 333
Drive, 378, 383, 387
DriveLetter, 375
DriveType, 375
DropHighlight, 165
Enabled, 270, 275, 427, 576, 578
ERR object, 636–639
Error, 431
ErrorMessage, 431
EXEName, 214
field, 565–569
Filename, 385
Files, 378
FileSystem, 375
FillColor, 337
FillStyle, 337
Filter, 278–279
Flags, 287
Font, 51, 104–105
fonts, changing, 51
ForeColor, 43, 54, 57–58
forms, 42–43
FreeSpace, 375
Height, 298–299
Image, 578
ImageList, 576
InBufferCount, 404
InBufferSize, 404
Index, 164, 165–166
InputLen, 404
Instancing MultiUse, 186
Interval, 320
IsReady, 376
IsRootFolder, 378
ITC (Internet Transfer Control), 486–487
Key, 578
Left, 298
Length, 145–146
Line, 358
LinkItem, 202–203
LinkMode, 202–204, 217
LinkTimeout, 203
LinkTopic, 202–204
MaskColor, 161
Menu Editor, 270
MixedState, 578
Mode, 427
MousePointer, 43, 297–298, 576
MultiLine, 102
Multimedia control, 427–428
Name, 27–29, 53, 378, 383
Name AXDEMO, 187
names, 27–29
NoMatch, 522
Notify, 430
NotifyValue, 430
of objects, 9–10, 20–21, 22
OLE automation object, 253
OrdinalPosition, 566–567
Orientation, 428
OutBufferCount, 404
OutBufferSize, 404
Output, 404
ParentFolder, 378, 383
Password, 475–476, 486
Path, 372, 376, 378, 383, 385, 386
Pattern, 385
PatternChange, 385
PlaceholderWidth, 578
Protocol, 486–487
Proxy, 487
RecordCount, 524
Recordset, 520–521
RecordsetType, 518
RecordSource, 518
RequestTimeout, 487
Required, 566
ResponseCode, 466–467, 487
ResponseInfo, 466–467, 487
RootFolder, 376
RThreshold, 406
ScaleHeight, 299
ScaleMode, 296, 298
ScaleWidth, 299
SelLength, 273
SelText, 273
SerialNumber, 376
setting, 52–55
Settings, 403
Shape, 337
ShareName, 376
ShortName, 378, 383
ShortPath, 378, 383
ShowTips, 576
Size, 378, 383
Sorted, 497
StillExecuting, 478, 487
Style, 578–579
SubFolders, 378
SubItems, 180
TabStrip, 174–176
Tag, 165, 215, 216–217, 578
Text, 27–28, 50–51
Threshold, 406
TimeFormat, 427–428
Toolbar Control, 575–576
ToolTipText, 578
Top, 298
TotalSize, 376
Type, 383
UpdateInterval, 430
UpdateOptions, 240–241
URL, 487
Username, 475–476, 487
validation, 566
ValidationOnSet, 566
ValidationRule, 566
ValidationText, 566
Value, 53, 144–145, 578
Visible, 270, 291, 578, 607
VolumeName, 376
Wait, 428
Width, 298–299
Wrappable, 576
Properties collection, 546
Properties window, 20–21, 25–26
Property Get procedure, 143, 188
Property Let procedure, 143, 188
Property object, 546
Property page
adding to ActiveX controls, 454–458
Apply button, 456
Property procedures, 143–147, 187–188
adding to class modules, 189
Property Set procedures, 188
Protocol, 465
Protocol property, 486–487
Proxy property, 487
Pset method, 330–332
Public keyword, 78, 109, 128, 497, 668–669
Public variables, 100–102
PUT command, 470
Put statement, 362–364, 365
Q
QBColor function, 325
Queries, 530, 540
QueryUnload event, 501
Quick watches, 654
R
RACM (Remote Automation Connection Manager), 624–625
RaiseEvent statement, 449
Raise method, 640–641
Raising errors, 640–641
Random access files, 345, 361–364
defining record structure, 361–362
reading and writing, 362–364
Random access mode
when to use, 368
RDO (Remote Data Objects), 534
ReadAll method, 359
ReadFromFile method, 240
Reading, data from random access files, 363–364
Read(n) method, 359
ReadProperties event, 447
Record, finding in database tables, 521–522
RecordCount property, 524
Records
database, 492
listing from a database, 523–526
sorting in a relational database, 539–540
units of data, 344–345
Recordset method, 521
RecordSet object, 587
Recordset object, 518, 520–521, 545
RecordSet object methods, 587–588
Recordset property, 520–521
RecordsetType property, 518
Recordset types, 520–521
RecordSource property, 518
Record structure, defining random file, 361–362
ReDim, 75
References command, 137–138
References list, object information, 250–251
Referential integrity, 571
Registering components, 196
Registering servers, 624
Relational databases, 536–540
designing the application, 551–555
Relative coordinates, 332–333
Relative vs. absolute paths, 382
Remote Automation Connection Manager, 624–625
RemoteData control, 534
Remote Data Objects. See RDO.
Report view (ListView control), 178
RequestTimeout property, 487
Required property, 566
Require Variable Declaration option, 67–68
Resize event, 447
ResponseCode property, 466–467, 487
ResponseInfo property, 466–467, 487
Resume statement, 635–636
Retrieving OLE objects, 240
Return data type, 284
Returning errors from functions, 643–644
Reverse Polish Notation (RPN), 95–97
RGB function, 325–329
RGB values, 334
RichTextBox control, 549
RmDir statement, 370
RootFolder property, 376
Root nodes, 162
RPN (Reverse Polish Notation), 95–97
RS-232 ports, 400
RThreshold property, 406
Runtime, 10
creating databases, 548
inserting objects using a dialog box, 238
inserting OLE objects, 236
Runtime errors, handling, 631–645
S
SaveChanges function, 280
creating, 287
SaveToFile method, 240
Saving
files, 282–287
forms, 30
modules, 39–40
OLE objects, 239
projects, 30, 39–40
ScaleHeight property, 299
Scale method, 305–306
ScaleMode property, 296, 298
Scales of coordinate systems, 296
ScaleWidth property, 299
Scope, 653
Screen display demonstration project, 300–302
Screen measurement unit, 41
Screen objects, 297–298
Screens
Visual Basic, 38–39
Visual Data Manager, 511–512
Scripting qualifier, 356
Search algorithm, binary, 540
Seek command, 419
Seek function, 364–365
Seek statement, 364–365
Select Case structure, 87
SelectedControls collection, 456
SelectionChanged event, 455
Self-modifying programs, 10
SelLength property, 273
SelText property, 273
Sending
commands to another program, 220
data to another program, 220–221
Separators
adding to menus, 268
SEQUEL (Structured English Query Language), 530
Sequential access files, 344–345
Sequential access mode, when to use, 367–368
Sequential files
fields, 349–352
text, 353–361
using, 348–349
Serial communication
fundamentals, 399–400
parameters, 400–401
sending and receiving data, 404–405
SerialNumber property, 376
Serial ports, 400
determining status, 405
setting communication parameters, 403
Server, 530
Server applications
OLE terminology, 229–233
Servers
defined, 622
registering, 624
types, 623–624
Set command, 420
SetData method, 215
Set statement, 148
SetTextAlign API procedure, 669–670
SetTextAlign procedure, 670–671
SetText method, 215–216
Settings property, 403
Setup program, creating, 657–658
Shape control, 337
Shape property, 337
ShareName property, 376
Shell function, 219–220
ShortName property, 378, 383
ShortPath property, 378, 383
Show method, 291, 303, 500, 506
ShowOpen method, 279
ShowSave method, 283
ShowTips property, 576
Siblings nodes, 162
Single numeric variable type, 64–65
Single stepping the program, 656
Size property, 378, 383
SkipLine method, 359
Skip(n) method, 359
SmallIcon view (ListView control), 178–179
Snapshot type of Recordset, 520
Snap-to-grid feature, 25
Software components, 7–9
Sorted property, 497
Sorting
logical, 539
records in a relational database, 539–540
SOUND1 demonstration project, 421–425
SOUND2 demonstration project, 431–434
Source application, 201–202, 229
SQL (Structured Query Language), 521, 530–531
Stack pointer (Integer variable), 99
Stacks, 96–97, 99, 116
STACKSIZE constant, 101
Standard EXE application, 134
Starting
new files, 281–282
Visual Basic, 17–21
Startup form, 290
StateChanged event, 466–468
Statements
With, 273
Call, 666–667
ChDir, 371
ChDrive, 371
Close, 348
Debug.Print, 649
Declare, 667–669
Dim, 67, 127, 148
For Each...Next, 156
End, 34, 56–57, 501
Enum...End Enum, 78
On Error, 633–635
On Error Resume Next, 639–640
Exit For, 89
Input #, 350–352
Line Input, 279
Load, 303
On Local Error, 225
MkDir, 303
Name, 373
Open, 346
Put, 362–364, 365
RaiseEvent, 449
Resume, 635–636
RmDir, 370
traditional file management, 370–374
Type...End Type, 71–72
Unload, 500
With...End With, 92–93
Write #, 349–351
Static arrays, 75
Status parameters for sound and video devices, 419
StatusUpdate event, 430
Step commands, 656
Step keyword, 333
StillExecuting property, 478, 487
Stop bit parameter, 401
Storing, composite images, 321–324
String concatenator operators, 80–81
String manipulation operators, 80–81
String processing functions, 293
String Variables, 68–70
Structured English Query Language. See SEQUEL.
Structured programming, 108
Structured Query Language. See SQL.
Structures, 70–72
Style property, 578–579
SubFolders collection, 377
SubFolders property, 378
SubItems property, 180
Sub procedures, 108–109
Subtraction operator (-), 80
Subtractive primary colors, 325
SuperString class demonstration project, 147–151
Surrogate keys, 554
Symbolic constants, 76–77
Syntax checking, automatic, 112
Syntax errors, 112, 631–632
T
Tables
database, 492
dependent, 539
primary, 539
Table-type Recordset, 520
Tab order, 581
Tabs
Buttons, 577–579
Toolbar Control properties, 575–576
Tabs collection, 174
TabStrip control, 173–177
TabStrip properties, 174–176
Tag property, 165, 215, 216–217, 578
Terminate event, 447
Termination procedure, 190
TestExpression, 87
Text
aligning, 670–671
colors, 54, 57–58
displaying, 334–336
in sequential files, 353–361
Text Box controls, 23, 26–29, 47, 549
adding, 26–27
changing properties, 27–29, 49–51
Text boxes, 102–103
Text box project, 49–60
TextChanged flag, 277
Text files, 264
access, traditional, 353–355
Text property, 27–28, 50–51
TextStream object, 356–359
Three-tier client/server models, 621
Threshold property, 406
TimeFormat property, 427–428
Timer control, 320, 422
Toolbar control, 575–579
relationship to buttons, 576–577
Toolbar Control properties, 575–576
Toolbars
adding buttons, 579–581
creating, 574
Form Editor, 46
Toolbox window, 20
ToolTipText property, 578
Topic of conversation, 201
Top property, 298
TotalSize property, 376
Traditional text file access, 353–355
Transaction-processing applications, 542–543
Transferring data, using DDE, 219–225
Trapping errors, 633–635
TreeView control, 161–173
demonstration program, 167–173
Tuples, 538
Twips, 41
Screen object properties, 297
Two-tier client/server models, 620–621
.TXT file extension, 264
Type...End Type statement, 71–72
Type Library, 137–138
TypeOf keyword, 158–159
Type property, 383
U
Unicode, 357
Unload event, 501
Unload statement, 500
UpdateInterval property, 430
Update method, 240–241
UpdateOptions property, 240–241
URL property, 487
UserControl Designer, 439–440
UserControl object, 439–440
User-defined data types, 70–72
User-defined errors, 641–644
User events, 34 See also Events.
User input. See Events.
Username property, 475–476, 487
V
Validate event, 571–573, 597, 600
Validation methods, 595–599
ValidationOnSet property, 566
Validation properties, 566
ValidationRule property, 566
ValidationText property, 566
Value property, 53, 144–145, 578
Variable-length strings, 69
Variables, 64–70
changing values, 655
declaring, 67–70, 127, 187
determining type, 66
mvarLength, 142
mvarValue, 142
naming, 65–67
numeric, 64–65
other types, 70
out of scope, 127
public, 100–102
scope, 127–128
string, 68–70
Variant array, 99
Variant data type, 97–98
Variant data type, 643–644
Variant variable type, 70
VbCFLink constant, 215
VbCRLF constant, 280
VbCRLF defined constant, 639
.VBP file extension, 40
VCM (Visual Component Manager), 626–627
Viewing
code, 33
code associated with objects, 35
objects, 33
Views
full-module, 35
procedure, 35
VisData. See Visual Data Manager.
Visible property, 270, 578, 607
vs. Show and Hide methods, 291
Visual Component Manager, 626–627
Visual Data Manager (VisData), 509, 511, 560–563, 569
Visual interface, 22
VolumeName property, 376
W
Wait property, 428
Watches windows, 652–654
Watch expressions, 650–652
context, 653–654
types of, 652
WebBrowser control, 487–488
While...Wend loop, 91
Width property, 298–299
Windows API (Applications Programming Interface), 665–680
accessing, 666–668
demonstration project, 670–675
Windows API functions, declaring as procedures, 669–670
Windows API procedures, 666–670
Windows (operating system)
clipboard, copying to, 123
common controls, 159–181
global constants related to DDE, 208
messages, 11–12
registry
OLE server information, 232–233
registry and objects, 135
Windows (screen) See also Forms.
Code Editing, 33, 35
Form Design, 20
Form Layout, 21
Main, 19, 20, 21
Project Explorer, 20
Properties, 20–21, 25–26
Toolbox, 20
WindowStyle argument, 219–220
With...End With statement, 92–93
With statement, 273
Wizard, Application, 128–129
.WMF file extension, 309
Word length parameter, 401
Workstations, 618
Wrappable property, 576
WriteBlankLines(n) method, 359
WriteLine(s) method, 359
WriteProperties event, 447
Write(s) method, 359
Write # statement, 349–351
Writing data to random access files, 362–363
X
Xor (logical operator), 84


Previous Table of Contents Next


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to cert