Using Static Variables for Code Control in MS 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?

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Select Text On Click
• Intro VBA

Links

• Variables
• Scope

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, 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.