Recent content by shanecmc

I used the upsize wizard to convert my Access 2003 database to an SQL database. I was going to just create a shortcut to the database.adp file but that will only let one user edit the database at a time. If I copy the adp file down to the users desktop it will work but I have no control over...

I know its asking a lot but could you give me a code example? I'm very new to access and am really only doing this database out of forced necessity.

rainman89 hit it on the head. They are using a form to enter data. The problem is that I need the user to be able to enter a complete record and then later they need to go back to a record and change just two fields. I don't want them to be able to change anything else on a previously created...

Help with locking specific fields on records and creating new ones. I am an Access beginner so forgive the elementary question. I have a small database (used by about 20 people). They need to be able to create new records and are able to now. They also need to be able to modify specific fields...

My problem is that I need the users to be able enter all the data in each field of the form, then after it is entered, lock every field except one. This field (it is a check box field) won't be used for a while but when it is needed I need the users to be able check the box and then not be able...

OK. Thanks so much for your help. I do have one more question. Is there a way to lock every field on a form except one. Maybe by setting allow edits to "No" then placing some code on the one field that edits would be allowed?

Will this allow me to lock specific fields all the time and only allow updates in other specific fields? Also, I'm not sure where the "On Current event" is located in the form. Sorry for the elementary question I just need a little clarification.

Rainman89. Do you know if there is a way to do this per field? I would still like some fields to be edited.

I have a simple database the is only used by 16 people. However, one of them keeps changing correct fields on me. I need to let the users create a new record and enter the data, and as soon as the data is entered in the field I would like to lock the field. I am a complete beginner when it comes...