My forms will not allow additions and my tables get a + column 
Author Message
 My forms will not allow additions and my tables get a + column

My database has 4 tables.  Employee, position, postofund (a double key table
for many to many relationship) and a funding table.  I am trying to create a
form to update the tables, however the form will not allow updates.  The
forms and queries do permit updates, deletions and additions.  But the Table
keys are not editable.  I cannot find out why.  Also, I find tables switch to
a pivot type with no reason.  I have had to delete and replace them with
backups to get the plus sign out of the field.  Please direct me to someone
who can give me some help with this problem.  


Sun, 09 Dec 2007 07:33:03 GMT  
 My forms will not allow additions and my tables get a + column
On Tue, 21 Jun 2005 16:33:03 -0700, "PatT123"

Quote:

>My database has 4 tables.  Employee, position, postofund (a double key table
>for many to many relationship) and a funding table.  I am trying to create a
>form to update the tables, however the form will not allow updates.  The
>forms and queries do permit updates, deletions and additions.  But the Table
>keys are not editable.  I cannot find out why.  Also, I find tables switch to
>a pivot type with no reason.  I have had to delete and replace them with
>backups to get the plus sign out of the field.  Please direct me to someone
>who can give me some help with this problem.  

What are your Form's Recordsource properties? Are you trying to create
a big Query of all three tables? If so don't; you should be using a
Form based on one "one" side, with a subform based on the junction
table. If you have done so, please post the Recordsource of the form
and the subform, and the master/child link fields.

The plus sign IS NOT A PIVOT TABLE. It's a subdatasheet (a new feature
in A2000). View the table's Properties and set the Subdatasheet to
None (by default it's Auto) to get rid of this performance-dragging
feature.

                  John W. Vinson[MVP]    



Sun, 09 Dec 2007 11:37:46 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Linked SQL tables not allowing additions in Access forms

2. sub Form does not allow additions

3. sub Form does not allow additions

4. Getting data from a table by VBA but not allowing to view it directly

5. Do not allow addition

6. not Allowing Additions on subforms

7. Subform Not allowing addition of record

8. how do you allow additions in a sub form

9. Form won't allow edits or additions

10. 1-M Form won't allow additions!


 
Powered by phpBB® Forum Software © phpBB Group