1291
Index
Short Time format, 63
ss:, formatting seconds, 64
tttt:, Long Time format, 64
w:, formatting day of the week, 63
ww:, formatting week of the year, 63
y:, formatting day of the year, 63
yy:, formatting two digit year, 63
yyyy:, formatting four digit year, 63
Date/Time data type
automatic validation, 224–225
converting to Text, 58
description, 53
entering, 225
group headers, 362
leading zeros, enabling, 625
purpose, 48
storage size, 49
Day property, 362
dBase databases
browsing to, 631–632
data type conversions, 632
importing from multi-user environments, 631–632
linking to, 587
DBEngine object, 501
DblClick event, 455, 460
dbo prefix, 1212
dd:, formatting day of the month, 63
ddd:, formatting day of the week, 63
dddd:, formatting day of the week, 63
ddddd:, Short Date format, 63
dddddd:, Long Date format, 63
Deactivate event, 457, 461
dead code, removing, 866
debug window, 1075. See also Immediate window.
debugging
See also bugs
See also Compatibility Checker
See also error handling
See also testing
See also troubleshooting
color-coding syntax errors, 526
compiling on demand, 530
forcing variable declaration, 527–528
object hierarchy, displaying, 528
stopping for errors, 529
syntax checking, 525–527
variable values, displaying, 529
variables out of context, 528Date Order option, 624–625
Date Picker control, 298
date/time
adding to forms, 694
data type for, 51
in datasheets, 231
date delimiter character, specifying, 625
duration, 51
in forms, 231
limiting to a range of dates, 70
regional format, setting, 646
in reports, 362, 372
storing, 51
time delimiter character, specifying, 625
two-digit years versus four-digit, 212
validation rules, 70
date/time, formatting
: (colon), separating time elements, 63
/ (forward slash), separating time elements, 63
am/pm:, lowercase 12-hour format, 64
AMPM:, uppercase 12-hour format, 64
a/p:, lowercase 12-hour format, 64
A/P:, uppercase 12-hour format, 64
built-in formats, 62–63
c:, General Date format, 63
custom formats, 63–64
d:, formatting day of the month, 63
dd:, formatting day of the month, 63
ddd:, formatting day of the week, 63
dddd:, formatting day of the week, 63
ddddd:, Short Date format, 63
dddddd:, Long Date format, 63
General Date format, 63
h:, formatting hours, 64
hh:, formatting hours, 64
input masks, creating, 68
Long Date format, 63
Long Time format, 63
m:, formatting month of the year, 63
Medium Date format, 63
Medium Time format, 63
mm:, formatting month of the year, 63
mmm:, formatting month of the year, 63
mmmm:, formatting month of the year, 63
n:, formatting minutes, 64
nn:, formatting minutes, 64
q:, formatting quarter of the year, 63
s:, formatting seconds, 64
Short Date format, 6352_475348-bindex.indd 129152_475348-bindex.indd 1291 4/1/10 2:01 PM4/1/10 2:01 PM