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
[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
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
[/table]
Numeric Function
[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 Function
[table width=”750″ colwidth=”150|600″ ]
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
[/table]
Boolean Function (True / False)
[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]
Finance Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
NPV, Calculate Net Present Value
[/table]
Other Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
[/table]