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
SplitFileNamefunction, 395
spreadsheets, importing legacy files, 324–328. See
alsoworksheets, 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, 629getting, 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
startFromScratchattribute, 517, 522
static cursors, 117, 122, 125–127, 130
Stopstatement, 503
Streamobject, 129, 282, 291
StripCharmfunction, 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, 359T
tab XML element
adding to Ribbon, 517
built-in Access Ribbon names, 519
defined, 522
removing from Ribbon, 518–519
Table object, Word, 139
TableDefobject, 130, 482
TableDefs collection, 106–109Index T
25_047026 bindex.qxp 4/2/07 9:58 PM Page 693