L

label

changing properties of, 86

selecting for a list box, 95

late binding, 295, 324

left join, 161

letters, creating Word from Access, 298–302

libraries

available for use in Access applications, 100

based on specific Access databases, 308–312

Libraries list, 93

life cycle

of a procedure, 45

of variables, 54

LIKE keyword, 515

LimitToList property, 193

LinkChildFields property, 194

linking

to SharePoint lists within Access, 225–232

situations for, 200

LinkMasterFields property, 194

links in SharePoint, 221

list box control

dragging onto a new form, 94, 95

populating, 422, 436–437

list boxes, versus combo boxes, 188–193

ListID parameter, 226

lists, choices in, 188

lng (Long) prefix, 55

LoadRecords procedure, 423, 437–438

local string variable, declaring, 219

local variables

adding for clsProjects, 372–373, 379

adding for Property Get and Property Set, 111

declaring and assigning values to, 40

declaring as Report objects, 97

declaring for clsProjects, 359, 366–367

in a procedure, 36

Local window, 24, 25

Locals Window, 68–69

Lock Project For Viewing option, 328

LockType property

of the Recordset object, 134, 317

setting, 143, 151

logic errors, 66

logical tiers, 18

Login parameter, 204

Long data type, 50

loops, declaring, 61–63