< Day Day Up > |
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] s format Save As dialog box Save command (File menu) saving modules 2nd schema recordsets retrieving 2nd 3rd standard schema recordsets 2nd 3rd schemas Scientific format scope 2nd local scope module scope module-level variables 2nd procedure-level variables 2nd public scope public variables 2nd 3rd static variables 2nd 3rd 4th searching recordsets Find method 2nd 3rd 4th Seek method 2nd 3rd 4th 5th 6th Second function security ADOX data dictionary case study 2nd 3rd 4th 5th groups 2nd object ownership 2nd 3rd object permissions 2nd 3rd users 2nd Seek method 2nd 3rd 4th 5th 6th SeekClient() procedure Select Case statement 2nd SELECT INTO statements 2nd SELECT statements ALL predicate 2nd DISTINCT predicate 2nd FROM clause 2nd GROUP BY clause 2nd 3rd HAVING clause 2nd ORDER BY clause 2nd syntax 2nd TOP predicate 2nd WHERE clause 2nd SelText property (text boxes) semicolon () SetObjectOwner method SetPermissions() procedure 2nd Shared locking setting Short Date format Short Time format shortcuts (keyboard) ShowDependencies() procedure 2nd ShowInFormList() procedure Single data type 2nd single-stepping 2nd sizing forms 2nd 3rd 4th sorting reports 2nd Space function Split function 2nd splitting strings 2nd spreadsheets (Excel) 2nd SQL (Standard Query Language) 2nd 3rd 4th 5th DDL (Data Definition Language) DELETE statements 2nd DML (Data Manipulation Language) INSERT INTO statements 2nd 3rd SELECT INTO statements 2nd SELECT statements ALL predicate 2nd DISTINCT predicate 2nd FROM clause 2nd GROUP BY clause 2nd 3rd HAVING clause 2nd ORDER BY clause 2nd syntax 2nd TOP predicate 2nd WHERE clause 2nd standards structure and syntax 2nd 3rd TRANSFORM statements 2nd UPDATE statements 2nd ss format Standard format Standard Query Language [See SQL] Standard Query Language (SQL) 2nd standard schema recordsets 2nd 3rd Standard toolbar (VBE) 2nd StartDate_Exit() procedure statements 2nd branching and looping 2nd compared to functions Const 2nd defined DELETE 2nd Dim 2nd 3rd Do loops conditions 2nd simple example 2nd terminating 2nd Else 2nd ElseIf 2nd End Function End Sub Exit Do Exit For Exit Function For…Next 2nd 3rd loop counter variables 2nd looping in reverse 2nd nesting 2nd 3rd Function GoTo 2nd If…Then…Else conditions 2nd 3rd Else statement 2nd ElseIf statement 2nd simple If statement 2nd Input # 2nd INSERT INTO 2nd 3rd Line Input # 2nd On Error Goto 2nd 3rd On Error Goto HandleErr On Error Resume Next 2nd Option Base 2nd Option Explicit 2nd 3rd 4th 5th Preserve Print # 2nd Private Public ReDim 2nd Resume Resume Next SELECT ALL predicate 2nd DISTINCT predicate 2nd FROM clause 2nd GROUP BY clause 2nd 3rd HAVING clause 2nd ORDER BY clause 2nd syntax 2nd TOP predicate 2nd WHERE clause 2nd Select Case 2nd SELECT INTO 2nd structure of 2nd Sub TRANSFORM 2nd UPDATE 2nd Write # 2nd static cursors static variables 2nd 3rd 4th Step Into command (Debug menu) Step Out command (Debug menu) Step Over command (Debug menu) StrComp function 2nd string arguments passing to Windows API functions 2nd String data type converting values to string user-defined formats strings changing case of comparing 2nd connection strings 2nd 3rd counting characters in creating dates from 2nd formatting functions Asc 2nd Chr example 2nd LCase Left Len LTrim Mid Replace 2nd Right RTrim Space Split 2nd StrComp 2nd Trim UCase interval string settings replacing characters in returning characters from splitting 2nd string user-defined formats trimming structured files stubs sub procedures creating defined PrintBillingChart 2nd 3rd running 2nd Sub statement subforms 2nd subtracting dates 2nd sum-of-years' depreciation, calculating Switchboard form Syd function |
< Day Day Up > |