Access Function Access Method (VBA) Access Object Property (VBA)
This page lists all the Access VBA 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 function
| 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 |
| wExtractSymbol | A custom Function to extract symbol 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 |
| wRemoveLineBreak | A custom Function to remove line break and carriage return |
| wRpad | A custom Function to add characters to suffix |
| wSplit | Delimit a text and extract the Nth substring |
| wSumExtractNumber | A custom Function to Sum number part of text in a Range |
| wUniqueStr | A custom Function to remove duplicate in a text |
Numeric Function
| 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 |
Date Function
| Function | Description |
|---|---|
| wDateDif | A custom Function to simulate Excel worksheet Function DateDif to calculate year month day difference between two dates |
| wNetworkdays | A custom Function that simulates Excel worksheet Function Networkdays to calculate number of work days (exclude Sat and Sun) between two dates. Suitable for people who cannot install Analysis ToolPak |
Boolean Function (True / False)
| 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 |
Finance Function
| Function | Description |
|---|---|
| NPV | Calculate Net Present Value |
Other Function
| Function | Description |
|---|