|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Amundsen M., Smith C. — Teach Yourself Database Programming With Visual Basic 4 in 21 Days |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
# (pound sign), date fields 548
# (pound sign), marking footnotes in help topics 705
$ (dollar sign), custom help footnotes 707
& (ampersand), Caption property 13
* (asterisk), SQL statements 275
* (asterisk), wildcard character 530
+ (plus sign), help file, browse sequences 708
. (period), SQL statements 280
.MDB extension 45
// (double slashes), SQL-VB comments 499 753
; (semicolon), SQL statements 497
About command (Help menu) 747
About dialog box 721
Access databases (Data Manager) 38
Access databases (Data Manager), adding fields to data tables 47—50
Access databases (Data Manager), adding indexes to data tables 51—54
Access databases (Data Manager), adding records to data tables 61—63
Access databases (Data Manager), advantages/disadvantages 39
Access databases (Data Manager), attaching external data tables 55—57
Access databases (Data Manager), closing databases 41
Access databases (Data Manager), compacting databases 41—43
Access databases (Data Manager), creating data tables 46—47
Access databases (Data Manager), creating databases 45—46
Access databases (Data Manager), creating queries 60—61
Access databases (Data Manager), creating relationships 57—59
Access databases (Data Manager), deleting data tables 55
Access databases (Data Manager), deleting indexes from data tables 54
Access databases (Data Manager), deleting records from data tables 64
Access databases (Data Manager), editing indexes in data tables 55—63
Access databases (Data Manager), encrypting/ decrypting databases 43—45
Access databases (Data Manager), locating records in data tables 63—64
Access databases (Data Manager), opening databases 40—41
Access databases (Data Manager), refreshing records in data tables 63
Access databases (Data Manager), repairing databases 41—43
Access databases (Data Manager), saving queries 60—61
Access databases (Data Manager), updating records in data tables 63
Access Rights scheme 669—670
Access Rights scheme, adding rights-checking to applications 688—692
Access Rights scheme, building User Access Rights Maintenance form 670—686
Access Rights scheme, rights levels 669
Access Rights scheme, running forms 686—688
Access rights schemes 649
Access SYSTEM Security (Microsoft), limitations 646—648
Action parameter (Validate event) 111
ADD COLUMN clause 503—505
Add Database to Report...command (Database menu) 200
Add Ins menu commands, adding Visdata to 228—230
Add Ins menu commands, Report Designer 180
Add Rows Per Page Prop (Visdata multiuser setting) 261
adding see also "Inserting"
Adding fields to data tables 332—333
Adding fields to data tables, Data Manager 47—50
Adding indexes, to data tables (Data Manager) 51—54
Adding indexes, to databases (Visdata) 254—255
Adding records to data tables 13—16
Adding records to data tables, CompanyMaster data entry form 171
Adding records to data tables, Data Manager 61—63
Adding tables to databases 252—253
Adding Visdata to Visual Basic Add-Ins menu 228—230
AddNew method, writing to data sets 367
AfterColUpdate event (data-bound grid control) 436
AfterDelete event (data-bound grid control) 433
Afterinsert event (data-bound grid control) 433
AfterUpdate event (data-bound grid control) 433
Aggregate functions (SQL) 282—283
Aligning controls (designing forms) 118
AllowAddNew property (data grid control) 431
AllowDelete property (data grid control) 431
ALTER TABLE statement (SQL) 519—520
ALTER TABLE...ADD COLUMN statement (SQL) 503—505
ALTER TABLE...DROP COLUMN statement (SQL) 503—505
Ampersand (&), Caption property 13
AND operator (SQL) 278
ANSI SQL standards, compared to Microsoft JET SQL 273
API (Application Programming Interface) calls 609—611
API (Application Programming Interface) calls, allocating environment handles 613
API (Application Programming Interface) calls, data sources, connection handles 615
API (Application Programming Interface) calls, declaring 608
API (Application Programming Interface) calls, environment handles 616
API (Application Programming Interface) calls, local variables 612—613
API (Application Programming Interface) calls, low-level API calls 611—612
API (Application Programming Interface) calls, routines, error routines 617
API (Application Programming Interface) calls, routines, high-level routines 618—633
API (Application Programming Interface) calls, routines, mid-level routines 613—618
API (Application Programming Interface) calls, wrappers 612
Append queries 528—534
application security 648—649
Application security, access rights schemes 649
Application security, audit logs 648 692
Application security, audit logs, creating audit trails 693—696
Application security, audit logs, developing User Audit system 692
Application security, audit logs, recording user activity 697—698
Applications, online help 702
Applications, online help, adding help commands to menus 719—721
Applications, online help, authoring tools 725—726
Applications, online help, contents pages 714—715
Applications, online help, creating topic files 703—710
Applications, online help, designing help system 726—727
Applications, online help, jumps 714
Applications, online help, linking to applications 713
Applications, online help, project files 711—712
Applications, online help, properties for attaching files 713—714
Area graphs 391
Arrange command (Windows menu) 748
Arrays 637
AS keyword (SQL) 282
ASC keyword (SQL) 508
Asterisk (*), SQL statements 275
Asterisk (*), wildcard character 530
Attaching external data tables to databases 334—336
Attaching external data tables to databases, Data Manager 55—57
Attachments command (JET menu) 256—258
audit logs 648 692
Audit logs, creating audit trails 693—696
Audit logs, developing User Audit system 692
Audit logs, recording user activity 697—698
Authoring tools for help files 725—726
AutoInc property (graph control) 393
AVG (SQL aggregate function) 282
BackColor property (forms) 117
Backgrounds, default colors (designing forms) 117
Backing up tables 539
BackStyle property (forms) 117
Bad file mode error 462
Bad filename or number error 462
Bad record length error 462
Bad record number error 462
Bands (Crystal Reports Writer) 181—182
Bands (Crystal Reports Writer), detail bands 183—186
Bands (Crystal Reports Writer), header and footer bands 187—192
Bar charts 391
BAS modules, creating 146—147
BeforeColUpdate event (data-bound grid control) 436
BeforeDelete event (data-bound grid control) 433
BeforeInsert event (data-bound grid control) 433
BeforeUpdate event (data-bound grid control) 433
BeginTrans keyword 593
BETWEEN...AND clause (SQL) 278
BINARY data field type 26 34
Bookmark property (Dynaset data objects) 80—82
Bookmarks, records, searching 357—338
Bookmarks, Table data objects 88—89
BOOLEAN data field type 26—27 34
BOOLEAN data field type, testing 29
Border and Colors...command (Format menu) 199
Bound checkbox controls 113—114
Bound controls, checkbox controls 113—114
Bound controls, creating 358—360
Bound controls, data controls 100
Bound controls, designing data entry forms 360—361
| Bound controls, enabling 368
Bound controls, image controls 114—115
Bound controls, input controls, inserting into forms 9—10
Bound controls, label controls 112—113
Bound controls, routines, BtnBarEnable 374
Bound controls, routines, BtnBarInit 372—374
Bound controls, routines, BtnBarProcess 375—379
Bound controls, routines, RecDelete 369
Bound controls, routines, RecEnable 368
Bound controls, routines, RecError 369—371
Bound controls, routines, RecInit 363—364
Bound controls, routines, RecLocate 364—365
Bound controls, routines, RecRead 366
Bound controls, routines, RecWrite 367—368
Bound controls, routines, RSOpen 361—363
Bound controls, text controls 112—113
Bound data controls 100
Bound image controls 114—115
Bound input controls, inserting into forms 9—10
Bound label controls 112—113
Bound text controls 112—113
BoundColumn property (data-bound list control) 423
BoundText property (data-bound list control) 423
Box command, Format menu 199
Box command, Insert menu 198
Browse Field Data...command (Edit menu) 195—196
Browse sequences (online help) 708—709
BtnBarEnable routine 374
BtnBarEnable routines 359
BtnBarInit routine 359 372—374
BtnBarProcess routine 359 375—379
Building, command button arrays (BtnBarInit routine) 372—374
Building, data entry forms (ODBC) 633—634
Building, tables (Visdata) 254
Buttons, BtnBarProcess routine 375—379
Buttons, building (BtnBarInit routine) 372—374
Buttons, coding (Crystal Reports controls) 211—212
Buttons, CompanyMaster data entry form 169—173
Buttons, Delete command button, inserting into forms 13—16
Buttons, enabling (BtnBarEnable routine) 374
Buttons, New command button, inserting into forms 13—16
BYTE data field type 26—27 34
BYTE data field type, testing 29—30
Can't rename with different drive error 462
Caption property (data controls) 7—8
Cascade command (Windows menu) 747
Cascading, errors 451—453
Cascading, updates/deletes 587—588
Cascading, updates/deletes, building demo project 588—591
Cascading, updates/deletes, guidelines 592—593
Cascading, updates/deletes, running project 591—592
cBottomTitle argument (ShowGraph routine) 406
Centering forms 663
cFldLabel argument (ShowGraph routine) 406
cFldLegend argument (ShowGraph routine) 406
cFldSet argument (ShowGraph routine) 403
Checkbox controls, bound 113—114
CheckSize function (input validation library) 152—153
Clauses (SQL) see also "Keywords"
Clauses (SQL), BETWEEN...AND 278
Clauses (SQL), CONSTRAINT 502
Clauses (SQL), DISTINCT 285—287
Clauses (SQL), DISTINCTROW 285—287
Clauses (SQL), FOREIGN KEY...REFERENCES 514—518
Clauses (SQL), GROUP BY...HAVING 289—290
Clauses (SQL), INNER JOIN 291—292
Clauses (SQL), JOIN 290—293
Clauses (SQL), LEFT JOIN 292—293
Clauses (SQL), ORDER BY 276—277
Clauses (SQL), PRIMARY KEY 502 510—511
Clauses (SQL), RIGHT JOIN 293
Clauses (SQL), TOP n 287—288
Clauses (SQL), TOP n PERCENT 287—288
Clauses (SQL), UNION 293—294
Clauses (SQL), UNIQUE KEY 511—513
Clauses (SQL), WHERE 277—282 537
cLeftTitle argument (ShowGraph routine) 406
Clone method 73
cloning Dynaset data objects 73—80
Close command (File menu) 193
Close Database command (File menu) 41 232 245
Closing databases (Data Manager) 41
Code routines, compared to data controls 348—349
Coding data entry forms (ODBC) 634—640
Collating Order property (Database data access object) 322
collections 303
Collections, Database data access object 320
Collections, DBEngine data access object 305
Collections, TableDef data access object 328
Collections, Workspace data access object 312
Colors, designing forms 118—125
Colors, designing forms, custom colors 122—123
Colors, designing forms, default background colors 117
Colors, designing forms, input areas 117
Colors, designing forms, standard colors 121—122
Colors, designing forms, system colors 123—125
Column-level events (data-bound grid control) 436—437
Columns, data normalization 562
Columns, length 501
Command buttons, BtnBarProcess routine 375—379
Command buttons, building (BtnBarInit routine) 372—374
Command buttons, coding (Crystal Reports controls) 211—212
Command buttons, CompanyMaster data entry form 169—173
Command buttons, Delete command button, inserting into forms 13—16
Command buttons, enabling (BtnBarEnable routine) 374
Command buttons, New command button, inserting into forms 13—16
Commands, // (SQL-VB comment) 499
Commands, Add Ins menu (Report Designer) 180
Commands, Database menu, Add Database to Report... 200
Commands, Database menu, Links... 200
Commands, Database menu, Log Off Server 200
Commands, Database menu, Log On Server 200
Commands, Database menu, Remove from Report... 200
Commands, Database menu, Set Alias... 200
Commands, Database menu, Set Location... 200
Commands, Database menu, Show SQL Query 200
Commands, Database menu, Verify Database 200
Commands, Database menu, Verify on Every Print 200
Commands, dbClose (SQL-VB) 500
Commands, dbMake (SQL-VB) 499
Commands, dbOpen (SQL-VB) 499
Commands, Edit menu, Browse Field Data... 195—196
commands, Edit menu, Copy 30 195
commands, Edit menu, Cut 195
Commands, Edit menu, Delete Section... 196
Commands, Edit menu, Formula... 195
Commands, Edit menu, Group Section... 196
Commands, Edit menu, Links... 196
Commands, Edit menu, Object 196
commands, Edit menu, Paste 30 195
commands, Edit menu, Paste Special 195
Commands, Edit menu, Select Fields 195
Commands, Edit menu, Send Behind Others 196
Commands, Edit menu, Show/Hide Sections... 196
Commands, Edit menu, Summary Field... 195
Commands, Edit menu, Text Field... 195
commands, File menu, Close 193
Commands, File menu, Close Database 41 232 245
Commands, File menu, Compact Database 42 249—250
Commands, File menu, Decrypt 44
Commands, File menu, Edit 748 762
Commands, File menu, Encrypt 43
Commands, File menu, Errors 245
commands, File menu, Exit 194 748
Commands, File menu, Exit Visdata 251
Commands, File menu, Make EXE File 228 763
Commands, File menu, Make Visdata a VB Add-In 229 251
commands, File menu, New 247—249 748
Commands, File menu, New Database 45
Commands, File menu, New Project 4
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå