R

read-only lock type, 118 recordsets in ADO object model, 116-129, 130 ADO versus DAO, 92, 116, 130 creating by using Command object, 113-116 creating connections to external databases, 111-112 cursor types, 117

cursor/lock type combinations, 121-122 in DAO object model, 99-103, 130

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

TestForwardReadOnly procedure, 116-117 Recordset2 object, 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 RemoveAddInCommandBarButton function, 443 Rename Files.vbs script, 618 renaming. See also titles 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_Click event procedure, 431-432 creating form letters, 8-10 creating Products to Reorder report, 431-432

creating 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

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, 521

Ribbon, Access 2007 (continued)

Test Ribbon.accdb sample database, 521

USysRibbons table, 523-525

writing callback procedures for command buttons, 542-547 XML code for Extras (Ribbon) add-in, 550-551 ribbon XML element, defined, 522 Ribbon XML file, 523, 575-582 RibbonName field name, 523 RibbonXML field name, 523 RichText.accdb sample database, 5 RTF format, 5, 6, 8, 10, 136, 137 RunSQL method, 109, 482

0 0

Post a comment