1329
Index
DAO, 501
digital certificates, 935–936
digital signatures, 935
encoding, 930–931
encryption, 930–931
macros, 934–938
.mdb files, 752
new features, 1265
passwords, removing, 931–933
privacy settings, 937–938
property values, getting, 927
property values, setting, 926–927
runtime mode, forcing, 929–930
sandbox mode, 934–936
settings, 937–938
SharePoint, 1138
start-up bypass, disabling, 924–927
start-up option properties, 924
start-up options, setting, 923–924
Trust Center, 937–938
validating user input, 928–929
VBA code, 933–934
security, applications
bulletproofing forms, 928
digital certificates, 935–936
digital signatures, 935
encoding, 930–931
encryption, 930–931
macros, 934–938
passwords, removing, 931–933
privacy settings, 937–938
property values, getting, 927
property values, setting, 926–927
runtime mode, forcing, 929–930
sandbox mode, 934–936
settings, 937–938
start-up bypass, disabling, 924–927
start-up option properties, 924
start-up options, setting, 923–924
Trust Center, 937–938
validating user input, 928–929
VBA code, 933–934
segmenting data into tables. See normalization.
Select Case...End Select statements, 403–404
Select command, 220
SELECT keyword, 475, 476–477
select queries, 133routines, absolute speed, 863–866
rows (database). See records (rows).
rows (report), spacing, 745
RowSource property, 682, 691–693
rules (graphic), in reports, 368–369
RunDataMacro action, 561
Running Sum property, 344
runtime environment, starting applications in, 1093
runtime errors, 821–824
runtime mode, forcing, 929–930
/runtime switch, 929S
s:, formatting seconds, 64
sandbox mode, 934–936
Save Splitter Bar Position property, 309
saving
datasheet changes, 242
forms, 256, 263
queries, 138, 153
records in forms, 231, 300
reports, 340
tables, 85
schema errors, 1178–1179
Scientific format, 61
scope, VBA procedures, 432–434
scope, VBA variables
definition, 432
global, 426
local, 426
private, 427, 432–434
Private keyword, 427
public, 426, 432–434
Public keyword, 426
screen fonts versus printer fonts, 308
scroll bars, displaying on forms, 306
Scroll Bars property, 306, 704
scrolling forms, 291
searching. See finding; queries; SQL (Structured Query
Language).
sections, of reports. See also banded reports.
hiding/showing, 364
moving controls between, 365–366
resizing, 351–352, 365
security
.accdb files, 752
bulletproofing forms, 92852_475348-bindex.indd 132952_475348-bindex.indd 1329 4/1/10 2:02 PM4/1/10 2:02 PM