Advanced Visual Basic Techniques
(Publisher: John Wiley & Sons, Inc.)
Author(s): Rod Stephens
ISBN: 0471188816
Publication Date: 06/01/97

Index

A

about Dialog, displaying, 98

AboutDialog code, 89

Absolute URL, 421

Accelerators, 36–37, 40–42

Access databases, 203, 206, 226

Access objects. See Data access objects

Action parameter, 212

ActiveForm property, 289

ActiveX, 271, 315–365

alarm control, 319, 328

control, 317, 320–322, 324, 331, 334, 346

project, 318

properties, 333

label control, 378

usage. See Web

ActiveX controls, 338, 367, 387. See also Webdisplaying, 371, 374–375

ActiveX-enabled browser, 369

ActiveX.EXE, 272, 273, 275

AddData, 397

Add-in class, creation, 145–152

Add-in creation, summary, 156–157

Add-in designer, 156

Add-in installation tasks, 187

Add-in Manager, 137, 139, 146, 148, 152, 154–159

Add-in menu commands, 173

Add-in project, 152

Add-in server, 147

Add-in submenus, creation, 175–177

AddIn, building. See ConnectAddIn; DisconnectAddIn

AddInMaker, 185–195

add-in, 184

dialog, management, 187–188

key techniques, 187

summary, 195

usage, 185–187

Add-Ins, 137–195

creation, 143–157

menu, 139, 146, 147, 161, 173, 175, 176, 187, 192

testing, 157–159

AddRecentFile, 51–52

AddURL, 418, 421

AfterClick, 148–152, 157, 194

event handler, 178

providing, 162–164

subroutine, 157, 158, 162, 163, 176, 178, 185, 187

Alarm control, 317–329

key techniques, 318–319

summary, 329

usage, 317–318

AlarmControl, 319

AlarmDate, 318, 322, 326, 329

property, 323

Alarms, setting, 101, 120–121

AlarmTest, 319

AlarmTimer, 328

AlarmV, 115

ALIGN, 130

statement, 392

Aligner, 161–172, 175, 184

add-in, 137

key techniques, 161–163

summary, 172

usage, 161

ALL, 242

ALTER, 241–242

Ambient properties, usage, 324–325

Amount field, 5

API functions, 135, 189, 374

Appearance, 338–340

property, 339, 340, 379

AppendSegment, 400–402

Application basics, 1–135

Application data, management, 108

Appointment area, 99, 100

AppointmentBook, 93–135, 317

bit masks, 106

key techniques, 100–101

MVC, 113–115

summary, 135

synchronization, 98–100

usage, 93–100

Appointments, 240. See also Daily appointments

creation, 95

deleting, 95–96

modifying, 95–96

viewing, 95

Appts.DAT, 93, 96

Area controls. See Scrolling area controls

ArrangeControls, 362

subroutine, 73, 360, 361

ASCII, 81

Asynchronous data, loading, 372, 384

AsyncRead, 384, 385

AsyncServer, 301–313

building. See Visual Basic

key techniques, 303

summary, 313

usage, 302–303

Authorities. See Certificate authorities

AUTM. See Automation Manager

Automation manager (AUTM), 280

starting, 276, 278

Avg, 243

B

BackColor, 335–336, 340

property, 325, 327

Background colors, 64, 225

Bar gauge, 331–356

control, 332, 339

drawing, 333, 340–342

interacting, 331–332

key techniques, 333–334

modifying, 334, 346–356

programming, 332–333

summary, 356

Bar gauge properties, management, 333–340

Bar gauges, 358, 360

BarGauge, 355

Basic data, 233

Basic help, presenting, 125–127

Basic information, 224, 225

Beginning of file (BOF), 211

Binary large objects (BLOBs), 206

Bit masks. See AppointmentBook

combination, 103–106

definition, 102–103

usage, 101–106

Bitmap image, 64

Bitwise negation, 103, 105

Bitwise NOT operator. See Visual Basic

Bitwise operators, 106

Bitwise OR operator, 104

BLOBs. See Binary large objects

BOF. See Beginning of file

Bookmarks, 213, 216, 217

Boolean variable, 22, 90, 326, 328, 335

Browse sequences, 81

Btrieve, 203

Buffer string, 401

C

CalendarForm, 110, 120

CalendarModel, 108, 114

Callback object, 304, 310, 312

CalVC, 114

CalVC class, 112

CalVC object, 113

Caption property, 382

CAPTION statement, 392

Cascade, 45

Category combo boxes, 4

CBool conversion function, 105

Certificate authorities, 374

Changes, accepting/canceling, 221

CharSet, 116

Check box values, getting, 396

Check boxes, 111, 387, 395–396, 407

creation, 395–396

resetting, 396

CHECKED parameter, 390, 395

Checked property, 392, 396

Class ID, 385

Class IDs, learning, 371, 375–378

example page, 375–378

Class properties. See Visual Basic 4; Visual Basic 5

ClearData, 397

Client

building, 274

running, 279

testing, 268–271

Client/server applications, 265, 271, 370. See also TimeSync

Clipboard, 57

ClipPrecision, 117

Close, 38–39

CODEBASE

parameter, 375, 376

values, 381

Color coding, 200

Colors, selection, 372, 380–383

COLSPAN, 392

Columns, controls alignment, 162, 164–172

Combined gauge, 355–356

Combo boxes, 111, 225, 232, 387

Command classes, creation, 187, 194–195

Command line, specific files, 35

Comment delimiters, 249. See also Hypertext markup language

CompleteUrl, 415

ComputeValue, 343–344

function, 353

ComputeTotals subroutine, 27

ConnectAddIn, 146–148, 152, 154, 157, 158, 161, 163, 175, 185. See also CreateConnectAddIn

building, 187, 190–194

subroutine, 176, 186–188, 190

Contents, 45

Contents.HTM, 129–132

Context strings, 80, 83

Context-sensitive help, 1, 46

displaying, 97–98

providing, 54, 85–88

Control. See Data control; Outline control

containment, setting, 178–182

placement, 7

Control array, delegation, 360, 363–364

Control arrays, management, 360–363

Control display, management, 318, 322–323

Control projects, working, 318–322

Control templates, 149

Controllers, 107, 108, 111. See also Model/view/controller; View/controllers

Controls. See Label controls; Select controls

alignment. See Columns; Rows

arrangement, 8, 13–14. See also Scrolling area controls

binding, 206

creation, 178

dynamic creation, 8, 14–16

management, 5

nonallowed values, 232

ControlTemplate objects, 149

ConvertToken, 401–402

subroutine, 401

Copy, 41

CorelDRAW!, 31, 32

Count, 243

CREATE, 239–241

CreateClass subroutine, 194

CreateConnectAddIn, 192–193

CreateDisconnectAddIn, 193–194

CreateFont

API function, 101

usage, 118–119

CreateObject, usage, 274

CurrentPath, 415

Cut, 41

D

Daily appointments, scrolling, 115

DailyV, 115

DAO. See Data access objects

Data

asynchronous loading, 383–385

buffer, 402

loading, 96–97. See Asynchronous data

management. See Application data

manager, 204

manipulation. See Recordset objects

packing, 390, 400–405

purging, 97

receiving. See Web data

saving, 96–97

scrolling, 101, 119–120, 360, 363

sending. See Survey.HTM; Web data

unpacking, 390, 400–405

validation, 53, 56–60, 221–223

Data access objects (DAO), usage, 203–205, 208–213

Data bound control, 205

Data control, 205–206

coding, 208

usage, 203, 205–208

Data controls, remote databases usage, 258

Data manager. See Visual Basic 4; Visual Basic 5

attaching, 263. See also Visual data manager

Data managers, usage, 262–264

Data values, 399

DATABASE, 79

Database applications, testing, 203, 234

Database engines, 204

Database menu, 236

DatabaseName property, 258

Databases, 264. See also Remote databases

creation, 237–239

understanding, 203–204

Databasics, 197–264

DataSafe, 24, 25

Date fields, 4

Date synchronization subroutines, 270

DateLabelV, 115

DateModified

setting, 21

usage, 24–26

Dates, selection, 94–95

DateText, 14

dBASE, 203

DBEngine, 209

DBUser class, 228–232

Debugger, 271

Default property values, setting, 319, 324–325

Delete, 41–42

DELETE, 247–248

Dial, 351–355

controls, 347, 355

Dialog. See about Dialog

management. See AddInMaker

printing, 53

usage. See Printing

Dialogs

displaying, 54, 88–92

menus presentation, 37

DisconnectAddIn, 148, 152, 154, 157–159, 161, 163, 175. See also CreateDisconnectAddIn

building, 190–194

subroutine, 176, 187, 188, 190

DisplayReport, 311

DISTINCT, 242

DISTINCTROW, 242

Document interface, selection, 9, 18–20

DrawPreview, 72

DROP, 241

Duplicate, 41

Dynaset, 210

E

Edit, 40–42

EditStatus, 221, 222

Enabled property, 322, 328, 336, 359

Encipher subroutine, 229, 231

End of file (EOF), 211

EOF. See End of file

Equi-join, 244

Error message, 414, 422

Error-handling code, 55

Escapement, 116

Event connection ID, 148

Event handler, 13, 16, 17, 35, 90, 148, 182, 327, 363, 398

Event handler ID, 192

Event IDs, 193

Event notification, 110

Events, 113

raising, 319, 328–329. See also Indexed events

ExamineDocument, 418

Execution, deferment. See Initialization

Exit, 40

Exit Sub, 23

Expense.FRM, 21

ExpenseReporter, 1

ExpenseReporter, building, 53–92

key techniques, 53–54

summary, 92

ExpenseReporter, user viewpoint, 3–52

key techniques, 7–9

summary, 52

usage, 3–7

Expense.VBP project, 3

F

Face, 117

FactorAll, 142

Feedback, 63

providing, 53–55

FetchReport, 305

code, 305

subroutine, 290–292

Field editability, setting, 224–226

Field navigation, enhancement, 8, 16–18

Field validations, 3–5, 232–233

Field-level validation, 1

File, 38–40, 411

File commands, 40

File list menu items, 47–48

File lists, providing, 9, 47–52

File menu, 236

entries, 49

File selection dialog, 39

FileInput function, 33

Files. See Command line

closing, 38

creating, 38

loading, 9, 26–36, 38

management, 6–7

opening, 38

saving, 9, 26–36, 38

FILES section, 82, 84

FileWrite function, 32, 33

FillColor, 351

FillPicture, 349

Find, 42

Find Next, 42

FirstNameFile, 206

FirstNameText, 219

Font mapper, 116, 117

Fonts. See CreateFont

creation, 101, 115–119

ForeColor, 335–336, 340, 349

Form-level validations, 1, 5, 53, 60

Forms

creation. See Nonrectangular forms

validation, 53, 60–69

Free-format SQL, 299

FROM clause, 244–245

FTP server, 410

G

Gauge. See Bar gauge; Combined gauge; PicGauge; TicGauge; WidGauge

control styles, 356

property value, 363

Get Values, 140, 141

GetPrivileges, 228–229

GetSsetting function, 50

Gettext function, 57

GetToken function, 288

GetToken routine, 248

GetToken subroutine, 248

GetUserID, 229–231

GetValues function, 150, 151

Global collection, 216

Global variables, 146, 190, 222

GotFocus, 16, 17

Goto collection, 416

GotoFile collections, 417, 421

GotoPath collections, 417, 421

GotoSite, 421

GROUP BY clause, 246

GroupPrivileges, 226, 227

H

HasPrivilege, 228–229

HAVING clause, 246

Height, 116, 374

properties, 77

Help, 7, 45–47. See also Visual Basic; Windows 3.x style help; Windows 95 style help

compiler, 78

displaying, 97. See also Context-sensitive help

presenting, 101, 124–134. See also Basic help

providing, 54, 77–85. See also Context-sensitive help

search, 45

usage, 46

Help browser, building, 125–129

Help documents, building, 129–134

Help file

building, 78–84

usage. See Visual Basic

Help menu entry, 88

Help project

compiling, 83–84

file, 78

creation, 81–83

Help systems. See Hypertext markup language; Web-based help system

designing, 78–79

types, 78

Help topic file, 78

HelpCommand property, 84, 85

High-quality application, 54

High-resolution printer, 65

High-resolution printout, 53

Histogram, 357–365

key techniques, 359–360

programming, 357–359

summary, 365

usage, 357

Home data, 233

Home information, 201, 224

HOME state, 232

Horizontal tiling, 45

HR data, 233

HR information, 201, 224

HREF parameter, 130

HTML. See Hypertext markup language

HTTP protocol, 397

Hypertext links, 79, 80, 130

Hypertext markup language (HTML), 97, 372, 378, 396

code, 129, 375, 379, 381, 384, 390, 392, 394, 395, 398, 411, 420

commands, 124

comment delimiter, 377

data entry objects, 389

documents, 101, 124, 383, 391, 407, 418, 419

file, 127, 408

file index, 126

help files, 129

help system, 93, 125

links, 97

OBJECT, 374, 385

objects, 390

source code, 131

tags, 125, 129–130

I

Icons. See Large icons; Small icons

arrangement, 44

IgnoreModify, 21–24

Images, editing, 219–221

Index, 45–46

Index entry, 132, 133

Indexed events, raising, 360, 365

Indexed properties, support, 360, 364

Index.HTM, 132–134

InetXfer, 390, 397–398

ActiveX control, 389

InetXfer1 control

AddData method, 391

ClearData method, 398

Initialization

execution deferment, 325

files, 187

safety, 373

Inner join, 244

INPUT statement, 26, 395

INSERT, 246–247

Interface customization. See Users

Internet Transfer Control. See Microsoft Internet Transfer Control

Italic, 116

K

Keyboard events, handling, 334, 345–346

KeyChangeAmount value, 334

KeyDown, 56, 345

KeyPress, 56, 57

event handler, 64

L

Label controls, 65

Labels, updating, 372, 378–380

Large icons, 43

LargeChange, 11, 12, 73, 114, 361

LastNameFile, 206

Left join, 244

Librarian, 286

building, 287, 295–297

Lists, 111

LoadRecentFiles, 50–51

LoadReport, 298

subroutine, 307, 309

Local testing, 268, 271–275

Logical font, 116, 118

Logical operators, 245

Logon user, 202

M

MainLang control, 394

MakePreview, 70

MakeReport, 310

MAP section, 82, 85

Mask values, 102

Max, 114, 243, 351, 361

Max value, 334, 343, 353

MaxButton, 87, 88

MaxLength property, 56

MDI. See Multiple document interface

Menu command, 128

Menu entries, 128

Menu history commands, 128

Menu items. See File list menu items

Menus. See Add-in submenus; Special menus; Standard menus

design, 9, 36–47

presentation. See Dialogs

Menus.FRM, 38

Message box, 212

Message dialog, 312

Messages, displaying, 312–313

Microsoft Access, 204

Microsoft Internet Explorer, 369

Microsoft Internet Transfer Control, 387, 405, 408

Microsoft Jet database engine, 204

Microsoft Paint, 18

Microsoft FoxPro, 203

Microsoft Visual Basic, 309

Microsoft Word, 18, 19, 79–81

Min, 114, 243, 351

Min value, 334, 343, 353

MinButton, 87, 88

Mirror-image printing, 76

Mnemonics, 36–37, 40, 49

mnuFileList, 48

mnuNavigate, 127

Modality, imitating, 306–307

Models, 107–110

summary, 110

Model/view/controller (MVC). See AppointmentBook

paradigm, usage, 1, 101, 107–115

Mouse, management, 333, 342–345

MouseDown, 342–343

MouseMove, 344

MouseUp, 344–345

MultiLine property, 64

Multiple document interface (MDI), 18–20

application, 21, 39, 44

form, 44, 45, 289, 295, 306, 308, 312

MVC. See Model/view/controller

N

NAME parameter, 390

Navigation features, providing, 127–129

Netscape Navigator, 377

Network operation, 410

Network performance, improving, 257, 264

New, 35–36, 38, 235

Nonblank captions, 128

Nonrectangular forms, creation, 101, 121–124

Nonscrolling regions, 81

Nonzero integer values, 104

NotifyViews subroutine, 106, 109, 113

NumBars, 361, 362

property, 358, 360

NumPoints property, 373

NumValues, 361, 362

property, 359

O

Object Browser, 157, 337

OBJECT command, 371, 374

Object Linking and Embedding (OLE)

automation error, 280

automation support files, 276

clients, 143

DLL, 154, 155, 187

options, 277

server class, 299

servers, 142–145, 155, 271–273, 296

service provider, 276

understanding, 142–143

OBJECT statement, 374–375, 383

Object window, 320

OLE. See Object Linking and Embedding

Open, 33–34, 38, 235

OpenURL, 410, 414, 417, 418

method, 407

Option buttons, 111

OPTION commands, 393

OPTION statement, 394

Options, 43–44

menu, 44

OPTIONS section, 82

ORDER BY clause, 207, 242, 246

Orientation, 116

Outer join, 244

Outline control, management, 214–218

Output string, 228

Output-only text boxes, 63–64

OutputPrecision, 116

P

Paint Picture, 73

Paint subroutine, 342, 347–349

PaintPicture, 349

Paradox, 203

PARAM statements, 375, 376, 380, 383–385

ParameterForm, 292–294, 305–307

ParseURL, 412, 416

Paste, 41

Path, 411

PeopleWatcher, 199–234

application, 261

commands, displaying, 218–219

key techniques, 203

summary, 234

understanding, 203, 213–233

usage, 199–203

PeopleWatcher Remote, 257–264, 283

key techniques, 257–258

summary, 264

Physical font, 116

PicGauge, 349–351, 355

Picture boxes, 224

Picture2D, 339, 340, 342, 345

object, 335

Picture3D, 339, 340, 342, 345

object, 335

Pictures, loading. See Web

PitchAndFamily, 117

Plain-text files, 124

POINTAPI, 122

Popup dialog, 79

Popups, 80, 87

PostScript optimization, 76

Predicate, 242

PresentTopic, 125

PresentURL, 125, 126

Print, 39–40

Print Dialog command, 75

Print preview, 5–6, 38, 39, 70

Print previewing, 53, 60, 69–73

Print setup, 38, 39, 43

dialog, 54

Print Setup command, 6

PrintDocument, 69, 70

subroutine, 67, 68

Printer object, 65–69

Printer setup, providing, 54, 76–77

Printing, 5–6, 38, 53, 60, 64–65. See also Dialog

dialog usage, 73–76

PrintMultiline, 69

subroutine, 67

PrintString, 69

subroutine, 66

Privilege tables, 226–227

Privileges, 254–255

Procedure IDs, 327, 328

ProcessAllCommands, 248–249

ProcessCommand, 250–252

ProcessSelect, 252–254

function, 299

Project Explorer, 320

Project options, setting, 143–145

Project properties. See Visual Basic 4; Visual Basic 5

Properties. See Indexed properties; Standard properties; Visual Basic 4; Visual Basic 5

Property. See Enabled property

Property IDs, 327

Property procedures, implementation, 319, 323–324

Property values. See Default property values

reading, 319, 325–326

writing, 319, 325–326

PropertyChanged subroutine, 323, 327, 334

PropertySetter, 139–159, 172, 175, 184

add-in, 161

installing, 139–140

key techniques, 141–142

summary, 159

usage, 140–141

ProtectChar, 401, 403

subroutine, 400, 402

Protocol, 410

Q

Quality, 117

Query, 235–255

key techniques, 237

summary, 255

usage, 235–236

Query Server application, 308

QueryDef object, 237, 250, 252

QueryServer, 283–300, 302

application, 284, 301, 305

key techniques, 287

summary, 299–300

system, 285

usage, 285–286

QueryServerForm, 289

QueryUnload, 25, 26

event handler, 129

R

RACM. See Remote Automation Connection Manager

Radio button values, getting, 391

Radio buttons, 390–392

creation, 390–391

resetting, 392

Read-only property, 323

ReadProperties, 384

ReadyToUnload, 91

subroutine, 123

Records

copying, 212

creation, 211–212

deleting, 212

editing, 212, 219

selection, 206–207

Recordset objects, 208, 209, 212

data manipulation, 210–211

types, 210

Recordsets

creation, 209–213

field, 252

RecordSource property, 258

Redo, 40

Redo accelerator, 40

References dialog, 274

Refresh, 43

command, 127

RegClass, 269

usage, 280–282

REGEDIT, 50

RegisterView subroutine, 108

Registry, 50

Relational databases, 207

Remote Automation Connection Manager (RACM), 277, 278, 280

Register menu, 279

Remote databases

direct access, 258

usage. See Data controls

Remote tables

attaching, 257, 259–264

manipulating, 263–264

Remote testing, 268, 275–279

RemoveRecentFile, 52

RemoveSegment, 400, 402–405

Repeat, 40

Replace, 42

Report

building, 309–311

displaying, 312

Report object, starting, 309

Report parameters, getting, 305–306

ReportForm, 294–295,312

displaying, 311

ReportList, 286

building, 287–295

client, 303, 308

ReportLister object, 296

ReportListForm, 289–292, 308

Reports

generating, 303, 308–311

requesting, 303, 305–308

scheduling, 308–309

RequestReport, 311

Resize event handler, 175, 178

Results, displaying, 303, 311–313

Right join, 244

Rows, controls alignment, 162, 166–172

ROWSPAN, 392

S

Salary information, 201

Save, 39, 235

Save All, 39

Save As, 39, 235

command, 30

Save parameter, 212

SaveData, 24, 32–33

SaveDataAs, 30–32

SaveRecentFiles, 50, 51

Scale, 43

menu, 71

ScaleHeight, 10, 11, 68

ScaleLeft, 68

ScaleTop, 68

ScaleValue, 72

ScaleWidth, 68

Scaling, 76

ScheduleWakeup, 120

Scroll bars, 16, 17, 107, 111, 115, 119, 175

management, 73

Scroll events, 119, 359, 378

ScrollArea, 9–12, 14–16, 72

Scroller, 173–184

add-in, 137

key techniques, 175

summary, 184

usage, 173–175

Scrolling area controls, arranging, 175, 182–184

Scrolling areas, creation, 8–12, 175, 178–182

ScrollVC, 114–115

SDI. See Single document interface

SELECT, 242–246

statement, 207, 242, 244–246, 251, 252, 393. See also SQL SELECT statements

Select All, 42

Select control values, getting, 394

Select controls, 393–394

creation, 393–394

resetting, 394

Select list, 243

SELECTED parameter, 393

SelectObject API function, 118

SendData, 397–398

Separators, 37–38

Server

access, granting, 277–278

application, 285

building, 271–273

class, 273

compiling, 276

installation process, 268

installing, 276–277

registering, 277, 278–279

running, 273

Server DLL, 157

creation, 154–156

Set Values, 140, 141

SetScale subroutine, 72

SetterDialog, 148, 149

SetValues function, 150, 151

ShapeForm subroutine, 122

ShowAbout, 123

ShowPrinter method, 77

ShowSplash, 123

ShowValues subroutine, 363

Single document interface (SDI), 1, 18–20

applications, 39

documents, management, 9, 20–26

Single-form application, 1

Site, 410–411

SiteMapper, 407–423

application, 367

key techniques, 408–409

modifying, 409, 422

summary, 423

usage, 407–408

SIZE parameter, 393

Small icons, 43

SmallChange, 12, 73

SortControls, 167

Source code, 7, 8, 321

Special menus, 47

Splash screens, 121

displaying, 54, 88–92

SPRY Mosaic, 376

SQL. See Free-format SQL; Structured query language

SQL SELECT statements, 235, 236, 296

SQL UPDATE statement, 231

SQL WHERE clause, 297

SQLServer

applications, 286

building, 287, 297–299

example, 298–299

program, 296

Standard menus, 38–47

Standard properties, delegation, 319, 326–328

Start Time, 95

Status Bar, 42

StDev, 243

StDevP, 243

Stop Time, 95

StrikeOut, 116

StripCommands, 249–250

Structured query language (SQL), 294

commands, composing, 237, 239

property, 250

query, 285, 298

statements, 205, 207, 208, 210, 229, 231, 235, 239, 243, 247, 251, 258

processing, 237, 248–254

Style, 336–338

property, 355

Sub main

building, 187–190

creation, 152–154

Submenus. See Add-in submenus

Sum, 243

Survey.HTM, data sending, 398

System-defined font, 68

T

TableDef, 260, 262

object, 259

Tables, 392–393. See also Privilege tables; Remote tables

detaching, 262

Tags, 129, 133

Task Manager, 96

TCP/IP network protocol, 278

Technical support, 46

Test application, 319–320

running, 322

Testing. See Client; Local testing; Remote testing

Text, formatting, 64

Text area values, getting, 395

Text areas, 394–395

creation, 394

getting, 395

Text box values, getting, 395

Text boxes, 54, 63, 111, 219, 225, 232, 236, 270, 395. See also Output-only text boxes; Visual Basic

creation, 395

resetting, 395

Text Flow tab, 81

Text strings, 243

TEXTAREA statement, 394

TicGauge, 347–348, 355

TicSpacing, 351

Time Manager, 274

Time synchronization subroutines, 270

Timer control, 304

Timer event, 309

Timer event handler, 91, 120

TimeManager, 272, 280, 281

TimeSync, 267–282

client/server application, 267

key techniques, 268–269

server application, 267

steps, 269–279

summary, 282

troubleshooting, 268, 279–280

usage, 267–268

Tips, 46

Title bar, 121

Toolbar, 42

command, 42

TOP, 242

Topic file, creation, 79–81

Troubleshooting. See TimeSync

TYPE parameter, 390, 395

U

Underline, 116

Undo, 40

Uniform Resource Locator (URL), 125, 397, 398, 407. See also PresentURL

expanding, 409, 414–416

parsing, 409–414

understanding, 410–411

UNIX systems, 227

UNLOAD, 25

UnprotectChar, 402–405

UnregisterView, 109

UPDATE, 247

statement. See SQL UPDATE statement

UpdatePassword, 231–232

UpdateRecentFileMenu, 48–49, 51

URLHelpForm, 97, 125–128

URL. See Uniform Resource Locator

User interface, 63, 110

elements, 107, 396

style, 218

User passwords, 202, 227–228

User privilege checks, 297

User privileges, 226

UserControl, 322, 361

object, 320, 323–326, 338, 384

Users, interface customization, 223–228

V

Validation, 212–213. See also Data; Field validations; Field-level validation; Form-level validation; Forms

nonallowed values, 232–233

ValidMoney, 59

VALIGN statement, 392

Value, 114, 334

Value drag operation, 344

VALUE field, 383

VALUE parameter, 395

Value property, 345

ValueChanged event, 359, 365

Values. See Check box values; Controls; Radio button values; Select controls values; Text area values; Text box values; Validation

VALUES clause, 246

Var, 243

VarP, 243

vbAsyncTypeByteArray, 384

vbAsyncTypeFile, 384

vbAsyncTypePicture, 384

vbRightJustify, 64

VBScript, 378

code, 370, 372, 376, 377, 390, 395, 396

event handler, 382

Vertical tiling, 45

VerticalText, 118

View/controllers, 111–113

View, 42–43

Viewport, 9, 10, 13, 14, 174

Views, 106–108, 110–111

notification, 108–110

VisitURL subroutine, 421

Visual Basic, 9, 15, 25, 26, 36, 47, 64, 74, 101, 105, 109, 139, 182, 219, 304, 325, 391. See also Microsoft Visual Basic

add-in, 204

Add-Ins menu, 140

application, 37, 54, 82, 85, 143, 370

asynchronous servers, building, 303, 304

bitwise NOT operator, 103

code, 113, 207, 273, 396

development environment, 14, 137, 144–146, 157

Environ, 399

help, 203

help file usage, 84–85

Load command, 360

Load statement, 292

Menu Editor, 75

program, 237, 380

programmers, 140

programming environment, 143, 157, 158, 280

programming methods, 93

programming techniques, 203

source code, 188, 208

techniques, 100

text boxes, 41

Visual Basic 3 project files, 26

Visual Basic 4, 26, 83, 139, 142, 156, 275

class properties, 145–146

Data Manager, 263

Development Environment, 147, 153

Object Browser, 155

project properties, 143–144, 271–272

Visual Basic 5, 139, 142, 155, 156

class properties, 146

compact disk, 78, 83

development environment, 154

Enterprise Edition, 78

Extensibility reference, 147

project properties, 144–145, 272–273

Setup Wizard, 276, 375

Visual Data Manager, 262, 263

Visual data manager, attaching, 263

W

WaitEnd, 54, 55

WaitStart, 54, 55

Web, ActiveX controls, 369–385

key techniques, 370–372

safe use, ensuring, 371–374

summary, 385

usage, 369–370

Web, ActiveX usage, 367–423

Web, pictures loading, 384–385

Web browser, 370, 418

Web client program, 423

Web data

receiving, 389, 399–400

sending, 390, 396–398

Web documents, 369

retrieving, 409–410

Web page author, 373

Web page designer, 369, 371

Web pages, 367, 369, 372, 378, 387, 407

building, 389–396

Web sites, 410, 411

mapping, 409, 416–422

Web-based application, 355

Web-based help system, 78

WebBrowser, 125, 127, 130

control, 93

WebLabel control, 369, 379

WebSurvey, 387–405

application, 367, 389, 405

key techniques, 389–390

summary, 405

usage, 387–389

Weight, 116

What-you-see-is-what-you-get (WYSIWYG) interface, 218

WHERE clause, 207, 245–248, 297, 299. See also SQL WHERE clause

WidGauge, 348–349, 355

Width, 116, 374

properties, 77

Window, 44–45

Window list, 45

WindowList property, 45

Windows 3.x style help, 85–86

Windows 95, 18, 85, 277, 420

style help, 86–88

task manager, 309

Windows API, 122

function, 115

Windows Explorer, 43, 83, 276

Windows navigation features, 5

Windows NT, 18, 152, 420

Windows Registry, 32, 374

WindowState, 13

Workspaces, 209

World Wide Web, 124

WriteProperties, 325, 333, 384

event handler, 326

WriteProperty subroutine, 325

WYSIWYG. See What-you-see-is-what-you-get

Z

ZOrder method, 224