GregoryWest
Registered User.
- Local time
- Yesterday, 22:08
- Joined
- Apr 13, 2014
- Messages
- 161
Here is a fun one, that comes out of an end user request:
What the user would like is a check box, or something, that will allow them to turn on the ability to edit a form. The normal state of this box would be false (ie Read Only). The reason for this is pretty simple, they are in the program looking up data a lot, with no need to edit. Now with editing on, there have been a number of times when something was accidentally changed. This causes extra work and time to find and correct. Now at the same time they are looking up data, and notice an error. Instead of stopping what they are doing going to another screen and fixing the error, they would like to be able to turn on editing, fix the error and carry on as if nothing happened.
What I thought of doing is putting the field 'form.allow-editing' (or what ever it might be called) up in the header of the form. That way the user can just click on the box and presto editing is now on.
Can something like this be done?
What would be the name of the control field.
I do have other ways of doing this, but would require a global variable to be made available. If there such a thing in Access? How do I create it and assign it values?
What the user would like is a check box, or something, that will allow them to turn on the ability to edit a form. The normal state of this box would be false (ie Read Only). The reason for this is pretty simple, they are in the program looking up data a lot, with no need to edit. Now with editing on, there have been a number of times when something was accidentally changed. This causes extra work and time to find and correct. Now at the same time they are looking up data, and notice an error. Instead of stopping what they are doing going to another screen and fixing the error, they would like to be able to turn on editing, fix the error and carry on as if nothing happened.
What I thought of doing is putting the field 'form.allow-editing' (or what ever it might be called) up in the header of the form. That way the user can just click on the box and presto editing is now on.
Can something like this be done?
What would be the name of the control field.
I do have other ways of doing this, but would require a global variable to be made available. If there such a thing in Access? How do I create it and assign it values?