Protect data once entered into field

[SBecker]

I have a database with loan numbers and issues/incidents associated with the
loans. Is there a way to lock the information, once it's been entered? I've
already had a couple of loan numbers deleted by other users in my department.
I'd like to maybe create a pop up that questions whether the user really
wants to do what they are trying, which would be any time someone tries to
edit information already entered in the field. Suggestions?

 

[Mark Andrews]

You could design your form so by default NO edits are allowed and it forces
the user to click a button to "UNLOCK" the form so edits can be performed.
The button would change the AllowEdits property to true.

I would probably also change the background colors of the controls to
indicate whether you are in View Only or Editing Mode.

Just a suggestion,
Mark
RPT Software
http://www.rptsoftware.com

 

[SBecker]

Mark,

That sounds like a great idea...but I don't know how to do it! Would
setting the "allow edits" in the properties to "no" do that? How do you do
the second part of your suggestion? Forcing the user to click a button to
"unlock"....this would be perfect because it allows edits (which will
happen), but will make them aware before they start typing away over
pre-existing data....

Thanks,
Suzanne

 

[Mark Andrews]

Suzanne,

You could start the form off with AllowEdits = No. and the controls have a
backcolor
of some form of grey

You add a button for the user to "Unlock the form" and add an event for the
Click and add a little code:

Me.AllowEdits = True
Me.txtControl1.BackColor = -2147483643
Me.txtControl2.BackColor = -2147483643
etc...

That way when the user clciks the button they see the form change to
indicate that now they can enter data,

Hope that gets you started,
Mark
RPT Software
http://www.rptsoftware.com

PS: I don't check these newsgroups all the time, you can always contact me
via my website if you run into any issues, or just start another newsgroup
topic and I'm sure someone else will jump in.