Re: Protect Fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Something like this ought to work:

Set the Allow Edits, Allow Deletions, and Allow Additions properties to No
in the form's property ***, and make sure they stay that way between
records:

Private Sub Form_Current()
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = False
End Sub

Then program your command button:

Private Sub cmdEdit_Click()
Me.AllowEdits = True
Me.AllowDeletions = True
Me.AllowAdditions = True
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Jenna" <Jenna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:400A39C9-3ECE-40EF-97E2-FEBB4F044ED5@xxxxxxxxxxxxxxxx
I have had a general course over Access, but nothing too in depth. I runny
the 2007 Beta version of Access. I created my form, but I want to protect
it
so that if someone is looking at the form and they accidentally bump a key
and not know it, it cannot change the data in the box. However, to change
the data, and edit button must be selected and the form can be changed.
Is
this possible?

I made my database very similar to the template "Assets" where you are
viewing a table, you click on new and then a window pops up that you fill
out. When you are finished, you close the box and then you see the data
you
just entered on the table.

Any help would be appreciated. Users will be able to access this at
different computers, and would prefer them not to be able to change them.

Thank you,
Jenna


.

Quantcast