Access.2007.VBA.Bibl..

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

RunSQLmethod, 109, 482

S

Sample Code.accdb sample database, 90

sample databases

Access to Outlook.accdb, 72

Access to Word.accdb, 27, 49

AdventureWorks SQL.accdb, 627

Backup.accdb, 279, 471

Basic Northwind CS.adp sample database, 627

Basic Northwind v 1 (linked SQL Server

tables).accdb, 627

Basic Northwind.accdb, 627, 631, 648, 656

DAO and ADO Sample Code.accdb, 90

Excel Export.accdb, 187

Excel.accdb, 49

External Data.accdb, 312

Files and Folders.accdb, 264, 302

Folders.accdb, 264

Modified Northwind.accdb, 11

Northwind Plus.accdb, 397, 398, 403

Northwind 2007.accdb, 90

Northwind.accdb, 611, 612

Outlook Export.accdb, 230, 231

Outlook.accdb, 72

RichText.accdb, 5

Sample Code.accdb, 90

Synchronizing Contacts.accdb, 72, 352–353,

357–358

Tasks1.accdb, 229

Test Ribbon.accdb, 521, 542, 547

Word Export.accdb, 138, 264

Word.accdb, 27

Save to PDF utility, 415, 428, 429, 430

SaveAttachmentsfunction, 302–304

SaveNofunction, 501

SaveToFilemethod, 291

saving

attachments to files, 302–304

import specifications, 310

Schmid, Patrick, on Access 2007 Ribbon

customizability, 520

Scripting Runtime Library, 263, 271

scripts, tools for working with. See alsoVisual Basic

Script (VBS); Windows Script Host

(WSH)

Microsoft Script Editor, 592–597

overview, 591

VBScript Help File, 597–599

security

getting around Windows Firewall to connect to

SQL Server, 640–647

warnings when connecting to SQL Server,

647–648

warnings when installing add-ins in Access 2007

running on Windows Vista, 471–472,

549, 550, 551–552

Seekmethod, 100

Select Casestatement, 316, 319, 330, 343

Select Contacts for Email sample form, 282–283

Select Data Source dialog, 664, 669

Select Options dialog, 556

Select Orders for Shipping form, 403, 404

SendObjectcommand, 220

SetPropertyfunction, 499–500

Shared Add-in template, 563

Shared Add-in Wizard, 564–565, 568–570

SharedCode module, 439, 440–442

shipping labels

adding extra information, 404

creating in Word, 397–415

examples, 414

R Index

25_047026 bindex.qxp 4/2/07 9:58 PM Page 692