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!!!
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.
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.
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.
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).
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? ]
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!!!
Awesome. Glad you find them helpful.
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.
Access is where it's at.
Excellent. I’m truly impressed with your teaching ability and the way you organize things.
Thanks
You have explained scope of variable in great detail and with working codes. That was great help, thx a ton.
You are welcome!
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.
Thank you.
Really useful and beautifully explained. Thank you!
Glad you enjoyed it!
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.com/DSum
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).
Ah, I see what you did there. :)
1:47 isn' there module level too?
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?
@@599CD Gotcha. It's amazing the number of terms surrounding modules their rules and their variables!
Thanks for the tutorial sir!!!
My pleasure!
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.com/QQ
FRRRR all the layering n buttons i cant keep up
Layering? Not me.