Index

- (hyphen), 266 ! (exclamation point), 266 ! (Single) type declaration character, 35

# (Double) type declaration character, 35

# (number sign), 266 #INCLUDE FILE directive, 570

$ (String) type declaration character, 35 % (Integer) type declaration character, 35 % (percent sign), 266, 395 & (concatenation), 33 & (Long) type declaration character, 35

? (question mark), 27, 266, 395, 571 @ (at sign), 450

@ (Currency) type declaration character, 35 @* (in XML), 661, 665 [] (square brackets), 266 _ (underscore), 61, 266, 395 {} (curly brackets (in CSS)), 664 ' (apostrophe), 21 "" (empty string), 37 + (concatenation), 33 < (less than) operator, 76 <% %>, 554

<? ?> processing instruction, 613 <= (less than or equal to) operator, 76 <> (not equal to) operator, 76 = (equal to) operator, 76 > (greater than) operator, 76 >= (greater than or equal to) operator, 76 <All Libraries>, 22 <out of context> error, 154

AbsolutePage property, 571 AbsolutePosition property, 236 Access data types, 196 ACTION argument, 591 Activate event, 469, 503 Active Server Pages, see ASP

ActiveConnection property, 195, 206, 222, 270,

272, 289, 291 ActiveView property, 486 ActiveX Data Objects, see ADO ActiveX TreeView control, 320-321, 325-326 ADD CONSTRAINT clause, 406 ADD USER statement, 438 Add Watch window, 151-152 AdditionalData object, 638 AddNew method, 249-250 ADO (ActiveX Data Objects), 169, 171 Connection object, 173-174, 556 Error object, 190 Object Model, 172-173 Recordset object, 206 recordsets, 221 with XML, 658 ADODB (ActiveX Data Objects) library, 172 Adojavas.inc file, 570 Adovbs.inc file, 570 ADOX (ADO Extensions for DDL and Security), 172 datatypes, 196 Object Model, 194 types of tables, 207 Advanced Data TableGram format

(adPersistADTG), 292 AfterDelConfirm event, 468 AfterFinalRender event, 491 AfterInsert event, 462 AfterLayout event, 487 AfterRender event, 490 AfterUpdate event, 464, 517 alias, 557

ALL keyword, 267 ALTER COLUMN clause, 403 ALTER DATABASE statement, 433 ALTER GROUP statement, 437 ALTER TABLE statement, 402-403, 406 ALTER USER statement, 436 AND operator, 76

ANSI (American National Standards Institute), 395

ANSI SQL query mode, 396 ANSI SQL-92, 395 apostrophe, 21 APPEND command, 311 Append method, 195, 218, 288 Application object, 555 ApplyFilter event, 479 ApplyTransform function, 641 arguments, optional, 3, 54, 57 passing, 56 versus parameters, 73 Array function, 113 array variable, 104 arrays, 102

and looping statements, 107, 109

declaring, 104

dimensioning, 112

dynamic, 111-112

elements of, 102-103

errors in, 116-117

fixed-dimension, 111

functions, 113

initial value, 106

lower bounds, 105, 115

one-dimensional, 102

parameter, 117-118

passing between procedures, 108

passing elements, 108

range, 105

removing data from, 114 static, 111-112 two-dimensional, 102, 110 upper bounds, 105, 115 AS keyword, 31, 448-449 ASC keyword, 268

ASP (Active Server Pages), 549, 552-553 multi-page file, 569 Object Model, 555 Async property, 642 asynchronous loading, 652 record fetching, 227 attribute-centric XML, 659-660 Auto List Members check box, 17 AUTOINCREMENT, 398 AutoNumber data type, 208, 410

changing, 208 Avg function, 58

axis, 486

batch updates, 252 BeforeDelConfirm event, 467 BeforeInsert event, 461 BeforeQuery event, 484 BeforeRender event, 488 BeforeScreenTip event, 487 BeforeUpdate event, 463, 516 BEGIN TRANSACTION statement, 416 BeginTrans method, 330 BETWEEN.. .AND operator, 266 BOF (beginning of file) method, 241 bookmarks, filtering with, 246 marking records with, 245 navigating with, 163-164 using, 244-245 Boole, George, 76 Boolean data type, 29 expressions, 76 break mode, 517 breakpoints, removing, 149 using, 144 Build button, 8 ByRef keyword, 57 Byte data type, 29 ByVal keyword, 57

CancelBatch method, 304 CancelUpdate method, 251 Cascading Stylesheets (CSS), 664 Case clause, specifying a range of values in, 88 using multiple expressions, 90 with Is, 88 Case Else clause, 86

and errors, 87 Catalog object, 195, 272, 334, 447 change events, 482, 492 ChangePassword method, 334, 367-368 character encoding (in XML), 613 ChartDropZonesEnum, 488 ChartSpace object, 488 ChartSpaceLegend property, 488 Check constraint, 413-414 checked object, 496 Chr function, 53, 60

Chr(10) (line feed), 53, 60 Chr(13) (carriage return), 53, 60 Chr(32) (escape), 572 Chr(9) (tab), 53 class instance, 124

creating, 129 class members, declaring, 125 class methods, 128-129 class modules, 4, 119, 124, 529 creating, 124 inserting, 123 naming, 124 Click event, 7, 470, 520 client script, 554 client-side cursor, 225 Clone method, 305-306 Close event, 502

Close method, Connection object, 175

code, skipping, 160

Code Builder, 8-9

code template, 23

Code window, 9, 14-16

using in break mode, 150 collections, 119

adding objects to, 121 creating, 122 declaring, 121 removing objects from, 123 working with, 120 column axis, 486 Column object, 196 Columns collection, 196 combo box, and disconnected recordset,

294-295 command events, 482, 495 Command object, 270 CommandBeforeExcecute event, 497 CommandChecked event, 496 CommandEnabled event, 495 CommandExecute event, 498 command-line switch, 343 CommandText property, 270, 272 CommandTimeout, 581 CommandType property, 272 comment, 21

CommitTrans method, 330

COMMIT TRANSACTION statement, 416

CompactDatabase method, 192, 334

Complete Word feature, 20

concatenation, 33

conditional compilation, 161-163

conditional expressions, 76 conditional statements, 77-84 ConflictTable property, 389-390 Connection object (ADO), 173-174, 185, 195 connection, DSN-less, 183-184 ConnectionTimeout, 581 Const keyword, 48 constants, 19, 48 intrinsic, 49 private, 49 public, 49 constraint, 413, 424, 427 Container object, 362 control events, 514, 537 Count function, 327 counters, 96

CREATE INDEX statement, 216, 425, 428 CREATE PROC statement, 448 CREATE PROCEDURE statement, 448-449 CREATE TABLE statement, 397-398, 424 CREATE USER statement, 435 CREATE VIEW statement, 444, 448 CreateObject function, 240 CreateReplica method, 372, 374-375 CreateTextFile method, 240, 259 CSng function, 44 CSS, see Cascading Stylesheets Currency data type, 29 Current event, 460 cursors, 222 dynamic, 223 forward-only, 223 keyset-driven, 223 static, 223 types, 222 CursorLocation parameter, 225

predefined constants, 226 CursorLocation property, 289, 291 CursorType property, 206, 291

DAO (Data Access Objects), 171 Data Access Objects, see DAO Data Definition Language, see DDL Data Manipulation Language, see DML data members, 124 data providers, 171

used with ADO, 174 data shaping, 310-311

and other databases, 313 Data Shaping Service for OLE DB (MSDataShape), 312

data source, 559 data source events, 482-483 Data tab export options, 620 data types, 29

converting, 69-70 listing, 210 understanding, 34 DataAxis property, 486 database password, 366-367, 433

removing, 434-435 database security, 433 database tables, generating a list of, 207 Database window, 4 databases, and user-level security, 179-181

compacting, 192

copying, 187

creating, 186-187

deleting, 402

encrypting, 369-370

errors in, 190

opening a dBASE file with ADO, 182-183 opening in read-only mode, 177-178 opening in read/write mode, 176 opening password secured, 178 opening secured, 343 password-protected, 178 permissions for, 361 replication of, 371 DataChange event, 492 dataroot, 615

DataSetChange event, 493 Date data type, 30 DateValue function, 289 dBASE, 182

DblClick event, 471, 499, 525 DBQ parameter, 566

DDL (Data Definition Language), 216, 393 Deactivate event, 469, 504 debugging, 141, 143 Decimal data type, 20 declaration, explicit, 30 implicit, 31 declaration section, 3 default value, setting, 409-410 DefinedSize property, 196 Delete event, 466

Delete method, 199, 201, 253, 351-352 DESC keyword, 216, 268 Design Master, creating, 372-374

Detail section, 508

Dim keyword, 31, 40

dimension (Dim), 31

Dirty event, 465

Disallow Null option, 428, 430

Display events, 482, 487

DISTINCT keyword, 267

DISTINCTROW keyword, 267

DML (Data Manipulation Language), 264, 450

DoCmd object, 204, 206

Document Object Model, see DOM

Document Type Definition, see DTD

DOM (Document Object Model), 641, 650-651

DOMDocument object, 641-642

Double data type, 29

DRIVER parameter, 556

DROP CONSTRAINT clause, 408, 432

DROP GROUP statement, 442

DROP INDEX statement, 432

DROP PROC statement, 451, 454

DROP PROCEDURE statement, 454

DROP TABLE statement, 401

DROP USER statement, 438-439

DROP VIEW statement, 447-448

drop-down lists, using, 579

DropZones method, 488

DSN (Data Source Name), 182, 559

DSN-less connection, 183-184, 566

DTD (Document Type Definition), 608

dynamic array, 111

dynamic cursor, 223

early exit (from procedures, functions, and loops), 99 Edit toolbar, 17 element nodes, 655 element-centric XML, 659-660 ElseIf clause, 84 empty string (""), 518 enabled object, 495 End keyword, 8 End Sub keyword, 3, 8 Enter event, 515 EOF (end of file), 232 EOF (end of file) method, 241 Erase function, 114 Err object, 165 error dialog, buttons in, 144 Error event, 476, 506

error trapping techniques, 165-167 errors, database, 190

generating for testing, 167-168 logic, 143 run-time, 143 syntax, 142 trapping, 164 event procedures, 119, 459, 537 example, 7-8 in class modules, 130 writing, 7, 132-138 event programming, 7 event property, 6, 459 event sequence, 459 event sink, 528 event source, 528 Event statement, 542 event trap, 7, 459 event-driven programming, 6 events, 6, 119, 459, 528 data, 460

declaring, 541-543 raising, 541-543 reason to use, 7 Excel,

Application object, 254 copying records to, 254 opening a spreadsheet, 181 Range object, 254 Workbook object, 254 Worksheet object, 254 EXEC command, 453

Execute method, 198, 230, 272, 416, 448, 452

Exit Do statement, 99

Exit For statement, 99

Exit Function statement, 99

Exit Property statement, 126

Exit Sub statement, 99

explicit variable declaration, 30

Export command, 551

ExportXML method, 635

expressions, adding watch, 151 Boolean, 76 conditional, 76

operators commonly used in, 265 removing watch, 154 Extensible Markup Language, see XML Extensible Markup Language format (adPersistXML), 292

Extensible Stylesheet Language, see XSL

field properties, retrieving, 203 fields, adding to a table, 200 deleting, 201 retrieving values of, 238 Fields collection, 237 Fieldset object, 486 Fieldsets collection, 486 File DSN, 182, 559-565 File object, 240 FileDateTime function, 289 FileLen function, 289 FileSystemObject object, 240, 385 filter axis, 486 Filter event, 478 Filter property, 243, 261 Find method, 240 fixed-length String data type, 30 focus events, 469 Folder object, 385 For Each.. .Next loop, 98 For.. .Next loop, 96-97 foreign key, 413, 418 form events, 459 form module, 4-5, 119 form section events, 499 Format event, 507 Format function, 37 forms, lightweight, 5 forward-only cursor, 223 FROM keyword, 264 FTP (File Transfer Protocol), 608 full replica, creating, 374 function procedure, debugging, 145-148 executing, 53 testing, 59 writing, 52 functions, 3 array, 113 built-in, 59

calling from a procedure, 54 passing arguments to, 56 specifying data type, 54 type conversion, 44 when to use, 55 with arguments, 52

GET method, 581-582, 594 GetFolder method, 385 GetObjectReplicability method, 372 GetPermissions method, 334, 364 GetRows method, 247, 576-577 GetString method, 238-239, 256, 259, 272 GotFocus event, 470 GRANT statement, 440 group account, creating, 345-346, 437-438 deleting, 352, 442 listing, 353 Group Footers section, 508 Group Headers section, 508 Groups collection, 334

HasChildNode property, 654 HasModule property, 5 hidden fields, 595 hierarchical recordset, 311 HREF attribute, 571, 599 HTML (HyperText Markup Language), 549, 552

HTML tags, 553 <A></A>, 571 <B></B>, 553 <BASE></BASE>, 604 <BODY></BODY>, 553 <CENTER></CENTER>, 575 <FORM></FORM>, 581 <FRAME></FRAME>, 602 <FRAMESET></FRAMESET>, 602 <H1></H1>, 575 <H2></H2>, 571 <HEAD></HEAD>, 553 <HR>, 571

<HTML></HTML>, 553 <I></I>, 571 <IMG></IMG>, 603 <INPUT></INPUT>, 582 <NOFRAME></NOFRAME>, 602 <OPTION></OPTION>, 581, 586 <P>, 585

<PRE></PRE>, 585 <SCRIPT></SCRIPT>, 554 <SELECT></SELECT>, 581, 586 <TABLE></TABLE>, 575 <TD></TD>, 575 <TH></TH>, 586 <TITLE></TITLE>, 553

HyperText Markup Language, see HTML

If block, indenting, 81 If...Then statement, 77 formats, 79 multi-line, 78-79 nested, 84-85

with multiple conditions, 80 If...Then...And statement, 80 If...Then...Else statement, 81-83 If...Then...ElseIfstatement, 83-84 Ignore Null option, 428 IIS, see Internet Information Services Immediate window, 25-26 and break mode, 149 asking questions in, 26-27 ImportXML method, 650 In operator, 265 Indent/Outdent feature, 20 index, adding, 425 creating, 424 deleting, 217, 432 listing in a table, 216 multiple-field, 215-216, 426 single-field, 213-215, 424 with Disallow Null option, 430 with Ignore Null option, 431 with restrictions, 428-429 informal variables, 32 InputBox function, 67-69 INSERT INTO statement, 332, 450 instance, 119

creating for class, 129-131 Integer data type, 29 Intellisense technology, 16 Internet Information Services (IIS), installing, 556

intrinsic constants, 49-50 IS NULL operator, 265 IsArray function, 113 IsMissing function, 58-59 IXMLDOMNode object, 653-654 IXMLDOMNodeList object, 655-656

JavaScript, 552

Jet 4.0 ANSI SQL-92, 395

Jet database engine, 171

Jet OLEDB:Database Password property, 434 Join statement, 264

JRO (Microsoft ADO Ext. 2.7 for DDL and Security Object Library), 172, 334, 366

Key object, 212, 218 keyboard events, 473, 482, 498 KeyDown event, 473 KeyPress event, 475 Keys collection, 213 keyset-driven cursor, 223 KeyUp event, 474 keywords, 3, 8 Kill statement, 186, 402

LBound function, 115 library, 22

lifetime of variable, 40 LIKE operator, 265

line continuation character (underscore), 61

list (one-dimensional array), 102

list box, 583

List Constants menu, 19

List Properties/Methods feature, 9, 17

Load method, 642

local variables, 40

Locals window, 156-157

lock types, 224

LockType property, 206, 224, 291

predefined constants, 224 logic errors, 143 logical operators, 76 Long data type, 29 loop, 93

early exit from, 99 infinite, 94 nested, 99-100 statements, 91 LostFocus event, 470

MakeReplicable method, 372

MakeTable query, 198

MapPath method, 580

margin indicator, 16

match attribute, 625

message box, formatting, 60

Method attribute, 625

Microsoft Access table, creating, 195

Microsoft ADO Ext. 2.7 for DDL and Security

Object Library (JRO), 334, 366 Microsoft Excel, see Excel Microsoft Jet 4.0 OLE DB Provider, 171 Microsoft Jet and Replication Objects (JRO), 192

Microsoft Jet table, linking, 204 Microsoft Office Web Components (OWC), 483

Microsoft OLE DB Provider for Jet, 395 Microsoft OLE DB Provider for SQL Server, 171

Microsoft Scripting Runtime, 187, 385 Microsoft Visual Interdev, 552 Module View icon, 16 module-level variables, 41 modules, 3-5, 119 mouse events, 470, 482, 498 MouseDown event, 471 MouseMove event, 473 MouseUp event, 473 MouseWheel event, 473 Move method, 236 MoveFirst method, 236 MoveLast method, 236 MoveNext method, 232, 236 MovePrevious method, 236 MSDASQL provider, 182 MSDataShape provider, 312, 314 MsgBox function, 59

button arguments, 62-63 parentheses in, 67 returning values from, 66 using with arguments, 64-65 MSPersist provider, 666 MSXML parser, 642, 652 MULTIPLE keyword, 586 multiple records, editing, 251 multiple-field index, 215-216

Name property, 195-196 namespace, 614 nested statements, 84 Next Bookmark button, 164 next statement, 160

showing, 161 NoData event, 504 Node object, 328 NodeType property, 653 NodeTypeString property, 654 non-parameterized queries, 271

Not Null constraint, 413 NOT operator, 76 Nothing keyword, 46, 289 NotInList event, 519

Object Browser, 22-24 Object data type, 30 Object Library, VBA, 24-25 Object Model, ADO, 172-173 ADOX, 194 ASP, 555 object permissions, 364 object variables, 45 objects, creating custom, 123 ODBC DataSource, 171, 551 OLE DB, 171,566

OLEDB:Encrypt Database property, 367 On Current event property, 461 ON DELETE CASCADE, 419-420 On Error options, 165 On Error statement options, 165 ON UPDATE CASCADE, 419-420 OnConnect event, 483 OnDisconnect event, 484 one-dimensional array, 102-103 OnLoad event, 297 OnUndo event, 466

Open Database Connectivity (ODBC), 171 Open event, 501 Open method, 229, 231-232 Connection object, 174-175 Recordset object, 221, 235 OpenSchema method, 209-210 operators, logical, 76 relational, 76 used in expressions, 265 optimistic locking, 224 Option Base 1 statement, 105 Option Explicit statement, 38, 40 Option Private statement, 43 Option window, 16 optional arguments, 57 Optional keyword, 57 Options parameter, 226 OR operator, 76 ORDER BY clause, 447, 448 OriginalValue property, 301 OWC, see Microsoft Office Web Components

Page event, 505

parameter arrays, 117-118

Parameter Info window, 18

parameter query, 274-277

parameterized stored procedures, 450-453

Parameters keyword, 274

Parent node, 328

ParseError object, 642

parser, 608

Pass-Through query, 277 password, database, 366-367 setting for database, 433 user, 367 PERCENT keyword, 268 permissions, granting, 440 revoking, 441 personal identifier (PID), 435 pessimistic locking, 224 PivotChart events, 482 PivotChart view, 489-490 PivotTable events, 482 PivotTable object, 486 PivotTable view, 492 PivotTableChange event, 493 PopulatePartial method, 372, 376 POST method, 581, 591 predicates, 267

Presentation tab export options, 623 Preserve keyword, 112 Previous Bookmark button, 164 primary key, 406, 413-414, 427

creating, 212 Primary option, 428 PrimaryKey property, 212 Print event, 510 Print instruction, 27 Private keyword, 8, 41, 49, 124, 128 procedure-level (local) variables, 40 procedures, 3

active procedure call, 157 arguments, 3 breaking up, 71 breakpoints, 148 compiling, 11 event, 7 exiting, 99 functions, 3 master, 71

property, 4

removing breakpoints, 149 resetting, 161 running to cursor, 160 stepping out of, 160 stepping over, 159 stepping through, 158 stopping, 143, 161 subroutine, 3 testing, 143, 166-167 using arrays in, 105 writing, 52 processing instruction, 613 program, structured, 71 programming, 3 assistance, 16 event-driven, 6 programming language, 1 Project Explorer, 12-13 properties, defining for class, 125 retrieving for replicas, 384-385 Properties window, 13-14 property, 124

Property Get procedure, writing, 126-127 Property Let procedure, writing, 127-128 property procedures, 4-5 defining scope, 128 immediate exit from, 126 Public keyword, 40, 42, 49, 128 public variables, 42

queries, parameter, 275 Pass-Through, 277 row-returning, 271 Select, 264, 271-272 Query event, 484

Query Window, data definition, 421

Quick Info button, 19

Quick Watch window, 154-155

RaiseEvent method, 542, 528 read/write permissions, 176 read-only locking, 224 read-only permissions, 177 record position, 236

finding, 237 RecordCount property, 232, 273

records, adding, 249 copying, 254-259 counting, 233 deleting, 253 deleting (in ASP), 597 editing, 251

filtering with an SQL clause, 260-261 filtering with the Filter property, 261-262 finding, 240

finding using the Seek method, 241 modifying, 250-251 retrieving (in ASP), 567 sorting, 262-263 Recordset object, 221, 233

based on a table or query, 230-231 based on criteria, 234 based on SQL statement, 233-234 breaking up (in ASP), 569 cloning, 305

converting to a string, 239 creating shaped, 316 disconnected, 290 fabricating, 287 Filter property, 243 GetRows method, 247 moving around, 236 opening, 229, 235 returning as a string, 238 saving to disk, 292 saving to XML, 658 ReDim statement, 112 References clause, 418-420 RELATE command, 311 RelatedColumn property, 218 RelatedTable property, 218 relational operators, 76 Replace function, 591 replica, creating full, 374-375 creating partial, 375-378 retrieving properties of, 384-385 synchronization, 382-383 Replica object, 372 Replicable property, 380 replication, 371 report events, 501 report module, 4-5 report section events, 507 ReportML, 610 reports, lightweight, 5

Request object, 555 reserved words, 29 Response object, 555 Retreat event, 513 REVOKE statement, 441 RGB colors, 10 RGB function, 10

ROLLBACK TRANSACTION statement, 416 RollbackTrans method, 330 root node, 328 row axis, 486

Run to Cursor command, 160 run-time errors, 143

schema, 614

schema file, importing, 630-631 Schema tab export options, 622 scope of variable, 40 Search Text box, 23 SearchDirection parameter, 240 security, database, 338 user-level, 335, 338-343 Seek method, 240-241 Select Case statement, 85-90 SELECT keyword, 264 Select query, 264

execution with an ADO Catalog object, 272 from a VBA procedure, 268-269 SELECT statement, 444 SELECT.. .INTO statement, 198 SelectionChange event, 494 SelectionType property, 494 SelectNode method, 656 SelectSingleNode method, 657 Server object, 555 Server URL, 551 server-side cursor, 225 server-side script, 554 Session object, 555 session timeout, 551 SET DEFAULT clause, 409 SetObjectReplicability method, 372, 379-380 SetPermissions method, 334, 362 SHAPE command, 311,314, 326-327 shaped recordset, 311 with grandchildren, 320 with multiple children, 317 Single data type, 29 single-field index, 213-215 Sort property, 262

Sort Ascending command, 496

Source parameter, 222

spreadsheet, linking, 204

SQL (Structured Query Language), 395

SQL EXEC command, 453

SQL Server, connecting to, 188-189 connecting to using DSN-less connection, 189-190 SQL-2, 395

SQLOLEDB provider, 188 Stack window, 157 standalone module, 4 statements, nesting, 85 static array, 111 static cursor, 223 Static keyword, 40, 43, 128 static variables, 43

Step increment (in For.. .Next loop), 97

Step Into option, 144, 158

Step Out option, 160

Step Over option, 159

Stop statement, using, 150

stored procedures, 444

with parameters, 450 string, converting a recordset to, 239 returning a recordset as, 238 String data type, 30 Structured Query Language, see SQL stylesheets, 620 Sub keyword, 3, 8 subprocedures, 3, 71, 74 subroutines, passing values to, 56 when to use, 55 Subscript out of range error, 116 Substring function, 626 Sum function, 327 synchronization, conflicts, 385-388 of replicas, 382-383 Synchronize method, 372 syntax errors, 142 System DSN, 182, 559 System.mdw, 335

table properties, retrieving, 202 table relationships, creating, 218 tables, adding fields to, 200

copying, 198 creating, 195, 197 deleting, 199 generating a list of, 207 linking, 204

removing fields from, 201 types of, 207, 209 Tables collection, 195, 199 Target attribute, 604 text file, opening with ADO, 184 Timer event, 480 TimeValue function, 289 timing events, 480 Toggle Bookmark button, 164 Toggle Breakpoint button, 517 Toggle Folders button, 13 TOP keyword, 268 Top property, 488 transaction processing, 330 TransferSpreadsheet method, 204 transformation files, creating, 624-625 TransformNode method, 642 TransformNodeToObject method, 661 TransformXML method, 643 TRIM function, 590 two-dimensional array, 102-103, 110 type conversion functions, 44 type declaration characters, 35 Type Mismatch error, 34, 70-71 Type property, 195, 212 typed variables, declaring, 36 TypeName function, 490

UBound function, 115, 578

Uniform Resource Identifier, see URI

Uniform Resource Locator, see URL

Unique constraint, 413

Unique keyword, 406

Unique property, 212

untyped variable, 33

Update method, 224, 249-250

UpdateBatch method, 224, 303

updating data, differences between ADO and

DAO, 253 URI (Uniform Resource Identifier), 614 URL (Uniform Resource Locator), 614 user, adding to group, 349-350 user account, changing password, 436-437 creating, 348-349, 435-436 deleting, 351

listing, 354 User DSN, 182, 559 user form, designing, 130 user interface (for Web), 601 user password, 367 user-defined data type, 30 user-level security, 335, 338-343 Users collection, 334 UTF-8, 613

variable-length String data type, 30 variables, 28

array variable, 104 assigning values to, 36 class, 124 creating, 30 declaring, 31

declaring and using object, 45 finding definition, 47 forcing declaration, 38 implicit, 30-32 informal, 32 initialization, 37 module-level, 41 procedure-level (local), 40 public, 42-43 subscripted, 104 type of, 33 untyped, 33 using, 32 using static, 43 Variant data type, 29-30 VarType function, 47 VBA (Visual Basic for Applications), 1 and debugging tools, 141 Err object, 191

stopping and resetting procedures, 161 syntax, 11

testing procedures, 143 using object library, 24-25 vbCrLf, 240, 577 VBE (Visual Basic Editor), 12 vbNullString, 518

VBScript (Visual Basic Scripting Edition), 549,

552 vbTab, 240 View Code button, 13 View Object button, 13 ViewChange event, 494 views, 444

creating, 444-445

enumerating, 447 Views collection, 270 virtual directory, 557 Visual Basic Editor, see VBE Visual Basic for Applications, see VBA Visual Basic Scripting Edition, see VBScript

watch expressions, adding, 151 removing, 154 Watch window, 152-154 well-formed XML, 607-608 WHERE clause, 260, 265, 450 wildcard characters, 266 With keyword, 428-429 With.. .End With statement, 150 WithEvents keyword, 528-529 workgroup information file, 335-338 World Wide Web (WWW), 549, 557 Write method, 571 WriteLine method, 240 WWW, see World Wide Web

XML (Extensible Markup Language), 607 and Excel, 666-668 attribute-centric, 659-660 changing file type, 660-661 element-centric, 659-660 elements, 614 Export options, 620

schema file, 615 support (in Access), 609 templates, 617 working with nodes, 653 XML data file, as HTML table, 663 exporting, 610-612 importing, 629 understanding, 612 XML DOM, 641, 650-651 XML Path Language, see XPath XML Schema Definition, see XSD XML tags

<dataroot></dataroot>, 645 <s:Schema></s:Schema>, 660 <xsl:apply templates>, 626 <xsl:for-each>, 619, 645 <xsl:output>, 644 <xsl:stylesheet>, 625 <xsl:template>, 617 <xsl:text>, 649 <xsl:value-of>, 617 <z:row>, 665 XPath (XML Path Language), 617 XSD (XML Schema Definition), 615 XSL (Extensible Stylesheet Language), 617 XSL files, applying, 627

examining contents, 617-618 XSL stylesheets, applying, 661 XSLT Transforms, 617, 624

0 0

Post a comment