Index_S

S

s tag (local static variable), 291

SafeOutlook Library option (References dialog box), 493

Save As dialog box, 340

Save button

PivotChart toolbar, 171

PivotTable toolbar, 164

Save PDF File As dialog box, 544

Scripting Runtime option (References dialog box), 207

Search and Replace feature, 336

Search button

PivotChart toolbar, 172

PivotTable toolbar, 165

search criteria, strSearch variable, 54

search strings, 324

second normal form, normalization, 31–32

security features, Outlook, 492–494

Select All button (Export to Word dialog box), 94

Select Case statement, 84

Select Case...End Select statement, 221–223

Select Objects button (Toolbox), 80

Select Outlook folder, 460

select queries

expressions, 122–125

overview, 121–122

qryConcatenateAddressComponents, 125, 335

qryConcatenateNameComponents, 125

qrySplitAddressComponents, 125, 335

qrySplitNameComponents, 126–127

Selected property, 109

selecting

forms, 42

queries, 289

Send object, 550–551

sending faxes

attachments, 532–536

automatic reception, 548

connections, 542–543

cover pages, 542

dialog forms, 538

discussed, 531

Edit and Send Fax dialog box, 539

Fax Access Report (DDE), 543, 545

GetWinFaxDir function, 540

multiple attempts, 542

to multiple recipients, 550–554

OpenWinFax method, 539–540

progress bar, 547

snapshots, 544–546

TRANSMIT command, 541

variables, declaring, 540

SetFocus method, 289

shaded reports, 201

shape tag (shp), 294

ShippingMethodID variable, 65

Show As button (PivotTable toolbar), 165

Show Details button (PivotTable toolbar), 165

Show Legend button (PivotChart toolbar), 172

Show Table dialog box, 35

Show Top/Bottom Items button

PivotChart toolbar, 172

PivotTable toolbar, 165

shp tag (shape), 294

Simonyi, Charles (Hungarian notation development), 289–290

single forms, 40

Single Item tab (Import from Outlook dialog box), 483

single order reports, 195–196

Single Table tab (Import from Word dialog box), 413–414

single tag (sng), 293

sites. See Web sites

skipped records, 445–446, 463

snapshots

faxes, 544–546

snapshot tag (snp), 293

sng tag (single), 293

Sort Ascending button

PivotChart toolbar, 172

PivotTable toolbar, 165

Sort Descending button

PivotChart toolbar, 172

PivotTable toolbar, 165

sorting

action queries

append, 136–139

delete, 146–147

make-table, 145

update, 139–143

alphabetical, 208

ascending order, 122, 165, 172

columns, 235

crosstab queries, 132–135

data, in datasheets, 400

descending order, 122, 165, 172

frmCustomers, 121

nested queries, 152

New Query dialog box, 134

reports, 322

select queries

expressions, 122–125

overview, 121–122

qryConcatenateAddressComponents, 125

qryConcatenateNameComponents, 125

qrySplitAddressComponents, 125

qrySplitNameComponents, 126–127

SQL-specific queries

ALTER TABLE statement, 150

CREATE INDEX statement, 151

CREATE TABLE statement, 150

data-definition, 19

DROP statement, 151

subqueries, 151–153

union, 147–149

Sorting and Grouping dialog box, 327

source objects, tables as, 419

spaces, converting blanks to, 13

special controls, 112–116

special effects, raised text boxes, 47

splitting name and address data, 335

SQL-specific queries

ALTER TABLE statement, 150

CREATE INDEX statement, 151

CREATE TABLE statement, 150

data-definition, 19

DROP statement, 151

subqueries, 151–153

union, 147–149

standalone labels, 80

standard controls, forms, 79–80

standard forms

creating, 46–47

overview, 40

Standard toolbar, 365

StartTime property, 465

Startup command (Tools menu), 208

statements

ALTER TABLE, 150

Call, 218

CREATE INDEX, 151

CREATE TABLE, 150

Debug.Print, 215, 438

Do Until...Loop, 219

Do While...Loop, 218–219

DROP, 151

ElseIf, 220–221

For Each...Next, 220

For...Next, 219–220

GoTo, 220

If...Then...Else, 220–221

Select Case, 84

Select Case...End Select, 221–223

With...End With, 224, 373

StDev function, 128

str tag (string), 293

stretched images, 208

strFilter variable, 240

strings

nonalphanumeric characters, stripping, 218–219

search, 324

tags, 293

zero-length, 240, 438

strQuery variable, 403

strSearch variable, 54, 265

strTitlePlus variable, 319

Structure and Data option (Paste Table As dialog box), 352

Structure Only option (Paste Table As dialog box), 352

Styles option (Word object model), 367

sub tag (subform), 294

Subform in New Window command (View menu), 64

subforms, 41, 111

Subform/Subreport button (Toolbox), 80

Subject property, 392–393

subqueries, 151–153

subreports, 192–193, 323

subTable variable, 485–486

Subtotal button (PivotTable toolbar), 165

suffix information, 248, 290

Sum function, 127, 129

summary display, PivotTables, 163

summary reports, 197

SumOfFieldName object, 130

sums

reports, 185

RunningSum property, 186

Switch function, 83–84

Switch to another view button

PivotChart toolbar, 171

PivotTable toolbar, 164