How to Use Global Variables in Microsoft Access VBA

In this episode, we're going to take a look at how to use a global variable in Microsoft Access so that we can populate a variable in our program and have it available for consumption by our forms, reports, macros, and other code in our project. Global variables are quite handy when you need to store different things in memory as your program runs, whether it is a string, array, object, or other things.

Related Videos:
How to Use Left, Right, Mid, Instr, and Trim on Strings in MS Access and VBA
How to Use DateAdd, DateDiff, and DatePart to Calculate Dates in MS Access
How to Handle Line Breaks in Microsoft Access
How to Open a RecordSet in Access VBA and Loop Through the Records
How to Use BOF and EOF on Recordsets in MS Access
How to use With.. End With in MS Access VBA
How to Use Global Variables in Microsoft Access VBA
You are watching this video now!
How to Use For Next Loops in MS Access VBA
How to Use a Do While Loop in MS Access VBA

For developers looking for a new role, check out and sign up:

Needing to hire technical resources for your project? Get the best:

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#msaccess #vba #dataengineering

[abdoulayetoure]

Thank a lot for this vidéo it help me a lot

[hikmatmarashdeh]

thanks a lot for your explanation and demo, it helped me a lot.

[interestingamerican]

Commenting for the algorithm. Love the content!

[RHSdbs]

Very well explained, i already know this stuff, i also use the TempVars collection in MS-Access, if a global value/variable is needed.

[gerfer]

Thanks 😊
? = is there a connector you know about in Power Automate use between Access and Excel please?

[stanTrX]

Thanks Sean. How can i call a module anywhere in the forms? Is there a way to call it using a shortcut (just like we can do in excel )

[satyabanukil]

Sir, I have a calculative field. I want to create two variables a and b. I want to add both the variables to that calculating field. For example a is 5 and b is 2 and my result shall appear as (a + b) = 7. If it is possible, kindly make a tutorial on it. Regards

[artistryartistry]

You know your stuff, but you're not a good teacher. I'm not trying to be mean, I'm just giving honest feedback. There has to be real thinking and effort to make something clear and easy to understand, to put yourself in the mind of a person who may have no previous understanding of what you're doing. You have not applied that level of sophistication and polish to this work. As Steve Jobs said: "Simple can be harder than complex: You have to work hard to get your thinking clean to make it simple." You haven't done that here.