Microsoft Access 2010 Bible

(Rick Simeone) #1

1304


Index


Group Footer section, 341–342, 344
group footers, 361–364
Group Header property, 362
Group Header section, 341–342, 343–344
Group Interval property, 363
Group On property, 362
grouping
controls, 278–279
objects in the Navigation Pane, 34
grouping report data
alphabetical headings, 712–714
alphabetically, 710–714
on date intervals, 714–716
hiding page headers, 719
hiding repeating information, 716–718
intervals, 327
into levels, 325–326
resetting page numbers, by group, 719–720
grouping report data headers
creating, 361–363
deleting, 364
expressions in, 369–370
groups, on ribbons, 1016, 1020–1022, 1025–1026

H
h:, formatting hours, 64
handled errors, 823
hardening. See bulletproofing.
hardware errors, troubleshooting, 920
Has Module property, 311
headers
forms, 311–312
page, 368–369, 719
reports, 361–364, 719
headers, group
Currency data type, 363
Date/Time data type, 362
expressions in, 369–370
Number data types, 363
Text data types, 362
Height property, 683
Hello World example, 1050–1052, 1065–1069
help
Auto Data Tips option, 543–544
Auto List Members, 396
Auto Quick Info, 396–397
for CD-ROM, 1270
Compatibility Checker, 1160

GetDriveTypeA function, 957–958
getLabel attribute, 1028
GetObject function, 797–799
GetOption method, 927
GetParent function, 960
GetPrivateProfileIntA function, 964
GetPrivateProfileStringA function, 963–964
GetProfileStringA function, 965
GetProperty function, 685–686
GetSystemDirectoryA function, 959–960
GetTempPathA function, 953–954
GetUserNameA function, 956
GetVersionExA function, 954–955
GetVolumeInformationA function, 958–959
GetWindowsDirectoryA function, 953
GetWindowTextA function, 960
global modules. See standard modules.
global scope, 426
go to a specific record, 220
GotFocus event, 457, 460
graphic rules, in reports, 368–369, 730
graphical objects. See also pictures.
data-entry forms, 22
tracking, 950
graphs, data type. See OLE Object data type.
graying out controls, 682
greater-than, equal (>=), greater-than-or-equal-to
operator, 177
greater-than sign (>)
convert to uppercase, 64, 67
Date comparison operator, 152
greater-than operator, 177, 188
in select queries, 188
Grid X property, 308
Grid Y property, 308
gridlines
aligning objects with, 276–277
forms, specifying points per inch, 308
hiding/showing, 220, 239, 293
modifying appearance of, 240
snapping to, 276–277
Gridlines command
Datasheet ribbon, 220
Form ribbon, 293
Group By fields, criteria for, 662
Group By option, 655, 661–662
Group command, 278–279
group data, defining for reports, 326–327
Group Footer property, 362

52_475348-bindex.indd 130452_475348-bindex.indd 1304 4/1/10 2:02 PM4/1/10 2:02 PM

Free download pdf