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

  Рет қаралды 15,091

Computer Learning Zone

Computer Learning Zone

Күн бұрын

Пікірлер: 31
@thesantosfamily
@thesantosfamily 5 ай бұрын
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.
@benjaminferland4251
@benjaminferland4251 2 жыл бұрын
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
@599CD 2 жыл бұрын
So glad to help. :)
@rabidfollower
@rabidfollower 2 жыл бұрын
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
@599CD 2 жыл бұрын
I've never heard that one before... but the IT industry does love our acronyms. LOL
@ieteeman
@ieteeman Жыл бұрын
You are a Great Man There is no word invented yet can describe you
@599CD
@599CD Жыл бұрын
Extraordinary? :)
@rogerstrate5727
@rogerstrate5727 2 жыл бұрын
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
@599CD 2 жыл бұрын
Peace... and long life.
@rogerstrate5727
@rogerstrate5727 2 жыл бұрын
@@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
@akokohjoel9854 2 жыл бұрын
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
@599CD 2 жыл бұрын
More on the way....
@ehteshamshah
@ehteshamshah 2 жыл бұрын
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
@599CD 2 жыл бұрын
Here's a video on FOR loops: kzbin.info/www/bejne/aqfCkIB4iNtpiM0 I'll probably do one on WHILE loops soon.
@WantedMobileGaming
@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 Жыл бұрын
599cd.com/ask
@rshaddock
@rshaddock 2 жыл бұрын
I like your Star Trek references :)
@599CD
@599CD 2 жыл бұрын
Fascinating.
@clemdacier1402
@clemdacier1402 7 ай бұрын
Thanks!
@599CD
@599CD 7 ай бұрын
Thank you so much! :)
@JstnW
@JstnW 2 жыл бұрын
Good stuff!
@599CD
@599CD 2 жыл бұрын
Thanks
@danielthelawd2213
@danielthelawd2213 2 жыл бұрын
Is there a way to to make textboxes turn invisible by clicking buttons in another formula?
@599CD
@599CD 2 жыл бұрын
Sure set the visible property in the 599cd.com/AfterUpdate event
@ramprakashmaurya3236
@ramprakashmaurya3236 2 жыл бұрын
Best 👌
@599CD
@599CD 2 жыл бұрын
Thanks
@金小文-h2j
@金小文-h2j 2 жыл бұрын
very useful.
@599CD
@599CD 2 жыл бұрын
Thanks
@darrenbarson3828
@darrenbarson3828 2 жыл бұрын
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
@599CD 2 жыл бұрын
If you want to see the $ then either add it, or format it as currency.
@darrenbarson3828
@darrenbarson3828 2 жыл бұрын
@@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?
ЛУЧШИЙ ФОКУС + секрет! #shorts
00:12
Роман Magic
Рет қаралды 10 МЛН
Yay, My Dad Is a Vending Machine! 🛍️😆 #funny #prank #comedy
00:17
小蚂蚁会选到什么呢!#火影忍者 #佐助 #家庭
00:47
火影忍者一家
Рет қаралды 126 МЛН
Microsoft Access - Working With TempVars in VBA
22:12
D Pineault - Tech, Programming and more
Рет қаралды 1,5 М.
53. VBA - Recordsets Part 1 (Programming In Microsoft Access 2013) 🎓
20:01
Programming Made EZ
Рет қаралды 176 М.
How to Declare (Dim) and Set VBA Variables (use data types correctly)
7:32
Understanding Recordsets in Microsoft Access VBA - a Beginner's Guide
20:48
Computer Learning Zone
Рет қаралды 10 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 209 М.
40. VBA - DoCmd (Programming In Microsoft Access 2013) 🎓
37:27
Programming Made EZ
Рет қаралды 179 М.
Getting Started with MS Access Visual Basic for Applications - VBA Code-Behind and Modules
32:06
How to Use Collections in Microsoft Access VBA
21:35
Sean MacKenzie Data Engineering
Рет қаралды 5 М.
ЛУЧШИЙ ФОКУС + секрет! #shorts
00:12
Роман Magic
Рет қаралды 10 МЛН