Access Cookbook - Ken Getz [355]
allowing input of, Problem
as terminator, Discussion
checking text fields for, Discussion
Chr$(0), Discussion
median values and, Discussion
plus sign and, Discussion
RowSource property and, Discussion, Avoiding errors
number sign (#), Discussion, Discussion
numeric fields, Problem, Discussion
O
Object Browser (VBA), Comments, Comments, Discussion
Object Linking and Embedding (OLE), Graphic and memo controls, Discussion, Discussion, Discussion, Discussion, Discussion, Discussion, Discussion, Problem
fields, Discussion, Discussion, Discussion
form performance and, Discussion
limitations of, Discussion
optimizing performance, Graphic and memo controls
storing bitmaps as, Discussion
usage recommendations, Discussion
WAV files as, Problem
object variables, Documenting each container, Documenting each container, Solution, Discussion, Discussion
DAO, Documenting each container
listing users with blank passwords, Discussion
recommendations, Solution
tracking users/groups, Discussion
usage recommendations, Documenting each container
objects, How Do I Import an Object?, Discussion, Problem, Problem, Problem, Problem, Problem, Problem
backup of selected, Problem
building inventory of, Problem
determining existence of, Problem
handling properties for, Problem
importing, How Do I Import an Object?
security for selected, Problem
templates and, Discussion
verifying consistent settings, Problem
ODBC, SQL Server
ODBCConnectStr property (queries), Solution
ODC, Solution
ODE (Office Developer's Edition), Solution
od\: element, Root elements and namespaces, Discussion
Office 2000, Solution
Office 2003 Web Services Toolkit, Solution, Locating the toolkits, Solution
serialized objects, Solution
Office Data Connection (ODC), Solution, Solution, Solution
changing to different locations, Solution
creating files, Solution
ODC file extension, Solution
Office Data Source Control (MSODSC), Discussion, Discussion
Office Developer's Edition (ODE), Solution
Office Object Library, Solution, Discussion
Office Web Components, Discussion, Solution
Office XP, Solution, Solution
Office XP Web Services Toolkit 2.0, Locating the toolkits
OLE, Graphic and memo controls
OLEDB connection string, hand-coding, Solution
OnAction property (forms), Solution
OnActivate property (forms), Solution
OnChange property (text boxes), Solution
OnClick property (buttons), Solution, Solution, Solution, Solution, Solution, Solution, Solution, Solution
adding lock identification, Solution
automation, Solution
cleaning out test data, Solution
communicating without email, Solution, Solution
creating geographical map interfaces, Solution
dynamically linking SQL Server tables, Solution
Excel functions, Solution
OnClose property (forms), Solution
OnCurrent property (forms), Solution, Solution, Solution, Discussion
combo boxes with controls as parameters, Discussion determining if new record, Solution option groups, Solution OnEnter property (combo boxes), Solution OnExit property (text boxes), Solution OnFormat property (reports), Solution, Solution, Solution, Solution controlling page breaks, Solution creating page-range indicator, Solution different headers/footers, Solution setting widths with, Solution OnGotFocus property (controls), Solution, Discussion, Solution online help, accessing programmatically, Programmatically accessing online help OnLoad property (forms), Solution, Discussion, Continuously animated buttons, Solution accepting new entries, Solution, Discussion animated buttons, Continuously animated buttons communicating without email, Solution OnLostFocus property (controls), Solution OnNoData property (reports), Solution, Discussion OnPrint property (reports), Solution, Solution, Solution OnTimer property (buttons), Continuously animated buttons OnTimer property (forms), Solution, Discussion Open Database Connectivity (ODBC),