Access Function (VBA) Access Method (VBA) Access Object Property (VBA)
This page lists all the Access functions that have been explained in this website.
Most custom Functions were created for Excel but they are usable in Access, therefore you will see my custom Functions link to Excel topics.
You may also want to read:
Differences among Function, Sub, Method, Property
String Functions
[table width=”750″ colwidth=”150|600″ ]
Function, Description
Chr, Convert ASCII value to character
Instr, Return the position of substring
Mid, Extract substring
wCapLetter, A custom Function to capitalize first letter in a sentence
wCheckAlphabet, A custom Function to check if a text contains any alphabet
wCheckNumber, A custom Function to check if a text contains any number
wCheckOnlyAlphabet, A custom Function to check if a text contains only alphabet
wCheckOnlyNumber, A custom Function to check if a text contains only number
wCheckSymbol, A custom Function to check if a text contains any symbol
wCheckHKID, A custom Function to check the last digit of HKID
wCustomSort, A custom Function to assign numeric value to Text for custom sort
wExtractAlphabet, A custom Function to extract alphabet from text
wExtractNumber, A custom Function to extract number from text
wExtractPercent, A custom Function to extract Percent from text
wLpad, A custom Function to add leading character
wRandomHKID, A custom Function to generate random HKID (Hong Kong ID card number)
wRandomLetter, A custom Function to generate random letter a to z / A to Z / a to Z
wSumExtractNumber, A custom Function to Sum number part of text in a Range
wExtractSymbol, A custom Function to extract symbol from text
wRpad, A custom Function to add characters to suffix
wSplit, Delimit a text and extract the Nth substring
wUniqueStr, A custom Function to remove duplicate in a text
[/table]
Numeric Functions
[table width=”750″ colwidth=”150|600″ ]
Function, Description
Int, Get the integer part of a number
Round, Rounding that uses Round to Even logic
Rnd, Generate random number
wExtractNumber, A custom Function to extract number from text
wExtractPercent, A custom Function to extract Percent from text
wIsPrimeNumber, A custom Function to check if a number is prime number
wMRound, A custom Function to simulate spreadsheet MROUND Function
wRandomNumber, A custom Function to generate random number by specifying lowerbound and upperbound
wRound, A custom Function to simulate spreadsheet Round Function
[/table]
Date Functions
[table width=”750″ colwidth=”150|600″ ]
Function, Description
wNetworkdays, A custom Function that simulates Excel worksheet Networkdays to calculate number of work days (exclude Sat and Sun) between two dates. Suitable for people who cannot install Analysis ToolPak
[/table]
Lookup/Reference Functions
[table width=”750″ colwidth=”150|600″ ]
Function, Description
wCheckAlphabet, A custom Function to check if a text contains any alphabet
wCheckNumber, A custom Function to check if a text contains any number
wCheckOnlyAlphabet, A custom Function to check if a text contains only alphabet
wCheckOnlyNumber, A custom Function to check if a text contains only number
wCheckSymbol, A custom Function to check if a text contains any symbol
wCheckHKID, A custom Function to check if the Check Digit (last digit) of HKID is correct
wIsPrimeNumber, A custom Function to check if a number is prime number
[/table]
Other Functions
[table width=”750″ colwidth=”150|600″ ]
Function, Description
[/table]