form control

[Baha]

Hello,

I am very new for access and using 2007 and 2010. I created a forms which related to our staff information.I was trying to write a code for form control.what i wanted was only give a permission to users for the new entry intoform, they should not change any information.my friend told me it was possible in access by simple settings and no need to write a code.but he told me he forgot how to do thatIs that possible?
thank you for your help

 

[Rob Parker]

I think that what your friend was referring to is the form's Data Entry
property. If you set this to 'Yes', the form will only show a new record,
allowing entry of new data into the underlying table (the form's Record
Source). No existing records will be displayed, and they therefore cannot
be edited.

HTH,

Rob


Hello,

I am very new for access and using 2007 and 2010. I created a forms which
related to our staff information.I was trying to write a code for form
control.what i wanted was only give a permission to users for the new entry
into form, they should not change any information.my friend told me it was
possible in access by simple settings and no need to write a code.but he
told me he forgot how to do thatIs that possible?
thank you for your help

 

[Baha]

Hi Rob,
Thank you for the help, that is the one I was looking for.It's too bad I spent all afternoon trying to write a code for that control(with my excel knowledge)
Thank you very much

Baha

 

[Access Developer]

First lesson in Access 101 for many of us: Access is not Excel; not even
"Excel on steroids".

It really, really is worthwhile to invest in a beginning book on Access. It
really is NOT a good idea to assume you can just poke around Access based on
knowledge of some other software and become proficient.