ByRef v ByVal in VBA. Creating an Increment Operator.

If you're familiar with languages like C there is an increment operator. To increase the value of X all you have to do is write X++ whereas in VB you have to say X=X+1. That doesn't seem like a lot of extra work, unless you have a long variable name like "CustomerStatementCounter" or something like that. So, wouldn't it be nice to create our own increment operator so all we have to say in our code is Inc X and that's it. That's what this lesson covers, and to do it, I'll teach you the different between ByRef and ByVal variable calls in our subs and functions. 

Alex from England (Admin) asks, "After watching yesterday’s Extended Cut video, you mentioned that Access VBA doesn’t have an Increment Operator like C does which is ++.  Does it support +="

Members

I'll show you how to use optional parameters, use our increment sub with a form field instead of just a variable, determine if a value is numeric, and create a public global subroutine or function.

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

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!

Links

Dim Variables: https://599cd.com/acd3
ByRef: https://599cd.com/byref
ByVal: https://599cd.com/byval
Create a Function: https://599cd.com/CreateFunction
Optional Parameters: https://599cd.com/acd1
Passing a Control as a Parameter: https://599cd.com/acd15
Variant: https://599cd.com/acd3
IsNumeric: https://599cd.com/acx25
Create a Global Module: : https://599cd.com/acd5

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.