Lock, Unlock Controls

A problem that crops up from time to time is the need to handle a group of controls differently from the rest of the controls on a form.
Usually this is the need to lock the controls so that data cannot be changed, and conversely unlock them. However it may be the need to change the back colour or some other attribute of the controls.
Video 1 (3:24) — Demonstration of a simple function that Locks or Unlocks controls on an MS Access Form, depending on whether you pass it a true or false boolean value.
Video 2 (1:39) — Demonstrates the method of naming the controls with a particular set of characters to identify them as belonging to a particular group.
Video 3 (4:52) — Demonstrates how to set particular controls values, (a group of similar controls) by looping through the collection of controls on an MS Access Form.
Video 4 (1:47) — Demonstrates how to replace two command buttons which switch between a lock and unlock state as in this case, and replace the two command buttons with a single command button and some code.
Video 5 (3:59) — Demonstrates how to setup command buttons to call a class module, the class module can then execute identical code for every button that calls it from your form.
Video 6 (3:29) — Demonstrates how to have your Command Buttons access the code in a Class Module through a function in the code behind the form.
Video 7 (3:55) — Overview of a Class that is used with
an MS Access Form. This Class enables multiple
command buttons to perform basically the same
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn