Access Functions


FunctionDescription
ABSReturns a value of the same type that is passed to it specifying the absolute value of a number.
APPACTIVATE 
ARRAYReturns a Variant containing an array. (not in object browser)
ASCReturns an Integer representing the character code corresponding to the first letter in a string.
ATNReturns a Double specifying the arctangent of a number.
BEEP 
CALLBYNAMEExecutes a method of an object, or sets or returns a property of an object.
CBOOLReturns the expression converted to a boolean data type.
CBYTEReturns the expression converted to a byte data type.
CCUR 
CDATEReturns the expression converted to a date data type.
CDBLReturns the expression converted to a double data type.
CDECReturns a Variant (Decimal) containing the expression converted to a decimal.
CHDIR 
CHDRIVE 
CHR 
CHOOSESelects and returns a value from a list of arguments.
CINTReturns the expression converted to an integer data type.
CLNGReturns the expression converted to a long data type.
CLNGLNG 
CLNGPTR 
COMMAND 
COSReturns a Double specifying the cosine of an angle.
CREATEOBJECT 
CSNG 
CSTR 
CURDIRReturns a Variant (String) representing the current path.
CVAR 
CVDATE 
CVERR 
DATE 
DATEADDReturns a Variant (Date) containing a date to which a specified time interval has been added.
DATEDIFFReturns a Variant (Long) specifying the number of time intervals between two specified dates.
DATEPARTReturns a Variant (Integer) containing the specified part of a given date.
DATESERIALReturns a Variant (Date) for a specified year, month, and day.
DATEVALUEReturns a Variant (Date).
DAVG 
DAYReturns a Variant (Integer) specifying a whole number between 1 and 31, inclusive, representing the day of the month.
DCOUNT(backwards compatibility)
DDBReturns a Double specifying the depreciation of an asset for a specific time period by using the double-declining balance method or some other method you specify.
DDEINITIATE(backwards compatibility)
DDEREQUEST(backwards compatibility)
DELETESETTING 
DFIRST(backwards compatibility)
DIRReturns a String representing the name of a file, directory, or folder that matches a specified pattern or file attribute, or the volume label of a drive.
DLAST(backwards compatibility)
DLOOKUP(backwards compatibility)
DMAX(backwards compatibility)
DMIN(backwards compatibility)
DOEVENTSYields execution so that the operating system can process other events.
DSTDEV(backwards compatibility)
DSTDEVP(backwards compatibility)
DSUM(backwards compatibility)
DVAR(backwards compatibility)
DVARP(backwards compatibility)
ENVIRONReturns the String associated with an operating system environment variable. Not available on the Macintosh.
EOFReturns an Integer containing the Boolean value True when the end of a file opened for Random or sequential Input has been reached.
ERR 
ERRORReturns the error message that corresponds to a given error number.
EUROCONVERT(backwards compatibility)
EVAL(backwards compatibility)
EXP 
FILEATTRReturns a Long representing the file mode for files opened by using the Open statement.
FILECOPY 
FILEDATETIMEReturns a Variant (Date) that indicates the date and time when a file was created or last modified.
FILELENReturns a Long specifying the length of a file in bytes.
FILTERReturns a zero-based array containing a subset of a string array based on a specified filter criteria.
FIX 
FORMAT 
FORMATCURRENCYReturns an expression formatted as a currency value by using the currency symbol defined in the system control panel.
FORMATDATETIMEReturns an expression formatted as a date or time.
FORMATNUMBERReturns an expression formatted as a number.
FORMATPERCENTReturns an expression formatted as a percentage (multipled by 100) with a trailing % character.
FREEFILEReturns an Integer representing the next file number available for use by the Open statement.
FVReturns a Double specifying the future value of an annuity based on periodic fixed payments and a fixed interest rate.
GETALLSETTINGSReturns a list of key settings and their respective values (originally created with SaveSetting) from an application's entry in the Windows registry or (on the Macintosh) information in the application's initialization file.
GETATTRReturns an Integer representing the attributes of a file, directory, or folder.
GETOBJECTReturns a reference to an object provided by an ActiveX component.
GETSETTINGReturns a key setting value from an application's entry in the Windows registry or (on the Macintosh) information in the application's initialization file.
GUIDFROMSTRING(backwards compatibility)
HEX 
HOURReturns a Variant (Integer) specifying a whole number between 0 and 23, inclusive, representing the hour of the day.
IIFReturns one of two parts, depending on the evaluation of an expression.
IMESTATUSReturns an Integer specifying the current Input Method Editor (IME) mode of Microsoft Windows; available in East Asian versions only.
INPUTBOXDisplays a prompt in a dialog box, waits for the user to input text or click a button, and returns a String containing the contents of the text box.
INSTRReturns a Variant (Long) specifying the position of the first occurrence of one string within another.
INSTRREVReturns the position of an occurrence of one string within another, from the end of the string.
INT 
IPMTReturns a Double specifying the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.
IRRReturns a Double specifying the internal rate of return for a series of periodic cash flows (payments and receipts).
ISARRAYReturns a Boolean value indicating whether a variable is an array.
ISDATEReturns True if the expression is a date or is recognizable as a valid date or time; otherwise, it returns False.
ISEMPTYReturns a Boolean value indicating whether a variable has been initialized.
ISERRORReturns a Boolean value indicating whether an expression is an error value.
ISMISSINGReturns a Boolean value indicating whether an optional Variant argument has been passed to a procedure.
ISNULLReturns a Boolean value that indicates whether an expression contains no valid data (Null).
ISNUMERICReturns a Boolean value indicating whether an expression can be evaluated as a number.
ISOBJECTReturns a Boolean value indicating whether an identifier represents an object variable.
JOINReturns a string created by joining a number of substrings contained in an array.
KILL 
LCASEReturns a String that has been converted to lowercase.
LEFTReturns a Variant (String) containing a specified number of characters from the left side of a string.
LENReturns a Long containing the number of characters in a string or the number of bytes required to store a variable.
LOCReturns a Long specifying the current read/write position within an open file.
LOFReturns a Long representing the size, in bytes, of a file opened by using the Open statement.
LOGReturns a Double specifying the natural logarithm of a number.
LTRIMReturns a Variant (String) containing a copy of a specified string without leading spaces (LTrim), trailing spaces (RTrim), or both leading and trailing spaces (Trim).
MACSCRIPT(backwards compatibility)
MIDReturns a Variant (String) containing a specified number of characters from a string.
MINUTEReturns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the minute of the hour.
MIRRReturns a Double specifying the modified internal rate of return for a series of periodic cash flows (payments and receipts).
MONTHReturns a Variant (Integer) specifying a whole number between 1 and 12, inclusive, representing the month of the year.
MONTHNAMEReturns a string indicating the specified month.
MSGBOXDisplays a message in a dialog box, waits for the user to click a button, and returns an Integer indicating which button the user clicked.
NOWReturns a Variant (Date) specifying the current date and time according to your computer's system date and time.
NPERReturns a Double specifying the number of periods for an annuity based on periodic, fixed payments and a fixed interest rate.
NPVReturns a Double specifying the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate.
NZ(backwards compatibility)
OCT 
PARTITIONReturns a Variant (String) indicating where a number occurs within a calculated series of ranges.
PMTReturns a Double specifying the payment for an annuity based on periodic, fixed payments and a fixed interest rate.
PPMTReturns a Double specifying the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.
PVReturns a Double specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.
QBCOLORReturns a Long representing the RGB color code corresponding to the specified color number.
RANDOMIZE 
RATEReturns a Double specifying the interest rate per period for an annuity.
REPLACEReturns a string, which is a substring of a string expression beginning at the start position (defaults to 1), in which a specified substring has been replaced with another substring a specified number of times.
RESET 
RGBReturns a Long whole number representing an RGB color value.
RIGHTReturns a Variant (String) containing a specified number of characters from the right side of a string.
RMDIR 
RND 
ROUNDReturns a number rounded to a specified number of decimal places.
RTRIMReturns a Variant (String) containing a copy of a specified string without leading spaces (LTrim), trailing spaces (RTrim), or both leading and trailing spaces (Trim).
SAVESETTING 
SECONDReturns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the second of the minute.
SEEKReturns a Long specifying the current read/write position within a file opened by using the Open statement.
SENDKEYS 
SETATTR 
SGN 
SHELLRuns an executable program and returns a Variant (Double) representing the program's task ID if successful; otherwise, it returns zero.
SIN 
SLNReturns a Double specifying the straight-line depreciation of an asset for a single period.
SPACEReturns a Variant (String) consisting of the specified number of spaces.
SPCUsed with the Print # statement or the Print method to position output.
SPLITReturns a zero-based, one-dimensional array containing a specified number of substrings.
SQR 
STR 
STRCOMPReturns a Variant (Integer) indicating the result of a string comparison.
STRCONVReturns a Variant (String) converted as specified.
STRINGReturns a Variant (String) containing a repeating character string of the length specified.
STRINGFROMGUID(backwards compatibility)
STRREVERSEReturns a string in which the character order of a specified string is reversed.
SWITCHEvaluates a list of expressions and returns a Variant value or an expression associated with the first expression in the list that is True.
SYDReturns a Double specifying the sum-of-years' digits depreciation of an asset for a specified period.
TABUsed with the Print # statement or the Print method to position output.
TAN 
TIMEReturns a Variant (Date) indicating the current system time.
TIMERReturns a Single representing the number of seconds elapsed since midnight.
TIMESERIALReturns a Variant (Date) containing the time for a specific hour, minute, and second.
TIMEVALUEReturns a Variant (Date) containing the time.
TRIMReturns a Variant (String) containing a copy of a specified string without leading spaces (LTrim), trailing spaces (RTrim), or both leading and trailing spaces (Trim).
TYPENAMEReturns a String that provides information about a variable.
UCASEReturns a Variant (String) containing the specified string, converted to uppercase.
UNLOAD 
VAL 
VARTYPEReturns an Integer indicating the subtype of a variable, or the type of an object's default property.
WEEKDAYReturns a Variant (Integer) containing a whole number representing the day of the week.
WEEKDAYNAMEReturns a string indicating the specified day of the week.
YEARReturns a Variant (Integer) containing a whole number representing the year.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrev