Declaring Variables in Microsoft Access VBA. Dim, Public, Private, Static, TempVars, And More...

In this Microsoft Access tutorial, I will teach you about variables in VBA: how to declare them, how to use them, and some other cool tips.

LEARN MORE:

LINKS:

DEVELOPER COURSES:

RECOMMENDED COURSES:

ADDITIONAL RESOURCES:

KEYWORDS
access 2016, access 2019, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, declaring variables, dim statement, What is a variable, compile error, variable not defined, scope, static, public, private, tempvars, VBA Variables, Data Types, reserved words

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[thesantosfamily]

Thank you! Very helpful. I learned about variables a long time ago but couldn't remember how they work. This was a great refresher video.

[benjaminferland]

Hi Richard! Long time watcher here, thanks for posting this! Variables are something I struggled to understand fully, and when you say “Dim for Dimension” everything clicked into place magically! I have now built two large databases thanks to your tutorials, one for a major hospital and another for a large biotech company. Coding is not my job, but since no good software exist in my specialty field a build it yourself approach worked perfect! Thanks to you and to Microsoft for Access!!

[rabidfollower]

Yes, I've always heard that DIM stands for "dimension." In old-style BASIC, it was used to set array dimension. But nowadays, since it is not just for arrays, I've also heard that DIM stands for "declare in memory."

[rogerstrate]

Thanks Richard, this video gives me a better understanding of variables and how to use them properly. I love all your videos you are an awesome instructor. "Live long and prosper".

[ieteeman]

You are a Great Man
There is no word invented yet can describe you

[akokohjoel]

Thanks for your video on variable. I love the simple approach and illustrations used to each what variables are. Pls teach us more. Thanks once More.

[ehteshamshah]

Dear Richard will u plz brief us abt Loop, End Loop etc. in Access VBA. Your method of teaching is very easy and awesome.

[danielthelawd]

Is there a way to to make textboxes turn invisible by clicking buttons in another formula?

[WantedMobileGaming]

I need help with setting up a date code. So I will have something like 2D22 so the first 2 is representing the century which is 2000 the D represent the month of the year and so on how would you do something like that in VBA?

[darrenbarson]

Why did you use as Currency if it didn't actually make any difference? For instance, in the message box, all we got was 1000 rather than $1000. If it's dim .. as currency, why does it not change the value to currency?

Thanks :-)