Share this Page URL
Help

Index > Index - Pg. 678

Index Connection objects, ADO, 185, 605, 611 Connection property, 605 ConnectionFile property, 442 connections ADO Connection objects, 185, 605, 611 connection strings, 325, 420, 442 data access page, 420, 442 Office Spreadsheet component, 446 Office Web Component, 454 to SharePoint Services sites, 538 trusted SQL Server, 505, 510 ConnectionString property, 420, 442 consistency, data, 74 Const keyword, Visual Basic, 146 constants, ADO cursor type, 608 constants, Visual Basic built­in, 143 scope and, 155 storing, in standard modules, 145 variables vs., 142 CONSTRAINT keyword, 325 constraints project, 519 terminology, 32 XML, 565, 574 contacts, Outlook, 559 (see also Outlook) Continuous Forms view, 233 Control Box property, 275 Control Source property, 242, 266, 347, 370, 436, 592 control structures, Visual Basic, 157 controls, 226 (see also forms) (see also reports) adding smart tags to, 492 adding, to forms, 260 assigning macros to events, 462 background color, 271 binding, to specific fields, 242 bound, 592 bound and unbound, on reports, 348 command button, 21 conditional formatting of, 275 customizing data access page, 436 data management properties, 299 enabling, 276 form design guidelines and, 226 formatting, with properties, 256 forms and, 9 locking, 297 moving, sizing, and aligning, in forms, 248, 258 names of report, 372 Office Web Components (see Office Web Components) references to, 180, 187 selecting multiple, 250, 255 setting tab order of, 258 subform, 282 (see also subforms) subreport, 365 tab, 281 turning on and off, 295 values of, in query and filter criteria, 287 visibility of, and accessing values, 302 Controls Wizard, 21 Conversion Errors table, 633 conversions charts to images, 357 combo boxes to text boxes, 263 data, 108 databases, 72 databases to SQL Server, 503 macros to Visual Basic code, 138 multiuser databases, 631 Visual Basic data types, 191 Convert Database command, 631 Convert Database Into dialog box, 634 Convert dialog box, 138 copying data between tables, 48, 54 databases (see backing up) corrupted files, 624 Count function, 215 Count property, 160, 179, 182 Create Back­End Database dialog box, 124 CREATE INDEX statement, 325 Create Relationships dialog box, 524 CREATE TABLE statement, 325 CreateForm method, 408 CreateItem method, 595 CreateObject method, 605, 611 CreateQueryDef method, 223 criteria filter, 198 report, 354 report grouping, 339 select query, 212 SQL and query, 312 stored procedure, 533 update query, 315 Criteria row, 320, 323, 355 crosstab queries, 304, 333, 342, 380 (see also queries) Crosstab Query Wizard, 304, 308 CS suffix, 506 CStr function, 191 Ctrl key, 291 Ctrl+Break key combination, 171, 172 Currency data type, 7 Current Tasks_Files folder, 455 CurrentData object, 179 CurrentProject object, 179, 182, 605 cursor types, ADO, 607, 611 CursorType property, 608, 609 Custom Popup dialog box, 478 Custom Popup Properties dialog box, 478 Customize AutoFormat dialog box, 351 Customize dialog box, 470, 480, 482 Customize Input Mask Wizard dialog box, 94 customizing appearance of forms, 269 built­in toolbars and menu bars, 486 colors, 271 creating menu bars, 470, 481 creating shortcut menus, 479 custom Visual Basic report feature, 586 data access page controls, 436 protecting custom toolbars, 496 report autoformats, 351 SharePoint Services views, 545 678 D DAO (Data Access Objects), 182, 223, 311 data, 74, 194