دوال الاكسس مجمعة
تحتاج لمترجم
| A | B | C |
|---|---|---|
| Abs | Math | Returns a value of the same type that is passed to it specifying the absolute value of a number. |
| Array | Arrays | Returns a variant containing an array. |
| Asc | Conversion | Returns an integer representing the ANSI code corresponding to the first character in a string. |
| AscB | Conversion | Returns an integer representing the ANSI code corresponding to the first character in a string. |
| Atn | Math | Returns a double containing the arctangent of a number. |
| Avg | SQL | Calculates the arithmetic mean of a set of values contained in a specified field of a query, form, or report. |
| BOF | File Input/Output | Check for the Beginning of a file opened for random or sequential input. |
| CBool | Conversion | Converts any valid string or numeric expression to a value of True (-1) or False (0). |
| CByte | Conversion | Converts a numeric expression in the range 0-255 to the Byte data type. |
| CCur | Conversion | Converts a numeric expression in the range -922,337,203,685,477.5808 to 922,337,203,685,477.5807 to the Currency data type. |
| CDate | Conversion | Converts any valid date expression to the Date data type. |
| CDbl | Conversion | Converts a valid numeric expression in the range -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values to the Double Precision data type. |
| CDec | Conversion | |
| ChDir | File Input/Output | Changes the current directory or folder. |
| ChDrive | File Input/Output | Changes the current drive. |
| Choose | Control of Program Flow | Selects and returns a value from a list of arguments. |
| Chr | Conversion | Returns the character associated with the specified ANSI code. |
| Chr$ | Conversion | Returns the character associated with the specified ANSI code. |
| ChrB | Conversion | |
| ChrB$ | Conversion | |
| ChrW | Conversion | Returns a string containing the Unicode character. |
| CInt | Conversion | Converts a valid numeric expression in the range -32,768 to 32,767 (fractions are rounded to the nearest even number) to the Integer data type. |
| CLng | Conversion | Converts a valid numeric expression in the range -2,147,483,648 to 2,147,483,647 (fractions are rounded) to the Long Integer Data type. |
| Close | File Input/Output | Concludes input/output (I/O) to a file opened using the Open statement. |
| Cos | Math | Returns a double containing the cosine of an angle. |
| Count | SQL | Calculates the number of selected records in a query, form, or report. |
| CreateObject | Object Linking and Embedding (OLE) | Creates and returns a reference to an ActiveX object. |
| CSng | Conversion | Converts a valid numeric expression in the range -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values to the Single Precision data type. |
| CStr | Conversion | Converts an expression to a string. |
| CurDir | File Input/Output | Returns a variant string containing the full path of the specified drive. If the drive argument is empty or missing, CurDir returns the path for the current drive. |
| CurDir$ | File Input/Output | Returns a string containing the full path of the specified drive. If the drive argument is empty or missing, CurDir returns the path for the current drive. |
| CurrentUser | Miscellaneous | Returns the name of the current user of the database. |
| CVar | Conversion | Converts expressions in the same range as Double Precision for numerics and in the same range as String for non-numerics to a Varient data type. |
| CVDate | Conversion | Converts a string or numeric expression that can be interpreted as a date. |
| CVErr | Conversion | Returns a variant of subtype error containing an error number specified by the user. |
| Date | Date/Time | Returns a variant (date) containing the current system date. |
| Date$ | Date/Time | Returns a string containing the current system date. |
| DateAdd | Date/Time | Adds a specified time interval to a date. |
| DateDiff | Date/Time | Returns the number of time intervals between two dates. |
| DatePart | Date/Time | Returns the specified part of a given date. |
| DateSerial | Date/Time | Returns a variant (date) for the specified year, month, and day. |
| DateValue | Date/Time | Returns a date type from a given string. |
| DAvg | Domain | Returns the arithmetic mean of a set of values in a specified set of records. |
| Day | Date/Time | Returns a variant (integer) containing the day part of a date. |
| DCount | Domain | Returns the number of selected records in a specified set of records. |
| DDB | Financial | Returns the depreciation of an asset for a specific time period using the double-declining balance method or some other method you specify. |
| DDE | Dynamic Data Exchange (DDE) | Initiate a dynamic data exchange (DDE) conversation with another application, request an item of information from that application, and display that information in a control on a form or report. |
| DFirst | Domain | Return a field value from the first record in a specified set of records. |
| Dir | File Input/Output | Returns the name of a file, directory, or folder that matches a specified pattern or file attribute, or the volume label of a drive. |
| Dir$ | File Input/Output | Returns the name of a file, directory, or folder that matches a specified pattern or file attribute, or the volume label of a drive. |
| DLast | Domain | Return a field value from the last record in a specified set of records. |
| DLookUp | Domain | Returns a field value in a specified set of records. |
| DMax | Domain | Return the maximum value from a specified set of records. |
| DMin | Domain | Return the minimum value from a specified set of records. |
| DStDev | Domain | Returns an estimate of the standard deviation for a population sample. |
| DStDevP | Domain | Returns an estimate of the standard deviation for a population. |
| DSum | Domain | Returns the sum of a set of values in a specified set of records. |
| DVar | Domain | Returns an estimate of the variance for a population sample. |
| DVarP | Domain | Returns an estimate of the variance for a population. |
| Environ | File Input/Output | Returns the string associated with an operating system environment variable |
| Environ$ | Miscellaneous | Returns the string associated with an operating system environment variable |
| EOF | File Input/Output | Check for the end of a file opened for random or sequential input. |
| Error | Error Handling | Returns the error message that corresponds to a given error number. |
| Error$ | Error Handling | Returns the error message that corresponds to a given error number. |
| EuroConvert | Conversion | Convert a number to euro or from euro to a participating currency. |
| Eval | Miscellaneous | Evaluates an expression and returns its value. |
| Exp | Math | Returns a double specifying e (the base of natural logarithms) raised to a power. |
| FileAttr | File Input/Output | Returns file mode or operating system file handle information about an open file. |
| FileCopy | File Input/Output | Copies a file. |
| FileDateTime | File Input/Output | Returns a variant date indicating the file creation date or date of last update. |
| FileLen | File Input/Output | Retuns the length of a file in bytes. |
| First | SQL | Return a field value from the first record in a query, form, or report. |
| Fix | Math | Returns the integer portion of a number |
| Format | Conversion | Format a number, date, time, or string according to instructions contained in a formate expression. |
| Format$ | Conversion | Format a number, date, time, or string according to instructions contained in a formate expression. |
| FormatCurrency | Conversion | Returns an expression formatted as a currency value using the currency symbol defined in the system control panel. |
| FormatDateTime | Conversion | Returns an expression formatted as a date or time. |
| FormatNumber | Conversion | Returns an expression formatted as a number. |
| FormatPercent | Control of Program Flow | Returns an expression formatted as a percentage (multipled by 100) with a trailing % character. |
| FreeFile | File Input/Output | Returns the next valid unused file number. |
| FV | Financial | Returns the future value of an annuity based on periodic constant payments and a constant interest rate. |
| Get | File Input/Output | Reads data into a variable. |
| GetAttr | File Input/Output | Returns the DOS attribute byte of a file. |
| GetObject | Object Linking and Embedding (OLE) | Returns an OLE Automation object from a file. |
| GUIDFromString | Conversion | The GUIDFromString function converts a string (string: A collection of characters that can include both numbers and text.) to a GUID (GUID: A 16-byte field used in an Access database to establish a unique identifier for replication. GUIDs are used to iden |
| Hex | Conversion | Returns the hexadecimal value of a decimal argument. |
| Hex$ | Conversion | Returns the hexadecimal value of a decimal argument. |
| Hour | Date/Time | Returns a variant(Integer) specifying a whole number between 0 and 23, inclusie, that represents the hour of the day corresponding to the time provide as an argument. |
| Iif | Control of Program Flow | Returns one of two arguments depending on the evaluation of an expression |
| IMEStatus | Inspection of Variables | East Asian versions only |
| Input | File Input/Output | Returns String containing characters from a file opened in Input or Binary mode. |
| Input # | File Input/Output | |
| InputBox | Miscellaneous | Displays a prompt in a dialog box and waits for input. |
| InStr | Strings | Returns a variant (long) containing the position of the first occruence of one string within another string. |
| InStrRev | Strings | Returns a variant (long) containing the position of the first occruence of one string within another string counting from the right. |
| Int | Math | Returns the integer portion of a number |
| IPmt | Financial | Returns the interest payment for a given period of an annuity based on periodic, constant payments and a constant interest rate. |
| IRR | Financial | Returns the internal rate of return for a series of periodic cash flows. |
| IsArray | Inspection of Variables | Returns a boolean indicating whether a variable is an array. |
| IsDate | Inspection of Variables | Returns a value indicating whether or not a variant argument can be converted to a date. |
| IsEmpty | Inspection of Variables | Returns a value indicating whether or not a variant variable has been initialized. |
| IsError | Inspection of Variables | |
| IsMissing | Inspection of Variables | Returns a value indicating whether an optional variant has been passed to a procedure. |
| IsNull | Inspection of Variables | Returns a value that indicates whether or not an expression contains the special Null value. |
| IsNumeric | Inspection of Variables | Returns a value indicating whether or not an expression can be converted to a numeric data type. |
| IsObject | Inspection of Variables | Returns a value indicating whether an identifier represents an object variable. |
| Join | Arrays | Returns a string created by joining a number of substrings contained in an array. |
| Kill | File Input/Output | Delete 1 or more files from disk. |
| Last | SQL | Return a field value from the last record in a query, form, or report |
| Lbound | Arrays | Returns the smallest available subscript for the specified dimension of an array. |
| LCase | Conversion | Returns a Variant in which all letters of an argument have been converted to lowercase. |
| LCase$ | Conversion | Returns a string in which all letters of an argument have been converted to lowercase. |
| Left | Strings | Returns the leftmost n characters of a string. |
| Left$ | Strings | Returns the leftmost n characters of a string. |
| LeftB | Strings | |
| LeftB$ | Strings | |
| Len | Strings | Returns the number of characters in a string expression or the number of bytes required to store a variant as a string. |
| Line Input # | File Input/Output | Reads a single line from an open sequential file and assigns it to a String variable. |
| Loc | File Input/Output | Returns the current position within an open file. |
| LOF | File Input/Output | Returns the size of a file in bytes. |
| Log | Math | Returns a double specifying the natural logarithm of a number. |
| LSet | Strings | Left aligns a string within a string variable, or copies a variable of one user-defined type to another variable of a different user-defined type. |
| LTrim | Strings | Return a copy of a string with leading spaces removed. |
| LTrim$ | Strings | Return a copy of a string with leading spaces removed. |
| Max | SQL | Return the maximum of a set of values contained in a specified field in a query, form, or report. |
| Mid | Strings | Return a variant (string) containing a specified number of characters from a string. . |
| Mid$ | Strings | Return a string containing a specified number of characters from a string. . |
| Min | SQL | Return the minimum of a set of values contained in a specified field in a query, form, or report. |
| Minute | Date/Time | Returns a variant(Integer) specifying a whole number between 0 and 59, inclusive, representing the minute of the hour. |
| MIRR | Financial | Returns the modified internal rate of return for a series of period cash flows. |
| MkDir | File Input/Output | Creates a new directory or folder. |
| Month | Date/Time | Returns a variant(Integer) containing the month part of a date. |
| MonthName | Date/Time | Returns a string containing the specified month |
| Name | File Input/Output | Renames a disk file, directory, or folder. |
| Now | Date/Time | Returns a variant(date) specifying the current date and time according your computer's system date and time. |
| NPer | Financial | Returns the number of periods for an annuity based on periodic, constant payments and a constant interest rate. |
| NPV | Financial | Retuns the net present value of an investment based on a series of periodic cash flows and a discount rate. |
| Nz | Conversion | Returns the specified value when the passed argument is null. |
| Oct | Conversion | Returns the octal value of a decimal argument. |
| Oct$ | Conversion | Returns the octal value of a decimal argument. |
| Open | File Input/Output | Enables a file for I/O |
| Partition | SQL | Returns a variant (string) indicating where a number occurs within a calculated series of ranges. |
| Pmt | Financial | Returns the payment for an annuity based on periodic, constant payments and a constant interest rate. |
| PPmt | Financial | Returns the principal payment for a given period of an annuity based on periodic, constant payments and a constant interest rate. |
| Print # | File Input/Output | Writes display formatted data to a file. |
| Put | File Input/Output | Writes data to a random file. |
| PV | Financial | Returns the present value of an annuity based on periodic, constant payments to be paid in the future and a constant interest rate. |
| QBColor | Graphics on Printed Reports | Returns the RGB (red-green-blue) color value corresponding to a color number. |
| Randomize | Math | Initializes the random number generator. |
| Rate | Financial | Returns the interest rate per period for an annuity. |
| Replace | Miscellaneous | Returns a string in which a specified substring has been replaced with another substring a specified number of times. |
| Reset | File Input/Output | Closes all disk files opened using the Open statement. |
| RGB | Graphics on Printed Reports | Returns a long value representing an RGB (red-green-blue) color value. |
| Right | Strings | Returns the rightmost n characters of a string. |
| Right$ | Strings | Returns the rightmost n characters of a string. |
| RightB | Strings | |
| RightB$ | Strings | |
| RmDir | File Input/Output | Removes an existing directory or folder. |
| Rnd | Math | Returns a single containing a random number. |
| Round | Math | Returns a number rounded to a specified number of decimal places. |
| RSet | Strings | Right aligns a string within a string variable. |
| RTrim | Strings | Return a copy of a string with trailing spaces removed. |
| RTrim$ | Strings | Return a copy of a string with trailing spaces removed. |
| Second | Date/Time | Returns a varient(integer) specifying a whold number between 0 and 59, inclusive, representing the second of the minute of the hour. |
| Seek | File Input/Output | Returns the current file position. |
| SetAttr | File Input/Output | Sets the DOS attribute of a file. |
| Sgn | Math | Returns a variant indicating the sign of a number. |
| Sin | Math | Returns the sine of an angle. |
| SLN | Financial | Returns the straight-line depreciation of an asset for a single period. |
| Space | Strings | Returns a variant consisting of a specified number of spaces. |
| Space$ | Strings | Returns a string consisting of a specified number of spaces. |
| Spc | File Input/Output | Used with the Print # statement or the Print method to position output. |
| Sqr | Math | Returns the square root of a number |
| StDev | SQL | Returns an estimate of the standard deviation for a population sample represented as a set of values contained in a specified field of a query, form, or report. |
| StDevP | SQL | Returns an estimate of the standard deviation for a population represented as a set of values contained in a specified field of a query, form, or report. |
| Str | Conversion | Return a string representation of the value of a numeric expression. |
| Str$ | Conversion | Return a string representation of the value of a numeric expression. |
| StrComp | Strings | Returns a variant (long) that indicates the result of the comparison of two strings. |
| StrConv | Strings | Convert a string to upper case, lower case, proper case, or several other formats. |
| String | Strings | Returns a Variant (String) containing a repeating character string of the length specified. |
| String$ | Strings | Returns a String containing a repeating character string of the length specified. |
| StringFromGUID | Conversion | Converts a GUID which is an array of type Byte, to a string. |
| StrReverse | Strings | Returns a string in which the character order of the parameter string is reversed. |
| Sum | SQL | Returns the sum of a set of values in a set of values contained in a specified field in a query, form, or report. |
| Switch | Control of Program Flow | Evaluates a list of expressions and returns a value or an expression associated with the first expression in the list that is true. |
| SYD | Financial | Returns the sum-of-years' digits depreciation of an asset for a specified period. |
| Tab | File Input/Output | Used with the Print # statement or the Print method to position output. |
| Tan | Math | Returns the tangent of an angle. |
| Time | Date/Time | Returns the current system time. |
| Time$ | Date/Time | Returns the current system time. |
| Timer | Date/Time | Returns the number of seconds that have elapsed since midnight (12 AM). |
| TimeSerial | Date/Time | Returns the time for a specific hour, minute, and second. |
| TimeValue | Date/Time | Returns the time represented by a string argument. |
| Trim | Strings | Return a copy of a string with leading and trailing spaces removed. |
| Trim$ | Strings | Return a copy of a string with leading and trailing spaces removed. |
| TypeName | Inspection of Variables | Returns a string that identifies the data type of the parameter |
| UBound | Arrays | Returns the largest available subscript for the specified dimension of an array. |
| UCase | Conversion | Returns a variant (string) containing the specified string, converted to upper case. |
| UCase$ | Conversion | Returns a string containing the specified string, converted to upper case. |
| Val | Conversion | Returns the numeric value of a string of characters. |
| Var | SQL | Returns an estimate of the variance for a population sample represented as a set of values contained in a specified field of a query, form, or report. |
| VarP | SQL | Returns an estimate of the variance for a population represented as a set of values contained in a specified field of a query, form, or report. |
| VarType | Inspection of Variables | Returns a value that indicates how a variant is stored internally. |
| Weekday | Date/Time | Returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the week cooresponding to the date and the first day of the week provided as arguments. |
| WeekdayName | Date/Time | Returns the name of the day of the week cooresponding to the date and the first day of the week provided as arguments. |
| Width # | File Input/Output | Assigns an output line width to a file opened using the Open statement. |
| Write # | File Input/Output | Writes data to a file. |
| Year | Date/Time | Returns a variant(Integer) that represents the year part of the date. |
