[ Pobierz całość w formacie PDF ]
.See also concatenation introduced, 108append queries, 800 queries, in, 144case conversion of data entered, 147, 148, 153, 221 storage size, 136case conversion using macros, 940 type of data stored, 136comparison operations, 325 326, 377 381 validation, 222dates, converting to strings, 672 Visual Basic equivalent, 1005fields, joining text with, 672 673 Text Qualifier, 728, 734length of string, returning, 335 text shadow, 477 479, 629 631line wrap, 402, 877, 882 Text SQL Server data type, 1129lowercase, returning, 335 Time( ) function, 334macros, adding conditional text using, 954 time operationsrightmost characters of string, returning, 335 current time, returning, 333, 334spaces, removing unwanted, 870 delimiters, 735string data type, changing to/from, 333, 672 expressions, in, 339uppercase, returning, 334 format, 149 150validation rules, 155 forms, inserting time in, 264Text Align property, 482 functions related to, 334text box controls.See also controls importing text files, format in, 731 732, 7353-D effects, 481 validation rules, 156alignment, 417, 482 timeout settings, 824background color, 481 TimerInterval event property, 923borders, 481 timestamps, 1129, 1145 3596-X Index.F 5/30/01 11:52 AM Page 1340Index &' T U1340Tinyint SQL Server data type, 1129 TOP query clause, 1163title bar, 56 57, 58, 434 435, 906, 1086 TOP SELECT predicate, 830TodaysDate variable, 974 Top text box property, 481toggle button controls Top Values property, 824creating, 504, 641 642 transactions, 825, 924datasheets, in, 854 TransferDatabase macro action, 958described, 197 TransferSpreadsheet macro action, 958images in, 504 505, 642 643 TransferSQLDatabase macro action, 958raised, 484 TransferText macro action, 958reports, in, 642 transparency, color, 474, 478, 485values returned, 403, 502 Trim( ) function, 870visual display, 403, 504tokens, HTML template, 1205 1206UTomCat.XLS (on the CD), 532Ucase( ) function, 333, 334, 940Toolbar Properties dialog box, 1070, 1078UDFs.See user-defined functions (UDFs)Toolbar property, 443, 1084Unbound Form Utilities module (on the CD), 1172toolbars.See also menu barsUNC.See Universal Naming Convention (UNC)Access window, 56, 57Undo Batch Edit event property, 924commands, adding, 1083Unicode Compression property, 146creating, 57, 1082 1083Uniform Resource Locators (URLs), 1180Datasheet window, 215 218Union command, 815Formatting toolbar, 448, 472 474Unique Records property, 824forms, attaching to, 443, 1084 1085Unique Values property, 824icons, 1074, 1082uniqueidentifier SQL Server data type, 1129items, adding, 1068UniqueTable property, 1230, 1231, 1233, 1235 1236items, creating, 1068Universal Naming Convention (UNC), 1225, 1248items, moving, 1068UpdateCtr controls, 1170items, removing, 1068upgrading from earlier versions, 25, 28 29menu bars, changing to, 1071upsizingpop-up shortcut menus, changing to, 1078ActiveX Data Objects (ADO), 1157Query Design window, 277 278application creation, 1154 1157separator lines, 1083application options, 1147startup options, 1086backing up before, 1143text, customizing, 1075connection information, entering, 1144, 1153Toolbars Menu, 1071Data Access Objects (DAO), 1157Toolboxdisk space considerations, 1143customizing, 535forms, 1147Form Toolbox, 74, 398, 410, 412 413indexes, 1145introduced, 61, 74keys, primary, 1145Report Design Toolbox, 310login ID, 1144, 1153Tools ª' Analyze ª' Documenter, 161macros, 1147, 1157Tools ª' Analyze ª' Table, 187modules, 1147, 1157Tools ª' AutoCorrect, 556object conversion, 1147, 1157Tools ª' Database Utilities ª' Convert Database ª' To, 41permissions needed, 1143Tools ª' Database Utilities ª' Database Splitter, 711preparation for, 1143Tools ª' Database Utilities ª' Linked Table Manager, 717printer, default, 1143Tools ª' Macro, 905project, creating new, 1147, 1154 1155Tools ª' Macro ª' Convert Form s Macros to Visualproject, default name, 1154Basic, 989queries, 1147Tools ª' Macro ª' Create Menu, 1065referential integrity error alerts, 1148Tools ª' Options, 56report snapshot, 1148 1149, 1155 1156Tools ª' Options ª' Advance, 40reports, 1147Tools ª' Relationships, 178tables, SQL Server attribute selection, 1146, 1154Tools ª' Startup, 906tables in, 1144, 1145, 1147, 1149, 1150Tools ª' Startup ª' Application Title, 58time needed, 1148tooltips, 57, 128, 1085.See also screen tipstimestamp fields, 1145Top( ) function, 272, 811 812validation, data, 1145Top label property, 481validation, user, 1147, 1154Top Margin property, 482 3596-X Index.F 5/30/01 11:52 AM Page 1341Index &' U V1341Upsizing Wizard, 1142 1150, 1152 1157 declaration using Public statement, 1001 1002usability hierarchy, 5 6 expression results, assigning to, 998Use Transaction property, 825 naming, 999Use Triggers option, 1145 private, 1002/Usercommand, 46 public, 1001 1002user profiles, applying at startup, 46 referencing in other modules, 1002user-defined functions (UDFs), 1165 1166 Response variables, 1033user-defined SQL Server data type, 1129 storage allocated for, 999usernames, 46 string variables, 1003users, maximum concurrent, 1115 1116 undeclared, 1000uses, 998variant data type, 1000, 1004VVBA.See Visual Basic Application edition (VBA)Val( ) function, 333versionsValid Row Source Type property, 508 509back-version compatibility, 12, 39 40, 124validation, data
[ Pobierz całość w formacie PDF ]