dynamic, 104
dynaset-type, 100, 101–103
forward-only, 103
lock types, 118
overview, 116
searching, 110
snapshot-type, 103
specifying type, 99–100
table-type, 100–101
TestForwardReadOnlyprocedure, 116–117
Recordset2object, 98
references
in Automation code, 138
setting for Word, 139
setting to Excel object model, 59
setting to library databases, 503–506
setting to Outlook object model, 74
setting to Word Application object, 138, 139
viewing in Visual Studio Solution Explorer,
570–572
refreshing contact information, 361–374
Registry
key information for installing Access add-ins,
472
procedures versus functions, 481
subkeys for Form Wizard add-ins, 479
subkeys for menu add-ins, 478
subkeys for property builders add-ins, 480–481
Relationships diagrams, for Synchronizing Contacts
database, 352–353
RemoveAddInCommandBarButtonfunction, 443
Rename Files.vbs script, 618
renaming. See alsotitles
controls, 440–463, 467
Visual Basic projects, 463, 503–504
replenishing inventory, 426–432
Report Wizard, creating plain worksheet reports,
11–15
reports, Access
cmdReorderInventory_Clickevent
procedure, 431–432
creating form letters, 8–10
creating Products to Reorder report, 431–432creating shipping reports, 426–428, 429
creating worksheet-type, 11–25
filtering, 17–19
interactivity, 24
Layout view, 134–135
PivotChart-type, 22–25
PivotTable-type, 19–21
plain worksheet-type, 11–19
printing from PrintReport WSH script, 612–613
Products to Reorder report, 430, 431–432
selecting from templates, 233
sending Access Products to Reorder report as
email attachment, 432
sending shipping report as email attachment,
428, 430
Shipping Reports and Reordering form,
426–427
Upsizing Wizard report, 655–657, 659
Ribbon, Access 2007
adding new control, 517
adding new group, 517
adding new tab, 517
Add-ins tab, 436, 443, 463–464, 467, 469, 477
built-in control names, 521–531
built-in group names, 519–520
built-in tab names, 519
customizing in Access database, 519–549
customizing with Access add-ins, 549–560
customizing with Visual Studio 2005 shared
add-in, 559–589
Database Tools tab, 472, 479, 509, 554, 649
Enable Extras Tab, 552, 554
External Data tab, 50, 135–138, 184, 220–221,
310, 415, 541–542
Extras tab, 555
form Ribbons, 547–549
loading customization XML code, 547
locating add-ins, 477
new feature troubleshooting, 556
removing groups, 518–519
removing tabs, 518–519, 541
sources of information, 516
steps to customizing, 521Index R
25_047026 bindex.qxp 4/2/07 9:58 PM Page 691