Programming MicrosoftВ® Office Access 2003 (Core Reference) (Pro-Developer)

K-L

Keep Together property (sorting report data), Sorting and Grouping by Date

Key object, The Key Object

Keys collection (Table object), The Table Object

keys, index, The Table Object

keyset cursors , recordset, Selected Recordset Properties

Label controls in forms, Creating a Splash Screen

Label controls in forms\

Caption property, Automatically Publishing a Datasheet to a Web Site

hyperlinks, creating, Navigating with Hyperlinks

TextAlign property, Summing Subform Control Values on a Main Form

Label Wizard, Creating Reports with Wizards

Label Wizard<$endrange>, Using the Label Wizard

Label Wizard<$startrange>, Using the Label Wizard

labels, printing, Creating Reports with Wizards

labels, printing<$endrange>, Using the Label Wizard

labels, printing<$startrange>, Using the Label Wizard

labels, printing\

producing in Microsoft Word<$endrange>, Figure 9.9:     Excerpts from a Word document for printing form letters .

producing in Microsoft Word<$startrange>, Producing Mailing Labels

LanguageSettings objects, Table 8.1: Shared Office Objects

LastRecord property (DataSource object), Producing Form Letters

left outer joins, Right Outer Joins

Left setting (report controls), Programmatically Creating a Report with Controls

Length setting (report controls), Programmatically Creating a Report with Controls

letters, producing in Microsoft Word<$startrange>, Producing Form Letters

LIKE argument, Writing Criteria Expressions with Wildcards

LIKE operator with datetime column values<$endrange>, Using the LIKE Operator with datetime Column Values

LIKE operator with datetime column values<$startrange>, Using the LIKE Operator with datetime Column Values

line charts \

time-based<$endrange>, Creating a Time-Based Line Chart

time-based<$startrange>, Creating a Time-Based Line Chart

3-D<$endrange>, Creating a 3-D Line Chart

3-D<$startrange>, Creating a 3-D Line Chart

Line method (reports), Formatting Reports with the Print Event

linked tables, Understanding Access Projects

linked tables<$endrange>, Importing Data from Text Files

linked tables<$startrange>, Linking Using the DoCmd Method

linking databases\

through Connection object<$endrange>, Importing Data from Text Files

through Connection object<$startrange>, Linking via the Connection Object

through DoCmd method<$endrange>, Importing Data from Text Files

through DoCmd method<$startrange>, Linking Using the DoCmd Method

linking forms to data\

single data source<$endrange>, Processing Main/Subforms

single data source<$startrange>, Linking Forms to a Single Record Source

single data source\

ADO recordsets as source<$endrange>, Assigning a SQL Statement as the Source, Processing Main/Subforms

ADO recordsets as source<$startrange>, Updating Form Data with an ADO Recordset Assignment

SQL statements as source<$endrange>, Processing Main/Subforms

SQL statements as source<$startrange>, Assigning a SQL Statement as the Source

ADO recordsets as source<$startrange>, Assigning an ADO Recordset as the Source

linking tables in database diagrams<$endrange>, Figure 11.14:     The three panes for the Access project Query Designer with a view that sorts orders by Freight ...

linking tables in database diagrams<$startrange>, Linking Two Tables in a Database Diagram

linking to Office applications<$endrange>, Closing an Automation Reference

linking to Office applications<$startrange>, Linking Access to Other Office Applications

linking to Office applications\

Automation, Automation, Closing an Automation Reference

CreateObject and GetObject functions, CreateObject vs. GetObject , Running Excel Procedures from an Access Procedure

Excel. <charcntd>See <Default Para Font>Microsoft Excel application, linking to<$nopage>, Chapte 9: Integrating Access with Other Office Applications

ISAM drivers<$endrange>, The OpenDataSource Method

ISAM drivers<$startrange>, Installable ISAM Drivers

OpenDataSource method, The OpenDataSource Method

Outlook. <charcntd>See <Default Para Font>Microsoft Outlook application, linking to<$nopage>, Chapte 9: Integrating Access with Other Office Applications

Word. <charcntd>See <Default Para Font>Microsoft Word application, linking to<$nopage>, Chapte 9: Integrating Access with Other Office Applications

LinkNWCustomers(  ) (example), Importing Data from Text Files

LinkODBCAuthors(  ) (example), Importing Data from Text Files

LinkXLCustomers(  ) (example), Linking Using the DoCmd Method

list boxes, displaying query results<$endrange>, Figure 5.23:     These forms let the user see monthly sales data for a selected year.

list boxes, displaying query results<$startrange>, Displaying Returned Rows Via a List Box

list boxes\

AddItem, RemoveItem methods , Controlling FileType with a Custom Form and Procedure

ListAllForms(  ) (example), Enumerating Forms and Controls

ListAllFormsElsewhere( ) (example), Enumerating Reports

ListAllReports( ) (example), Enumerating Reports

ListAllReportsElsewhere( ) (example)<$startrange>, Enumerating Reports

ListAllReportsElsewhere(  ) (example)<$endrange>, Mailing Snapshots

ListCommands(  ) (example), Listing Menu Commands

ListCOntrolsOnOpenForms(  ) (example), Enumerating Forms and Controls

listing. <charcntd>See <Default Para Font>enumerating<$nopage>, Populating Tables with Data

ListLinkedTables(  ) (example), Importing Data from Text Files

ListMyPages(  ) (example), Enumerating Data Access Pages and Their Properties

ListSiteFilesAndFolders( ) (example), Printing the Properties for Web Folder Contents

ListTablesRaw( ) (example), Listing All Table Types in a Catalog

ListTablesTypeFilter( ) (example), Filtering Table Types Before Enumerating

LockType property (Recordset object), Connecting to Jet Databases, Selected Recordset Properties

LockTypeEnum enumeration, Table 1.3: LockTypeEnum Members

login accounts<$endrange>, Login and User Accounts, Creating Login and User Accounts with T-SQL

login accounts<$startrange>, Login and User Accounts, Programming Login and User Accounts

login accounts\

<charcntd>See also<Default Para Font>permissions<$nopage>, Roles

<charcntd>See also<Default Para Font>roles<$nopage>, Roles

creating with SQL-DMO<$startrange>, Creating Login and User Accounts with SQL-DMO

creating with T-SQL<$endrange>, Creating Login and User Accounts with T-SQL

creating with T-SQL<$startrange>, Creating Login and User Accounts with T-SQL

login  accounts\

creating  with  SQL-DMO<$endrange>, Testing User Accounts

LoginSecureAndListDBs(  )  (example), Setting Mixed Authentication

LoginSecureAndListDBs2( ) (example), Building a SQL Server Object Navigator

LookIn property (FileSearch object), Conducting a Basic File Search, Searching Based on File Contents

LookIn property (FileSearch object)\

<charcntd>See also <Default Para Font>FileSearch objects<$nopage>, Generalizing a Search and Sorting Its Return Set

lookup forms<$startrange>, Looking Up and Displaying Data

lookup forms\

charting data subsets <$startrange>, Charting a Subset of Data

dynamic information display, Dynamically Displaying Information

interactivity with parameter queries and ADO <$endrange>, Figure 5.23:     These forms let the user see monthly sales data for a selected year.

interactivity with parameter queries and ADO <$startrange>, User Interactivity Based on Parameter Queries and ADO

results displayed in list box<$endrange>, Figure 5.23:     These forms let the user see monthly sales data for a selected year.

results displayed in list box<$startrange>, Displaying Returned Rows Via a List Box

results displayed in message box<$endrange>, Displaying Results in a Message Box, Figure 5.22: