Using Static Variables for Selective Code Execution in Microsoft Access

In this Microsoft Access tutorial, I'm going to teach you how to use a static variable to remember what happened the last time a particular procedure ran. Static variables have some benefits over other types of persistent data types like global variables, hidden form fields, or TempVars.

Oscar from Burien, Washington (a Platinum Member) asks: I just watched your "Select Text on Click" video, and it works great, thank you. However, if I do want to edit some text in the middle of that field, is there a way that I can have it so the code doesn't run the second time you click on that field?

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, static variables, selective code execution, Access VBA, procedure calls, Select Text on Click, global vs static variables, TempVars, Access form customization, debugging in VBA, VBA scope.

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[Shadow.Dragon]

Richard, thanks for the great video! I'll definitely keep static variables in mind for future use.

[efrainedwards]

Hello, I have a question about any options you could recommend for an online job I could apply for. I am 17 years old and exploring my options. I am from the United States but I live in another country. I would really like to be a Database Contractor, but is it possible to do it online in another country?

[ajnabirameez]

Dear Richard

I have comment on your last video. please reply when you get free