Index

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: