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

[@benjaminferland4251]

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!!

[@599CD]

So glad to help. :)

[@clemdacier1402]

Thanks!

[@599CD]

Thank you so much! :)

[@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.

[@ieteeman]

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

[@599CD]

Extraordinary? :)

[@rogerstrate5727]

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".

[@599CD]

Peace... and long life.

[@rogerstrate5727]

@@599CD It's always great to hear from the best source I know so thanks again. And as Spock would say “Insufficient facts always invite danger.”

[@akokohjoel9854]

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.

[@599CD]

More on the way....

[@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."

[@599CD]

I've never heard that one before... but the IT industry does love our acronyms. LOL

[@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?

[@599CD]

599cd.com/ask

[@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.

[@599CD]

Here's a video on FOR loops: kzbin.info/www/bejne/aqfCkIB4iNtpiM0 I'll probably do one on WHILE loops soon.

[@rshaddock]

I like your Star Trek references :)

[@599CD]

Fascinating.

[@danielthelawd2213]

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

[@599CD]

Sure set the visible property in the 599cd.com/AfterUpdate event

[@JstnW]

Good stuff!

[@599CD]

Thanks

[@ramprakashmaurya3236]

Best 👌

[@599CD]

Thanks

[@金小文-h2j]

very useful.

[@599CD]

Thanks

[@darrenbarson3828]

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 :-)

[@599CD]

If you want to see the $ then either add it, or format it as currency.

[@darrenbarson3828]

@@599CD Thanks for the reply, but it didn't really answer my query. Are you saying that dim...as currency is the same as dim...as double for instance? Why do we dim...as anything if it doesn't change the format of whatever is output? As far as I can see, dim...as doesn't actually make any difference to calculations or outputs etc? I really don't understand why we dim...as anything at all?