Access Cookbook - Ken Getz [352]
IsConnected property (CurrentProject object), Discussion
IsFormOpen function, Creating pop-up forms
IsIconic function, Discussion
IsLoaded property (AccessObjects), Comments
IsMissing function, Using optional parameters, Discussion
IsNumeric function, Discussion
ItemLayout property (Printer object), Discussion, Discussion
ItemsAcross property (Printer object), Discussion
ItemSizeHeight property (Printer object), Discussion, Discussion
ItemSizeWidth property (Printer object), Discussion, Discussion
J
Java Server Pages (JSP), Alternatives to FrontPage
Jet data types, Discussion
Jet database engine, Uses the Tools at Hand, Discussion, Comments, Discussion, Solution, Discussion, Discussion, Discussion, Discussion, Discussion, Discussion, Discussion
Container objects, Discussion
creating new properties, support for, Discussion
Creator and Engine users, Discussion
db.Execute statement and, Discussion
metadata and, Discussion
multiple users and shared databases, Discussion
ownership information and, Comments
record-level locking, Discussion
saved queries and, Discussion
security model, Solution, Discussion
SQL Server and, Uses the Tools at Hand
Join Properties dialog, Solution
joins, Problem, Solution, Discussion, Discussion, Solution
equijoins, Solution, Discussion
inequality joins, Discussion
not based on equality comparisons, Problem
outer and inner joins, Solution
K
KeepTogether property (reports), Problem, Solution, Discussion
Key Assignment Macro option, Discussion
key strokes, Discussion, Problem
keyboard shortcuts, Problem
KeyDown event, Solution, Solution, Discussion
KeyPress event, Solution, Discussion, Solution
KeyPreview property (forms), Solution, Solution
keys, Discussion, Discussion
compound primary keys, Discussion
improving form performance, Discussion
Kurt function (Excel), Calling simple Excel functions
L
Label property (forms), Create a generic status meter
labels, Discussion, Discussion, Solution, Solution, Solution, Solution, Solution
background colors for, Discussion
changing default, Solution
internationalizing messages, Solution
limitations linking to text box, Discussion
using as navigation controls, Solution, Solution
language, Problem, Problem, Discussion, Discussion, Solution
classifying characters, Solution
determining version, Problem
importance of optimizing techniques, Discussion
internationalizing messages, Problem
LanguageSettings property (Application object), Discussion
LBound function, Solution, Solution
LCase function, Discussion
LDB file extension, Solution, Discussion
least-restrictive rule, Solution, Discussion
Left function, Discussion
left outer join, Solution
LeftMargin property (Printer object), Discussion
Len function, Solution
Let property procedure, Discussion, Solution, Discussion, Discussion
LimitToList property (combo boxes), Solution, Solution, Solution, Discussion
Line method (reports), Solution, Discussion, Solution
line numbers, Problem
LinkChildFields property (subforms), Discussion, Discussion
linked tables, Problem, Solution, Solution, Problem
finding records in, Problem
linking data tables, Solution
linking dynamically, Problem
options for, Solution
linking, Solution, Setting up communication with Excel, Problem, Discussion
Access and Excel, Setting up communication with Excel
Excel worksheet to database, Solution
servers in SQL Server, Discussion
SQL Server tables dynamically, Problem
LinkMasterFields property (subforms), Discussion, Discussion
list boxes, Problem, Solution, Discussion, Adding items to a list box, Solution, The MultiSelect property, Problem, Problem, Combo and list box controls, Solution, Problem
adding items, Adding items to a list box, Problem
bound to queries, Solution
client/server applications and, Solution
controls as parameters, Problem
creating permanently open, Problem
filling with lists of files, Problem
multiselect, Solution
performance bottlenecks, Combo and list box