Create Your Own Custom Function in Microsoft Access VBA

In this video, I will show you how to create your own custom, user-defined functions in Microsoft Access VBA (Visual Basic for Applications). We will start with a subroutine, and then create a couple functions. We will create a random number generator, and functions to convert Celsius to Fahrenheit and vice versa. You will learn how to pass parameter values to functions, and have them return a value.

Michael in Louisville KY (a Gold Member) asks: I'm familiar with the built-in Access functions like Date() and Now(). Is there a way I can create my own custom functions to perform the specific calculations I need?

Members

I'll show you how to create public functions and global modules so your functions can be used in every form, report, and query in your database. You will see how to set a lower bound for your random numbers, so you can, for example, generate random numbers from 10 to 20. We will build a dice roller where you can roll any number of multi-sided dice in sets. Very handy for you gamers and D&D players who want to generate character stats. (This one's for the nerds like me). 

•  Extended Cut Video - Silver
•  Database Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

Intro to VBA: https://599cd.com/IntroVBA
Custom Functions: https://599cd.com/acd2
Random Numbers: https://599cd.com/RandomNumbers

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.