03 – Global Class Modules

One of the best things about working with MS Access is the ability to use global variables, functions and procedures. This means that we are able to call globally declared code from anywhere within the application and is very useful for being able to keep code centralised yet accessible. Oh, and by the way, we can do the same with class modules...

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.

In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!


  • David says:

    Hi Long,

    Take a look at video ’05/28 – Variable Scope – MS Access VBA Intermediate Tutorials’ for a good explanation of declaring Private and Public variables

  • LONG NGUYEN says:


    I’m new to access and just joined you as an annual-level member. this video doesn’t include the important features that teach me how to open the editor, link this codes to a form, and run and step through the codes.
    I want to be able to create a variable that I can refer to from many form in the application until I renew its value or logout. Can you show me?