How to avoid alteration of data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone
I am not realy used to use MSAccess, but now I'm using it to track working hours for different people in a project group. My question is, how i can deny anyone to make changes to their entrys? I have made a form into which you can easily enter your data, who was working on what and for how long. Once entered, these data are not supposed to change. The form however seems to start at entry no. 1 each time you open it, and it you tend to alter the info in this 1st entry. There must be an easy way of solving this problem, so if you know how, please help m

Thank you al

Jesper
 
Put the form into Design View, Click on the Properties Icon
and set the form's AllowEdits property to No.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Hi everyone!
I am not realy used to use MSAccess, but now I'm using it
Click to expand...
to track working hours for different people in a project
group. My question is, how i can deny anyone to make
changes to their entrys? I have made a form into which you
can easily enter your data, who was working on what and for
how long. Once entered, these data are not supposed to
change. The form however seems to start at entry no. 1 each
time you open it, and it you tend to alter the info in this
1st entry. There must be an easy way of solving this
problem, so if you know how, please help me
 
Jesper,

Open your form in design view, select the whole form (click on the little
square at the cross-section of the two rulers) and right-click to open the
properties window. Select the Data tab and change the Data Entry property
setting from No to Yes. Save.
The result of this is that each time the form is opened it will
automatically go a new record, while it will also not allow the user to go
to a previous record using the record selector or the mouse wheel.

HTH,
Nikos

Jepjo said:
Hi everyone!
I am not realy used to use MSAccess, but now I'm using it to track working
Click to expand...
hours for different people in a project group. My question is, how i can
deny anyone to make changes to their entrys? I have made a form into which
you can easily enter your data, who was working on what and for how long.
Once entered, these data are not supposed to change. The form however seems
to start at entry no. 1 each time you open it, and it you tend to alter the
info in this 1st entry. There must be an easy way of solving this problem,
so if you know how, please help me
 
Back
Top