If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot edit data in forms but can in tables
I have a problem!
I created a database where I can only edit the data in tables. In the forms I created I can see the data but cannot edit the data. I am using 2007 that I have set so the file can be opened in 2003. The data was imported to create tables from two Excel spread sheets using the wizard. The tables are linked together and the combined data is shown in a report. This all works without a problem. Now I need to edit the data, so I created several forms all of which I cannot add, delete or edit the data. I saw under the User and Group Permissions that under table all the permissions have checks but under form read, update insert and delete are all greyed out and I am unable to change this. Does anyone know how I can make the necessary changes to edit the data in forms? |
#2
|
|||
|
|||
Cannot edit data in forms but can in tables
It may be a problem with your query
You must have a query that joins the tables together. That query is the source for the report Open the query and see if you can edit the data there. Tell us if you can edit the query "Ratfink" wrote in message ... I have a problem! I created a database where I can only edit the data in tables. In the forms I created I can see the data but cannot edit the data. I am using 2007 that I have set so the file can be opened in 2003. The data was imported to create tables from two Excel spread sheets using the wizard. The tables are linked together and the combined data is shown in a report. This all works without a problem. Now I need to edit the data, so I created several forms all of which I cannot add, delete or edit the data. I saw under the User and Group Permissions that under table all the permissions have checks but under form read, update insert and delete are all greyed out and I am unable to change this. Does anyone know how I can make the necessary changes to edit the data in forms? |
#3
|
|||
|
|||
Cannot edit data in forms but can in tables
On Thu, 28 Jan 2010 11:50:06 -0800, Ratfink
wrote: I have a problem! I created a database where I can only edit the data in tables. In the forms I created I can see the data but cannot edit the data. I am using 2007 that I have set so the file can be opened in 2003. The data was imported to create tables from two Excel spread sheets using the wizard. The tables are linked together and the combined data is shown in a report. This all works without a problem. Now I need to edit the data, so I created several forms all of which I cannot add, delete or edit the data. I saw under the User and Group Permissions that under table all the permissions have checks but under form read, update insert and delete are all greyed out and I am unable to change this. Does anyone know how I can make the necessary changes to edit the data in forms? Are you basing the Forms on Queries joining the tables? If so, that may be the problem: some multitable queries are updateable but some aren't. Normally one would use a Form for the "one" side of the relationship and a Subform for the "many". Did you define Relationships between the tables after you imported them? Did you enforce referential integrity? If you open the query datasheet, is *it* editable? If not, the form won't be either. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|