دوال الاكسس مجمعة function نحتاج لمترجم

دوال الاكسس مجمعة
تحتاج لمترجم

function

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.