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 SaveAttachments function, 302-304 SaveNo function, 501 SaveToFile method, 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 also Visual 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 Seek method, 100

Select Case statement, 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

SendObject command, 220

SetProperty function, 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

shipping reports creating in Access, 426-429 editing product amounts, 428 illustrated, 429

saving as PDF files, 415, 428, 429 sending as email attachments, 428, 430 Shipping Reports and Reordering form defined, 426

editing product amounts, 428 final shipping report, 428, 429 illustrated, 42

saving as PDF, 415, 428, 429 signature, digital creating for Access VBA code, 398-402 why not to create for Access add-ins, 511 size XML element, 522 Snapshot Viewer, 135 snapshot-type recordsets, 100, 103, 130 SplitFileName function, 395 spreadsheets, importing legacy files, 324-328. See also worksheets, Excel SQL commands (cmdSQL), 113 SQL Server Browser, 636, 642, 645, 646 SQL Server Configuration Manager, 633-634, 637 SQL Server Express (SSE), 629 SQL Server Management Studio, 629 SQL Server Migration Assistant for Access (SSMA),

671-672 SQL Server 2005

accessing through Windows XP firewall, 640-642

as back-end database, 4, 483, 557-558,

627-628, 648, 657 books online, 632-633 checking for installation, 628-629 configuring for data access, 631-648 configuring for remote connections, 638 connecting Office 2003 versus 2007, 627 connecting Windows XP versus Windows Vista, 627

converting Access tables to, 649-657 Express version, 629

getting, 628-629 linked tables, 656-657 linking to table data, 662-671 versus Microsoft Access, 627 Migration Assistant for Access, 671-672 Network Configuration folder, 637 preparing Access databases for upsizing,

629-631 restarting, 637, 639 Service Pack 2, 629 Services folder, 636

Surface Area Configuration dialog, 638-639 version comparison, 629 SQL statements (strSQL), 612-613 SQLEXPRESS (SQL Server) properties sheet, 635 SSE (SQL Server Express), 629 SSMA (SQL Server Migration Assistant for Access), 671-672

startFromScratch attribute, 517, 522 static cursors, 117, 122, 125-127, 130 Stop statement, 503 Stream object, 129, 282, 291 StripCharm function, 441 strSQL (SQL statements), 612-613 styles, PivotChart, 421-426 supertip XML element, 522 Surface chart type, 425

Synchronizing Contacts.accdb sample database defined, 72, 352 main menu, 357-358 Relationships diagram, 352-353 synchronizing data, 352-353, 359

0 0

Post a comment