How to avoid alteration of data?

J

Jepjo

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
 
G

Gerald Stanley

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
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
 
N

Nikos Yannacopoulos

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
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top