Fungsi Tab Control Microsoft Access

admin

This article contains links to articles that provide details about common functions used in expressions in Microsoft Access. They are arranged first by group and then are arranged alphabetically at the end of this article.

Tip: Beginning with Access 2010, the Expression Builder has IntelliSense, so you can see what arguments your expression requires.

Sebagai contoh ketika kita membuat form yang berkaitan dengan data siswa, kita akan kesulitan untuk membuat TextBox untuk TTL (Tempat, Tanggal Lahir), misal TextBox dengan format: Grobogan, 11 November 1992, padahal untuk Control Source untuk Tempat berasal dari field yang berbeda dengan field Tanggal Lahir. Dalam database desktop, Anda juga bisa menggunakan operator dan (&) untuk penggabungan. Dalam aplikasi Access, Anda harus menggunakan tanda tambah (+). Masih banyak lagi fungsi terkait teks di Access. Cara yang bagus untuk mempelajari selengkapnya tentang fungsi tersebut adalah membuka Penyusun Ekspresi dan menelusuri daftar fungsinya.

ActiveX

CreateObject Function
GetObject Function

Application

Control

Command Function
Shell Function

Arrays

Array Function
Filter Function
Join Function
LBound Function
Split Function
UBound Function

Conversion

Asc Function
Chr Function
EuroConvert Function
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
GUIDFromString Function
Hex Function
Nz Function
Oct Function
Str Function
StringFromGUID Function
Type Conversion Functions
Val Function

Fungsi Tab Control Microsoft Access

Database

DDE Function
DDEInitiate Function
DDERequest Function
DDESend Function
Eval Function
Partition Function

Date/Time

Fungsi Tab Control Microsoft Access

Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Day Function
Hour Function
Minute Function
Month Function
MonthName Function
Now Function
Second Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
Weekday Function
WeekdayName Function
Year Function

Domain Aggregate

DAvg Function
DCount Function
DFirst, DLast Functions
DLookup Function
DMin, DMax Functions
DStDev, DStDevP Functions
DSum Function
DVar, DVarP Functions

Error Handling

CVErr Function
Error Function

File Input/Output

EOF Function
FreeFile Function
Input Function
Loc Function
LOF Function
Seek Function

File Management

CurDir Function
Dir Function
FileAttr Function
FileDateTime Function
FileLen Function
GetAttr Function

Financial

DDB Function
FV Function
IPmt Function
IRR Function
MIRR Function
NPer Function
NPV Function
Pmt Function
PPmt Function
PV Function
Rate Function
SLN Function
SYD Function

Inspection

Environ Function
GetAllSettings Function
GetSetting Function
IsArray Function
IsDate Function
IsEmpty Function
IsError Function
IsMissing Function
IsNull Function
IsNumeric Function
IsObject Function
TypeName Function
VarType Function

Math

Abs Function
Atn Function
Cos Function
Exp Function
Int, Fix Functions
Log Function
Rnd Function
Round Function
Sgn Function
Sin Function
Sqr Function
Tan Function

Messages

InputBox Function
MsgBox Function

Ms access form with tabs

Miscellaneous

CallByName Function
IMEStatus Function
MacID Function
MacScript Function
QBColor Function
RGB Function
Spc Function
Tab Function

Program Flow

Choose Function
DoEvents Function
IIf Function
Switch Function

SQL Aggregate

Avg Function
Count Function
Min, Max Functions
StDev, StDevP Functions
Sum Function
Var, VarP Functions

Text

Combo Box

Format Function
InStr Function
InStrRev Function
LCase Function
Left Function
Len Function
LTrim, RTrim, and Trim Functions
Mid Function
Replace Function
Right Function
Space Function
StrComp Function
StrConv Function
String Function
StrReverse Function
UCase Function

Ms Access Tab Control Vba

Functions (alphabetical)

Ms Access Form Tab Control

Abs Function
Array Function
Asc Function
Atn Function
Avg Function
CallByName Function
Choose Function
Chr Function
Command Function
Cos Function
Count Function
CreateObject Function
CurDir Function
CVErr Function
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
DAvg Function
Day Function
DCount Function
DDB Function
DDE Function
DDEInitiate Function
DDERequest Function
DDESend Function
DFirst, DLast Functions
Dir Function
DLookup Function
DMin, DMax Functions
DoEvents Function
DStDev, DStDevP Functions
DSum Function
DVar, DVarP Functions
Environ Function
EOF Function
Error Function
EuroConvert Function
Eval Function
Exp Function
FileAttr Function
FileDateTime Function
FileLen Function
Filter Function
Format Function
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
FreeFile Function
FV Function
GetAllSettings Function
GetAttr Function
GetObject Function
GetSetting Function
GUIDFromString Function
Hex Function
Hour Function
IIf Function
IMEStatus Function
Input Function
InputBox Function
InStr Function
InStrRev Function
Int, Fix Functions
IPmt Function
IRR Function
IsArray Function
IsDate Function
IsEmpty Function
IsError Function
IsMissing Function
IsNull Function
IsNumeric Function
IsObject Function
Join Function
LBound Function
LCase Function
Left Function
Len Function
Loc Function
LOF Function
Log Function
LTrim, RTrim, and Trim Functions
MacID Function
MacScript Function
Mid Function
Min, Max Functions
Minute Function
MIRR Function
Month Function
MonthName Function
MsgBox Function
Now Function
NPer Function
NPV Function
Nz Function
Oct Function
Partition Function
Pmt Function
PPmt Function
PV Function
QBColor Function
Rate Function
Replace Function
RGB Function
Right Function
Rnd Function
Round Function
Second Function
Seek Function
Sgn Function
Shell Function
Sin Function
SLN Function
Space Function
Spc Function
Split Function
Sqr Function
StDev, StDevP Functions
Str Function
StrComp Function
StrConv Function
String Function
StringFromGUID Function
StrReverse Function
Sum Function
Switch Function
SYD Function
Tab Function
Tan Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
Type Conversion Functions
TypeName Function
UBound Function
UCase Function
Val Function
Var, VarP Functions
VarType Function
Weekday Function
WeekdayName Function
Year Function