I have a form on a split database with multiple users (taking phone messages). I already have the form set up so the user can only enter new data in it so that there is no mishaps of messages being typed over. However, I want other users (returning calls) to be able to go view the information on the table. I want the users returning calls to only be able to edit certain fields in the table. Is there any way I can lock only the fields that I dont want them to be able to edit?
Also, another question...
My ID is my primary key which orders numerically with each record (1,2,3...ect.) I deleted the first couple test records but the ID continues to numer from where the last deleted record left off (4,5,6..ect.). How can I get it to start back at one?
Is there any way I can lock only the fields that I dont want them to be able to edit?
1. When the form is in Design view, open the Properties window.
2. Select the control you want to make read-only.
3. Select the "Data" tab in the properties window.
4. Change the value of the Locked property to Yes.
Originally Posted by jkisner
How can I get it to start back at one?
Normally, you should never do that. Values generated in an Autonumber column should be reserved for the internal mechanism of a database and never be accessible to the user for whom they are meaningless.
Here's a solution, however never use it in a database in production.
1. Delete all rows from the table you want to reset.
2. Create a new query and switch to SQL view.
4. Type this in the query (replace "TableName" by the name of your table and "TableColumn" by the name of the Identity column):
ALTER TABLE TableName ALTER COLUMN ColumnName COUNTER(1,1);