Access Data Analysis Cookbook (Cookbooks)
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] caching algorithms client/server applications and considerations object references Calendar control 2nd 3rd Call construct callback functions adding items 2nd cautions with communicating without email creating filling list boxes via PowerPoint presentations required parameters for retrieving information 2nd selecting backup database sorted list of files 2nd Cancelled property (forms) CanGrow property (text boxes) changing lines to match resizing with suggestions for CanShrink property (text boxes) changing lines to match conflict with Image control resizing with Caption property (buttons) 2nd Caption property (combo boxes) Caption property (fields) Caption property (forms) Caption property (labels) creating status meters internationalizing messages captions changing Access changing on buttons determining window carry-forward feature case conversions 2nd case sensitivity converting to uppercase determining keypresses in queries centimeters, conversions Change event accelerating multiuser applications improving form performance searching list boxes and 2nd sending email Tab control and characters, keypresses as Chart object 2nd 3rd charts (Excel) Choose function Chr$(0) value Chr$(34) value 2nd class modules class names FindWindow function and for Windows applications Class_Initialize event handler classes helper inaccessible ClassName property (controls) 2nd Click event 2nd backing up selected objects bookmarking records Calendar control carrying data forward creating geographical map interfaces creating status meters dialog forms displaying system menu embedding sound files flashing titlebars handling form expansion improving form performance multiuser applications 2nd navigation buttons online help opening multiple instances of form passing parameters preloading forms 2nd recursion and setting margins tracking open shared databases client/server applications ClipCursor subroutine (Windows API) Close event form closing keyboard shortcut multiple instances of forms 2nd preloaded forms saving settings with CloseButton property (forms) 2nd CloseConnection method (CurrentProject object) CloseCurrentDatabase method (Application object) 2nd Cold Fusion collaborative, team-based web sites collections multiple form instances 2nd renumbering tracking users/groups ColorMode property (Printer object) 2nd colors built-in constants for highlighting current field previewing supplied with template style Column property (list boxes) ColumnCount property (combo boxes) 2nd ColumnCount property (forms) ColumnCount property (list boxes) 2nd 3rd 4th ColumnHeadings property (queries) ColumnHeads property (combo boxes) 2nd ColumnHeads property (list boxes) columns bound columns changing settings creating reports with multiple crosstab query minimum formatted dates semicolon and Columns tab (Page Setup dialog) ColumnSpacing property (Printer object) ColumnWidths property (combo boxes) 2nd ColumnWidths property (list boxes) 2nd 3rd COM programs calling .NET components combo boxes accepting new entries adding items 2nd allowing N/A option changing text boxes into choosing default printer with choosing from fixed lists client/server applications and controls as parameters customizing report grouping displaying and collecting information faster loading of linking values omitting from templates performance bottlenecks command buttons achieving exact placement as UI method communicating without email 2nd creating geographical map interfaces Name property and omitting from templates parameter queries PictureData property and resizing forms and actions of transparent COMMAND.COM COMMDLG.OCX (ActiveX control) Common Language Runtime common Windows File Open/Save dialogs communication setting up with Excel without email comparisons case-sensitive string non-equality complexType XML Schema element concatenation accommodating more fields with AutoNumber fields and string limitations concatenation operators Connect property (tables) ConnectionFile property (pages) 2nd connections client/server applications and 2nd creating and canceling dynamic to SQL Server mail merges storing information in DAPs ConnectionString property (DataSource control) constants for colors intrinsic Access 2nd two-quote rule and zero-length string constructor constructors parameterized, calling .NET components containing contacts, adding Container objects 2nd Containers collection list-filling function and ownership information saved objects and containers, documenting 2nd continuous forms creating multipage forms as DefaultView property 2nd 3rd control sources 2nd ControlBox property (forms) cautions using eliminating menus for forms preloading forms and controls 2nd 3rd 4th active as parameters assigning properties bound controls 2nd 3rd creating on all pages creating simple bar graphs creating status meters for page breaks label controls 2nd limitations of adding properties to navigation omitting on reports partitioning 2nd performance bottlenecks placing data in setting tab order for sizing in forms SmartTags property ControlSource property (combo boxes) ControlSource property (controls) Calendar control concatenation operators ControlSource property (text boxes) communicating without email creating page-range indicator reports with line numbers Sum function and ControlSourceTimerInterval property (text boxes) ControlTipText property (buttons) ControlTipText property (message boxes) cookies 2nd Copies property (Printer object) 2nd CopyObject action 2nd Count property (Groups collection) Count(*) expression CREATE INDEX (SQL) statement CREATE TABLE (SQL) statement 2nd CreateGroup function (Windows shell) 2nd CreateGroupLevel function CreateObject function 2nd 3rd CreateProperty method (objects) 2nd CreateReportControl function CreateWorkspace method (DBEngine object) 2nd 3rd Creator user 2nd crosstab queries aging analysis correct sorting parameters in Current event combo boxes determining if new record enabling/disabling buttons and navigation buttons option groups sending email CurrentProject object 2nd CurrentUser function communicating without email form customization and retaining editing information tracking changes with user-level security and Cursor property (labels) CursorLocation property (recordsets) cursors 2nd Cycle property (forms) control over row movement with creating multipage forms and features of restricting cursor movement with |