|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Amundsen M., Smith C. — Teach Yourself Database Programming With Visual Basic 4 in 21 Days |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
Commands, File menu, New | Cross-Tab... 193
Commands, File menu, New | dBASE 248—249
Commands, File menu, New | FoxPro 248—249
Commands, File menu, New | JET 247—248
Commands, File menu, New | Mailing Labels Report 193
Commands, File menu, New | Paradox 248—249
Commands, File menu, New | Report... 193
Commands, File menu, New | Text 249
Commands, File menu, Open Database 40 231—232 239—245
Commands, File menu, Open Database | dBASE 240—241
Commands, File menu, Open Database | Excel 242—243
Commands, File menu, Open Database | FoxPro 241
Commands, File menu, Open Database | JET Engine MDB 239—240
Commands, File menu, Open Database | ODBC 244—245
Commands, File menu, Open Database | Paradox 241
Commands, File menu, Open Database | Text Files 244
Commands, File menu, Open Project 227
Commands, File menu, Open... 6 193
Commands, File menu, Options... 194
Commands, File menu, Page Margins 194
commands, File menu, Print Preview 186 194
Commands, File menu, Print | Export 194
Commands, File menu, Print | Printer 194
Commands, File menu, Print | Report Definition 194
Commands, File menu, Printer Setup 194
Commands, File menu, Properties 245—247
Commands, File menu, Properties | Database 246—247
Commands, File menu, Properties | DBEngine 246
Commands, File menu, Properties | Workspace 246
Commands, File menu, Repair Database 42 250—251
Commands, File menu, Run 748 763
commands, File menu, Save 193
Commands, File menu, Save As... 193
Commands, File menu, Save Project 9
Commands, Format menu, Border and Colors... 199
Commands, Format menu, Box 199
Commands, Format menu, Field... 199
Commands, Format menu, Font... 199
Commands, Format menu, Graphic... 199
Commands, Format menu, Line 199
Commands, Format menu, Section... 199
Commands, Help menu (About) 747
Commands, Insert menu, Box 198
Commands, Insert menu, Database Field... 197
Commands, Insert menu, Formula Field... 197
Commands, Insert menu, Grand Total... 198
Commands, Insert menu, Graphic... 198
Commands, Insert menu, Group Section... 198
Commands, Insert menu, Line 198
Commands, Insert menu, MDIForm 740
commands, Insert menu, Module 147 749
commands, Insert menu, Object 198
Commands, Insert menu, Procedure 102 750
Commands, Insert menu, Special Field | Group Number Field 197
Commands, Insert menu, Special Field | Page Number Field 197
Commands, Insert menu, Special Field | Print Date Field 197
Commands, Insert menu, Special Field | Record Number Field 197
Commands, Insert menu, Subtotal... 197—198
Commands, Insert menu, Summary... 198
Commands, Insert menu, Text Field... 197
Commands, JET menu, Attachments 256—258
Commands, JET menu, Multiuser Settings 260—261
Commands, JET menu, Relations 258—260
Commands, JET menu, SYSTEM.MDA 261
Commands, Options menu (Environment) 9 119
Commands, Preferences menu, Include System Files 268
Commands, Preferences menu, Login Time-Out Value 268
Commands, Preferences menu, Open Last Database 267
Commands, Preferences menu, Query Time-Out Value 268
Commands, Preferences menu, Show Performance Numbers 267
Commands, Report menu, Edit Group Selection Formula 201
Commands, Report menu, Edit Record Selection Formula 201
Commands, Report menu, Group Sort Order 201
Commands, Report menu, Record Sort Order 201
Commands, Report menu, Refresh Report Data 202
Commands, Report menu, Report Title 202
Commands, Report menu, Save Data with Closed Report 202
Commands, Report menu, Select Groups 201
Commands, Report menu, Select Records 201
Commands, Report menu, Set Print Date 202
Commands, Run menu, Start 13
Commands, Run menu, Start with Full Compile 762
commands, Tools menu, Options 5
commands, Tools menu, References 304
Commands, Utility menu, DBList/DBCombo 265—267
Commands, Utility menu, Global Replace 264—265
Commands, Utility menu, Import/Export 265
Commands, Utility menu, Query Builder 262—264
Commands, Utility menu, View menu (Properties) 6
Commands, Utility menu, Windows menu, Arrange 748
Commands, Utility menu, Windows menu, Cascade 747
Commands, Utility menu, Windows menu, Tile 747
Comments (//) 753
CommitTrans keyword 593
CommonDialog control 462
Compact Database command (File menu) 42 249—250
CompactDatabase method 648
CompactDatabase method, DBEngine data access object 306 308—310
Compacting databases (Data Manager) 41—43
Company Logo controls (CompanyMaster data entry form) 168—169
CompanyMaster data entry form 156—176
CompanyMaster data entry form, basic form definition 156—159
CompanyMaster data entry form, command buttons 169—173
CompanyMaster data entry form, Company Logo controls 168—169
CompanyMaster data entry form, input controls 159—169
CompanyMaster data entry form, input validation 174—176
CompanyMaster data entry form, screen prompts 159—169
CompanyMaster data entry form, unloading 171
CompanyMaster project, creating data entry forms 380
CompanyMaster project, creating data entry forms, State/Province list form 381—386
CompanyMaster project, graphs, inserting 409—416
Compiling, help files 712
Compiling, SQL-VB project 762—763
Compiling, Visdata 227—228
Conditional fields, form level validation 145—146
Conditional fields, input validation 131
Connect property, data controls 101
Connect property, Database data access object 321
Constants, Action parameter (Validate event) 111—112
Constants, db Deny Write 106—107
Constants, dbAppendOnly 106—107
Constants, dbReadOnly 106—107
CONSTRAINT clause 502
Constraints (SQL) 509—510
Constraints (SQL), deleting 519—520
Constraints (SQL), FOREIGN KEY...REFERENCES 514—518
Constraints (SQL), PRIMARY KEY 510—511
Constraints (SQL), UNIQUE KEY 511—513
Contents pages for help files 714—715
Context strings (help topic files) 705—706
Control characters, input validation 134
Controls, arrays 637
Controls, BtnBarEnable routine 374
Controls, BtnBarInit routine 372—374
Controls, BtnBarInit routine, BtnBarProcess routine 375—379
Controls, BtnBarInit routine, checkbox controls 113—114
Controls, BtnBarInit routine, creating 358—360
Controls, BtnBarInit routine, data controls 100
Controls, BtnBarInit routine, designing data entry forms 360—361
Controls, BtnBarInit routine, enabling 368
Controls, BtnBarInit routine, image controls 114—115
Controls, BtnBarInit routine, input controls, inserting into forms 9—10
Controls, BtnBarInit routine, label controls 112—113
Controls, BtnBarInit routine, RecDelete routine 369
Controls, BtnBarInit routine, RecEnable routine 368
Controls, BtnBarInit routine, RecError routine 369—371
Controls, BtnBarInit routine, RecInit routine 363—364
Controls, BtnBarInit routine, RecLocate routine 364—365
Controls, BtnBarInit routine, RecRead routine 366
Controls, BtnBarInit routine, RecWrite routine 367—368
| Controls, BtnBarInit routine, RSOpen routine 361—363
Controls, BtnBarInit routine, text controls 112—113
Controls, CommonDialog 462
controls, copying 30
Controls, Crystal Reports controls, designing Print Report dialog box 204—208
Controls, Crystal Reports controls, inserting into forms 202—203
Controls, Crystal Reports controls, OK command button, coding 211—212
Controls, Crystal Reports controls, Print Report dialog box, coding 209—213
Controls, Crystal Reports controls, selecting report destinations 210—211
Controls, data controls 101—112
Controls, data controls, adding to forms 4—5
Controls, data controls, bound data controls 100
Controls, data controls, Caption property 7—8
Controls, data controls, compared to code routines 348—349
Controls, data controls, compared to Microsoft JET database engine 303
Controls, data controls, Connect property 101
Controls, data controls, Database data objects 94—95
Controls, data controls, DatabaseName property 5—7 101—104
Controls, data controls, dbAppendOnly option 106—107
Controls, data controls, dbDenyWrite option 106—107
Controls, data controls, dbReadOnly option 106—107
Controls, data controls, Error event 110—112
Controls, data controls, Exclusive property 104—105
Controls, data controls, Name property 7—8
Controls, data controls, Options property 105—107
Controls, data controls, Readonly property 104—105
Controls, data controls, Recordset data objects 93—94
Controls, data controls, RecordSource property 5—7 101—104
Controls, data controls, Refresh method 107—110
Controls, data controls, Reposition event 110—112
Controls, data controls, restoring (CompanyMaster data entry form) 172
Controls, data controls, UpdateControls method 107—110
Controls, data controls, UpdateRecord method 107—110
Controls, data controls, Validate event 110—112
Controls, data-bound combo boxes 425—430
Controls, data-bound grids, column-level events 436—437
Controls, data-bound grids, creating 430—431
Controls, data-bound grids, deleting records 431 435—436
Controls, data-bound grids, inserting records 431 433—437
Controls, data-bound grids, setting properties 432
Controls, data-bound grids, trapping events 433
Controls, data-bound grids, updating records 434—435
Controls, data-bound list boxes 429—430
Controls, data-bound lists 418—425
Controls, data-form grids (Subforms), creating 437—443
Controls, graph, design time 392
Controls, graph, displaying graphs onscreen 403—404
Controls, graph, inserting on forms 390
Controls, graph, labels 396—397
Controls, graph, legends 396—397
Controls, graph, library routines 398—409
Controls, graph, loading 389—390
Controls, graph, Pinnacle-BPS graph control 398
Controls, graph, points 391
Controls, graph, QuickData property 394—396
Controls, graph, runtime 392—394
Controls, graph, ShowGraph routine 403—404
Controls, graph, titles 396—397
Controls, graph, types 390—391
Controls, graph, writing to files 397—398
Copy command (Edit menu) 30 195
Copy Structure option (Visdata Table window) 234
copying, controls 30
Copying, tables (Make Table queries) 539—544
Correcting typing errors 103
COUNT (SQL aggregate function) 282
COUNTER data field type 26—27 533
COUNTER data field type, testing 32—33
Counting records in Dynasets 75—76
CREATE INDEX statement (SQL) 506—508
CREATE TABLE statement (SQL) 501—503
CreateDatabase method 648
CreateDatabase method, Workspace data access object 316—318
CreateDynaset method 73
CreateField method 330
CreateIndex method 330
CreateProperty method 330
CreateProperty method, Database data access object 326—327
CreateWorkspace method (DBEngine data access object) 307 314—315
Creating BAS modules 146—147
Creating Data Manager 46—47
Creating data tables in databases 330—331
Creating databases (Data Manager) 45—46
Creating Dynaset data objects 71 75
Creating forms for SQL-VB project 740—749
Creating Microsoft JET engine databases 252
Creating non-Microsoft JET databases 319
Creating procedures 102
creating projects 4
Creating queries (Data Manager) 60—61
Creating relationships (Data Manager) 57—59
Creating Workspace data access object 314—315
Crystal Reports controls, coding, OK command button 211—212
Crystal Reports controls, coding, Print Report dialog box 209—213
Crystal Reports controls, designing Print Report dialog box 204—208
Crystal Reports controls, inserting into forms 202—203
Crystal Reports controls, selecting report destinations 210—211
Crystal Reports Writer 180—215
Crystal Reports Writer, bands 181—182
Crystal Reports Writer, bands, commands, Database menu 199—200
Crystal Reports Writer, bands, commands, Edit menu 194—196
Crystal Reports Writer, bands, commands, File menu 193—194
Crystal Reports Writer, bands, commands, Format menu 199
Crystal Reports Writer, bands, commands, Insert menu 196—198
Crystal Reports Writer, bands, commands, Report menu 201—202
Crystal Reports Writer, detail bands 183—186
Crystal Reports Writer, fields 182
Crystal Reports Writer, header and footer bands 187—192
Crystal Reports Writer, page numbers 188
Crystal Reports Writer, starting 180—181
Crystal Reports Writer, trailing spaces, removing from fields 189—190
cTitle parameter (ShowGraph routine) 403
CURRENCY data field type 26 34
CURRENCY data field type, testing 31
Custom colors, designing forms 122—123
Custom controls (data-bound grid control) 430—431
Cut command (Edit menu) 195
Data Access Object interface, searching records 349
Data Access Objects 303—304 see
Data access objects, Database 319—327
Data access objects, Database collections 320
Data access objects, Database methods 322—327
Data access objects, Database properties 320—322
Data access objects, DBEngine 304—311
Data access objects, DBEngine collections 305
Data access objects, DBEngine methods 306—311
Data access objects, DBEngine properties 305—306
Data access objects, Field 336—337
Data access objects, Field properties 336—337
Data access objects, Index 338—339
Data access objects, QueryDef 340—341
Data access objects, Relation 341—344
Data access objects, selecting in Visdata 236
Data access objects, TableDef 328—336
Data access objects, TableDef collections 328
Data access objects, TableDef methods 330—336
Data access objects, TableDef properties 329
Data access objects, Workspace 312—319
Data access objects, Workspace collections 312
Data access objects, Workspace creating 314—315
Data access objects, Workspace methods 315—319
Data access objects, Workspace properties 312—313
data controls 101—112
Data controls, adding to forms 4—5
Data controls, bound data controls 100
Data controls, Caption property 7—8
Data controls, comparisons, to code routines 348—349
Data controls, comparisons, to Microsoft JET database engine 303
Data controls, Connect property 101
Data controls, Database data objects 94—95
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå