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
|
|||
|
|||
Additions Denied
It is Friday, so I should probably just go home, but after getting my form
pretty well completed, I thought I would test adding a new record. Unfortunately, my form is denying me this ability. If I open the linked table directly, I can add a new record, but not from the form. Here are the data properties for the form: Record Source: simple select query Recordset Type: Dynaset Fetch Defaults: Yes Filter: blank Filter On Load: No Order By: blank Order By On Load: Yes Data Entry: No Allow Additions: Yes Allow Deletions: No Allow Edits: Yes Allow Filters: Yes Record Locks: No Locks Even if I change the Allow Edits property to Yes, the form still denies me the ability to add new records. Any insight is greatly appreciated. TIA, Chris |
#2
|
|||
|
|||
Additions Denied
Is your form bound to a table or query
"Christopher Robin" wrote: It is Friday, so I should probably just go home, but after getting my form pretty well completed, I thought I would test adding a new record. Unfortunately, my form is denying me this ability. If I open the linked table directly, I can add a new record, but not from the form. Here are the data properties for the form: Record Source: simple select query Recordset Type: Dynaset Fetch Defaults: Yes Filter: blank Filter On Load: No Order By: blank Order By On Load: Yes Data Entry: No Allow Additions: Yes Allow Deletions: No Allow Edits: Yes Allow Filters: Yes Record Locks: No Locks Even if I change the Allow Edits property to Yes, the form still denies me the ability to add new records. Any insight is greatly appreciated. TIA, Chris |
#3
|
|||
|
|||
Additions Denied
if its bound to a query, open the query up and view it in datasheet view.
See if it lets you add a record there. There is a chance you have some expressions or relationships that are denying the additions "Christopher Robin" wrote: It is Friday, so I should probably just go home, but after getting my form pretty well completed, I thought I would test adding a new record. Unfortunately, my form is denying me this ability. If I open the linked table directly, I can add a new record, but not from the form. Here are the data properties for the form: Record Source: simple select query Recordset Type: Dynaset Fetch Defaults: Yes Filter: blank Filter On Load: No Order By: blank Order By On Load: Yes Data Entry: No Allow Additions: Yes Allow Deletions: No Allow Edits: Yes Allow Filters: Yes Record Locks: No Locks Even if I change the Allow Edits property to Yes, the form still denies me the ability to add new records. Any insight is greatly appreciated. TIA, Chris |
#4
|
|||
|
|||
Additions Denied
It's bound to a table, but there is a query in the data source. I'll check
that out, and see if I can a new record. "Kay" wrote: if its bound to a query, open the query up and view it in datasheet view. See if it lets you add a record there. There is a chance you have some expressions or relationships that are denying the additions "Christopher Robin" wrote: It is Friday, so I should probably just go home, but after getting my form pretty well completed, I thought I would test adding a new record. Unfortunately, my form is denying me this ability. If I open the linked table directly, I can add a new record, but not from the form. Here are the data properties for the form: Record Source: simple select query Recordset Type: Dynaset Fetch Defaults: Yes Filter: blank Filter On Load: No Order By: blank Order By On Load: Yes Data Entry: No Allow Additions: Yes Allow Deletions: No Allow Edits: Yes Allow Filters: Yes Record Locks: No Locks Even if I change the Allow Edits property to Yes, the form still denies me the ability to add new records. Any insight is greatly appreciated. TIA, Chris |
#5
|
|||
|
|||
Additions Denied
I discovered my problem. One column was missing from the Query that Access
generated for the form. After adding this column to the query, I'm now able to add new records. I must have made changes to the underlying table after I started working on the form. "Kay" wrote: if its bound to a query, open the query up and view it in datasheet view. See if it lets you add a record there. There is a chance you have some expressions or relationships that are denying the additions "Christopher Robin" wrote: It is Friday, so I should probably just go home, but after getting my form pretty well completed, I thought I would test adding a new record. Unfortunately, my form is denying me this ability. If I open the linked table directly, I can add a new record, but not from the form. Here are the data properties for the form: Record Source: simple select query Recordset Type: Dynaset Fetch Defaults: Yes Filter: blank Filter On Load: No Order By: blank Order By On Load: Yes Data Entry: No Allow Additions: Yes Allow Deletions: No Allow Edits: Yes Allow Filters: Yes Record Locks: No Locks Even if I change the Allow Edits property to Yes, the form still denies me the ability to add new records. Any insight is greatly appreciated. TIA, Chris |
Thread Tools | |
Display Modes | |
|
|