Appendix
Jump to navigation
Jump to search
A. Constants
| Color | vbBLACK, vbRED, vbGREEN, vbBLUE, vbYELLOW, vbMAGENTA, vbCYAN, vbWHITE |
| Comparison | vbBINARYCOMPARE, vbTEXTCOMPARE |
| Date/Time | vbSUNDAY, vbMONDAY, vbTUESDAY, vbWEDNESDAY, vbTHURSDAY, vbFRIDAY, vbSATURDAY, vbFIRSTJAN1, vbFIRSTFOURDAYS, vbFIRSTFULLWEEK, vbUSESYSTEM, vbUSESYSTEMDAYOFWEEK |
| Date Format | vbGENERALDATE, vbLONGDATE, vbSHORTDATE, vbLONGTIME, vbSHORTTIME |
| MSGBOX | Display options (add to combine):
vbOKONLY, vbOKCANCEL |
| Return values:
vbOK, vbCANCEL | |
| String | vbCR (carriage return \r), vbCRLF (carriage return + linefeed \n), vbLF (linefeed \n), vbTAB (tab \t), vbVERTICALTAB (vertical tab \v) |
| VARTYPE | vbEMPTY, vbNULL, vbINTEGER, vbLONG, vbSINGLE, vbDOUBLE, vbCURRENCY, vbDATE, vbSTRING, vbOBJECT, vbERROR, vbBOOLEAN, vbVARIANT, vbDATAOBJECT, vbDECIMAL, vbBYTE, vbARRAY |
| Global | NSBVersion, AppBuildStamp, AppLegalCopyright, AppVersion, AppTitle, BuildCounter, NSB.currentForm, NSB.cacheStatus, NSB.jqxSettings |
B. Specifications
Statements
| Error Handling | Try...Catch |
| Flow of Control | Call, Do...Loop, Exit, For...Next, For Each...Next, If...Then...Else, Select Case, While...Wend, With...End With |
| Other | Debugger, Execute, HTML, JavaScript, Print, Sleep, SQL, Style, WaitCursor |
| Structure | Function, Sub |
| Variables | Const, Dim, Erase, Option, Explicit, Private, Public, ReDim, Set |
Functions
| Arithmatic | Abs, Asc, Atn, Cos, Exp, Fix, Int, Log, Rnd, Round, Sgn, Sin, Sqr, Tan |
| Conversion | Cbool, Cbyte, Ccur, Cdate, CDbl, Chr, Cint, CLng, CSng, CStr, Hex, Oct |
| Date/Time | Date, DateAdd, DateDiff, DateSerial, Date, DatePart, Day, Hour, Minute, Month, MonthName, Now, Second, Time, TimeSerial, Weekday, WeekdayName, Year |
| Formatting | Escape, FormatCurrency, FormatDateTime, FormatNumber, FormatPercent, Space, Unescape |
| Input/Output | InputBox, MsgBox |
| Other | Eval, SetTimeOut, SQLOpenDatabase, SysInfo |
| String Handling | Filter, InStr, InStrRev, Join, LCase, Left, Len, LTrim, Mid, Replace, Right, RTrim, Split, StrComp, StrReverse, String, Trim, UCase |
| Variable Handling | Array, IsArray, IsDate, IsEmpty, IsNull, IsNumeric, IsObject, LBound, TypeName, UBound, VarType |
Operators
| Arithmatic | Addition (+), Division (/), Exponentiation (^), Mod, Muliplication (*), Negation (-), Subtraction (-) |
| Boolean | And, Eqv, Imp, Not, Or, Is, =, <, >, Xor |
| String | Concatenation (&) |