Alphabetical N - Z
NAME | Renames an existing file or directory. |
NOT | The logical 'NOT' operator (Boolean). |
NOW | Returns the current system date and time (Date). |
NPER | Returns the number of periods for an investment (Double). |
NPV | Returns the present value of a series of unequal cash flows at regular intervals (Double). |
OBJPTR | Returns a LongPtr on a 64 bit version and a Long on a 32 bit version. |
OCT | Returns the number converted to octal (Variant / String). |
OPEN | Opens a text file or CSV file. |
OR | The logical 'OR' operator (Boolean). |
PARTITION | Returns a string indicating which particular range it falls into (String). |
PMT | Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double). |
PPMT | Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double). |
Writes data to a file opened with Sequential access (display-formatted). | |
PUT | Writes data from a record into a text file. |
PV | Returns the present value of a series of equal cash flows at regular intervals (Double). |
QBCOLOR | Returns the RGB colour corresponding to the specified colour number (Long). |
RAISEEVENT | Fires an event declared at module level within a class, form or document. |
RANDOMIZE | Initialises the random number generator. |
RATE | Returns the interest rate for a series of equal cash flows at regular intervals (Double). |
REDIM | Initialises and resizes a dynamic array. |
REM | Specifies a single line of comments. |
REPLACE | Returns the text string with a number of characters replaced (String). |
RESET | Closes all files open with the Open statement. |
RGB | Returns the number representing an RGB colour value (Long). |
RIGHT | Returns a substring from the right of a string (Variant / String). |
RMDIR | Removes an existing directory. |
RND | Returns a random number between 0 and 1 (Single). |
ROUND | Returns a number rounded to a given number of decimal places (Double). |
RSET | Right aligns a string within a string variable. |
RTRIM | Returns the text string without trailing spaces (Variant / String). |
SAVEPICTURE | Saves a graphic image from an objects Picture or Image property to a file. |
SAVESETTING | Writes to the registry and saves a section or key in the registry. |
SECOND | Returns the seconds from a given time (Integer). |
SEEK - Function | Returns the current read/write position within a file opened using the Open statement (Long). |
SEEK - Statement | Repositions where the next operation in a file will occur. |
SENDKEYS | Sends keystrokes to an application. |
SET | Assigns an object reference to an object variable. |
SETATTR | Defines the attributes of a file or directory. |
SGN | Returns the sign of a number (Integer). |
SHELL | Returns the program's task id from running an executable programs (Double). |
SIN | Returns the sine of an angle in radians (Double). |
SLN | Returns the straight-line depreciation of an asset over a single period of time (Double). |
SPACE | Returns the specified number of spaces (Variant / String). |
SPC | Inserts a specified number (n) of spaces when writing or displaying text. |
SPLIT | Returns an array containing a specified number of substrings (Variant). |
SQR | Returns the square root of a number (Double). |
STOP | Suspends execution. |
STR | Returns the text string of a number (Variant / String). |
STRCOMP | Returns the result of a string comparison (Integer). |
STRCONV | Returns the text string converted to a specific case or type (Variant / String). |
STRING | Returns a repeating character of a given length (Variant / String). |
STRPTR | Returns a LongPtr on a 64 bit version and a Long on a 32 bit version. |
STRREVERSE | Returns the text string with the characters reversed (Variant / String). |
SWITCH | Returns a value based on expressions (Variant). |
SYD | Returns the sum-of-years' digits depreciation of an asset (Double). |
TAB | Used with the Print # statement or the Print method to position output. |
TAN | Returns the tangent of an angle (Double). |
TIME - Function | Returns the current system time (Date). |
TIME - Statement | Defines the current system time. |
TIMER | Returns the number of seconds elapsed since midnight (Single). |
TIMESERIAL | Returns the time for a specific hour, minute and second (Date). |
TIMEVALUE | Returns the time given a string representation of a time (Date). |
TRIM | Returns the text string without leading and trailing spaces (Variant / String). |
TYPENAME | Returns the data type of the variable as a string (String). |
TYPEOF | Returns the object data type. |
UBOUND | Returns the upper limit in a given dimension of an array (Long). |
UCASE | Returns the text string with all the characters converted to uppercase (Variant / String). |
UNLOAD | Removes an object from memory. |
UNLOCK | Controls access to a file. |
VAL | Returns the first number contained in a string (Double). |
VARPTR | Returns a LongPtr on a 64 bit version and a Long on a 32 bit version. |
VARTYPE | Returns the number indicating the data type of a variable (Integer). |
WEEKDAY | Returns the number representing the day of the week for a given date (Integer). |
WEEKDAYNAME | Returns the day of the week as a string (String). |
WIDTH | Assigns an output line width (characters) for the open file. |
WRITE | Writes data to a file opened with Sequential access. |
XOR | The logical exclusion operator. |
YEAR | Returns the year from a date (Integer). |
NAME Renames an existing file or directory. |
NOT The logical 'NOT' operator (Boolean). |
NOW Returns the current system date and time (Date). |
NPER Returns the number of periods for an investment (Double). |
NPV Returns the present value of a series of unequal cash flows at regular intervals (Double). |
OBJPTR Returns a LongPtr on a 64 bit version and a Long on a 32 bit version. |
OCT Returns the number converted to octal (Variant / String). |
OPEN Opens a text file or CSV file. |
OR The logical 'OR' operator (Boolean). |
PARTITION Returns a string indicating which particular range it falls into (String). |
PMT Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double). |
PPMT Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double). |
PRINT Writes data to a file opened with Sequential access (display-formatted). |
PUT Writes data from a record into a text file. |
PV Returns the present value of a series of equal cash flows at regular intervals (Double). |
QBCOLOR Returns the RGB colour corresponding to the specified colour number (Long). |
RAISEEVENT Fires an event declared at module level within a class, form or document. |
RANDOMIZE Initialises the random number generator. |
RATE Returns the interest rate for a series of equal cash flows at regular intervals (Double). |
REDIM Initialises and resizes a dynamic array. |
REM Specifies a single line of comments. |
REPLACE Returns the text string with a number of characters replaced (String). |
RESET Closes all files open with the Open statement. |
RGB Returns the number representing an RGB colour value (Long). |
RIGHT Returns a substring from the right of a string (Variant / String). |
RMDIR Removes an existing directory. |
RND Returns a random number between 0 and 1 (Single). |
ROUND Returns a number rounded to a given number of decimal places (Double). |
RSET Right aligns a string within a string variable. |
RTRIM Returns the text string without trailing spaces (Variant / String). |
SAVEPICTURE Saves a graphic image from an objects Picture or Image property to a file. |
SAVESETTING Writes to the registry and saves a section or key in the registry. |
SECOND Returns the seconds from a given time (Integer). |
SEEK - Function Returns the current read/write position within a file opened using the Open statement (Long). |
SEEK - Statement Repositions where the next operation in a file will occur. |
SENDKEYS Sends keystrokes to an application. |
SET Assigns an object reference to an object variable. |
SETATTR Defines the attributes of a file or directory. |
SGN Returns the sign of a number (Integer). |
SHELL Returns the program's task id from running an executable programs (Double). |
SIN Returns the sine of an angle in radians (Double). |
SLN Returns the straight-line depreciation of an asset over a single period of time (Double). |
SPACE Returns the specified number of spaces (Variant / String). |
SPC Inserts a specified number (n) of spaces when writing or displaying text. |
SPLIT Returns an array containing a specified number of substrings (Variant). |
SQR Returns the square root of a number (Double). |
STOP Suspends execution. |
STR Returns the text string of a number (Variant / String). |
STRCOMP Returns the result of a string comparison (Integer). |
STRCONV Returns the text string converted to a specific case or type (Variant / String). |
STRING Returns a repeating character of a given length (Variant / String). |
STRPTR Returns a LongPtr on a 64 bit version and a Long on a 32 bit version. |
STRREVERSE Returns the text string with the characters reversed (Variant / String). |
SWITCH Returns a value based on expressions (Variant). |
SYD Returns the sum-of-years' digits depreciation of an asset (Double). |
TAB Used with the Print # statement or the Print method to position output. |
TAN Returns the tangent of an angle (Double). |
TIME - Function Returns the current system time (Date). |
TIME - Statement Defines the current system time. |
TIMER Returns the number of seconds elapsed since midnight (Single). |
TIMESERIAL Returns the time for a specific hour, minute and second (Date). |
TIMEVALUE Returns the time given a string representation of a time (Date). |
TRIM Returns the text string without leading and trailing spaces (Variant / String). |
TYPENAME Returns the data type of the variable as a string (String). |
TYPEOF Returns the object data type. |
UBOUND Returns the upper limit in a given dimension of an array (Long). |
UCASE Returns the text string with all the characters converted to uppercase (Variant / String). |
UNLOAD Removes an object from memory. |
UNLOCK Controls access to a file. |
VAL Returns the first number contained in a string (Double). |
VARPTR Returns a LongPtr on a 64 bit version and a Long on a 32 bit version. |
VARTYPE Returns the number indicating the data type of a variable (Integer). |
WEEKDAY Returns the number representing the day of the week for a given date (Integer). |
WEEKDAYNAME Returns the day of the week as a string (String). |
WIDTH Assigns an output line width (characters) for the open file. |
WRITE Writes data to a file opened with Sequential access. |
XOR The logical exclusion operator. |
YEAR Returns the year from a date (Integer). |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top