| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] Save command (File menu) Save Data with Table Layout option (pivot tables) 2nd Save Password option (pivot tables) Save Password property (data ranges) Save Query Definition property (data ranges) saving queries scope names 2nd 3rd searching records FindARecord() function 2nd SeekARecord() function 2nd searching for data. [See finding data] SECFAQ.doc secured Jet databases 2nd 3rd 4th Access database passwords 2nd 3rd 4th Admin restrictions opening 2nd 3rd 4th password requests 2nd 3rd securing 2nd 3rd 4th 5th 6th user accounts, creating 2nd user-level security 2nd 3rd 4th workgroup information files 2nd 3rd 4th security SPPI (Security Support Provider Interface) Security command (Tools menu) Security Support Provider Interface (SSPI) Seek() function SeekARecord() function 2nd Select Database dialog box 2nd Select queries . [See also queries]2nd [See also parameterized queries] selecting dynamically defined ranges 2nd SellStocks() function 2nd 3rd 4th semicolons servers SQL Server SQL Server Desktop Engine Set statement 2nd 3rd SetupPeriods variable shared mode 2nd sheet-level names 2nd 3rd sheets. [See worksheets] Show All command (Filter menu) Show Direct command (Relationships menu) Show Table command (Relationships menu) Show Table dialog box 2nd snapshot-type recordsets 2nd Sort command (Data menu) 2nd 3rd Sort method sort order lists Sort Order window (Query Wizard) sorting lists 2nd 3rd 4th Source property (OpenRecordset() function) 2nd SourceName variable spaces in field names 2nd 3rd SPPI (Security Support Provider Interface) SQL (Standard Query Language) queries parameters 2nd SQL (Structured Query Language) 2nd SQL (Structured Query Language). [See also queries] SQL Server SQL Server Desktop Engine SQL Server Desktop Engine starting VBE (Visual Basic Editor) StartTime variable statements AddNew 2nd CreateDatabase Dim 2nd 3rd 4th 5th End Sub End With loops Do While 2nd 3rd 4th 5th 6th For Each 2nd For-Next 2nd 3rd 4th New 2nd On Error GoTo Option Explicit 2nd ReDim 2nd 3rd Set 2nd 3rd Sub 2nd Update With advantages of 2nd 3rd nesting 2nd With-End With blocks 2nd static range names 2nd Stop Recording command (Macro menu) stored procedures 2nd . [See also queries] string variables Structured Query Language (SQL) 2nd Structured Query Language (SQL). [See also queries] strUpdateSQL variable Sub statement 2nd subroutines creating 2nd suppressing cache |