Variable Scope & Visibility in Microsoft Access VBA (Public, Private, Dim, Global, etc.)

[@petewarby7158]

I mean this is UNBELIEVABLE. I have been trying for days to find a way to do something re using field values between forms and this has nailed it! I'm creating a gallery form for my wife's cake business and couldn't figure how to grab text field contents to copy to another form's field to load the image from. This is AWESOME. I should bin Google off and just trawl your videos. Brilliant. BRILLIANT. I've commented before to say my entry level database would have been BORING but your videos have turned it in to (what i think) is a work of art!!!

[@599CD]

Awesome. Glad you find them helpful.

[@coderdecoder5947]

Excellent. I’m truly impressed with your teaching ability and the way you organize things.

[@599CD]

Thanks

[@ashishtrivedi8253]

You have explained scope of variable in great detail and with working codes. That was great help, thx a ton.

[@599CD]

You are welcome!

[@MadGenious]

Man Access is old school.. really wish you start making Oracle 19c courses, you teach really well and i have no one to guide me even tho it's alot better than access especially at large scale databases.

[@599CD]

Access is where it's at.

[@rabidfollower]

Excellent video, and an important topic too since the concept of scope and visibility applies to any programming language. Sometimes you also need to use naming convention to denote scopes. I use "G_" to prefix all global-level variables and "M_" to denote module-level ones.

[@599CD]

Thank you.

[@satyabanukil779]

Yes. Video quite helpful and comprehensive. A tutorial on building a SUM Module or function would be useful. In excel it is easy but for Access, it is not that easy.

[@599CD]

599cd.com/DSum

[@stuartround]

Really useful and beautifully explained. Thank you!

[@599CD]

Glad you enjoyed it!

[@RobertTozzi]

Ty for a great video on scope. It'll be handy to know that Public variables in forms will be accessible only while open. I like using "Public" bc the idea of anything being "global" is basically a scam (see my playlists for details).

[@599CD]

Ah, I see what you did there. :)

[@venkatyalamati3285]

Thanks for the tutorial sir!!!

[@599CD]

My pleasure!

[@artistryartistry7239]

1:47 isn' there module level too?

[@599CD]

Well, there are FORM modules and DATABASE modules (global modules) so that's why I didn't just say "module-level." Who's module is it?

[@artistryartistry7239]

@@599CD Gotcha. It's amazing the number of terms surrounding modules their rules and their variables!

[@glennpitts1312]

This is a great lesson on this topic Richard. I haven't been able to specify a Public Variable in a query (a separate form) as defined (by name).. Do you need to use a function to do that? ]

[@599CD]

599cd.com/QQ

[@jazbaacademyarts]

FRRRR all the layering n buttons i cant keep up

[@599CD]

Layering? Not me.