|
| 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
November 26th, 2009, 05:52 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Cannot enable editing of some fields
I am working with a application that I did not create (Access 2007)
I cannot seem to be able to allow editing of some fields on a subform. I changed the properties to Enabled (yes) and Locked (No); but I am still unable to edit the desired fields? 
|
|
#2
November 26th, 2009, 02:24 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
What are the values in the ControlSource property for those fields? If they
begin with an = character, they are calculated expressions that cannot be edited. If they are field names and those fields are autonumber fields or calculated fields in a query, they cannot be edited. -- Ken Snell http://www.accessmvp.com/KDSnell/ "BobC" wrote in message ... I am working with a application that I did not create (Access 2007) I cannot seem to be able to allow editing of some fields on a subform. I changed the properties to Enabled (yes) and Locked (No); but I am still unable to edit the desired fields?
|
|
#3
November 26th, 2009, 03:38 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
Based on your comments, I created a test form using the original query
as a source. I was 'UNABLE'to edit the fields! The fields are not outonumber nor calculated. Any other suggestions? Bob Ken Snell wrote: What are the values in the ControlSource property for those fields? If they begin with an = character, they are calculated expressions that cannot be edited. If they are field names and those fields are autonumber fields or calculated fields in a query, they cannot be edited.
|
|
#4
November 26th, 2009, 03:55 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
BobC wrote:
Based on your comments, I created a test form using the original query as a source. I was 'UNABLE'to edit the fields! The fields are not outonumber nor calculated. Any other suggestions? Bob Many queries are produce non-editable recordsets. Sounds like yours falls into that category. Does it use DISTINCT? Does it have "View - Totals" enabled? Does it use multiple input tables with joins? The first two are hard rules that will produce read-only output 100% of the time. The last is a "it depends" rule. How many tables, what kind of joins, etc..
|
|
#5
November 26th, 2009, 04:12 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
The data for the query is from 'one' table of 4 joined tables. The
tables are joined in a 1 to many. The query is a 'select' query. I see nothing related to totals. Rick Brandt wrote: BobC wrote: Based on your comments, I created a test form using the original query as a source. I was 'UNABLE'to edit the fields! The fields are not outonumber nor calculated. Any other suggestions? Bob Many queries are produce non-editable recordsets. Sounds like yours falls into that category. Does it use DISTINCT? Does it have "View - Totals" enabled? Does it use multiple input tables with joins? The first two are hard rules that will produce read-only output 100% of the time. The last is a "it depends" rule. How many tables, what kind of joins, etc..
|
|
#6
November 26th, 2009, 04:13 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
Hi -
Go and take a look at the source query itself. If some of the fields in that query are expressions, then they can't be edited either. John BobC wrote: Based on your comments, I created a test form using the original query as a source. I was 'UNABLE'to edit the fields! The fields are not outonumber nor calculated. Any other suggestions? Bob What are the values in the ControlSource property for those fields? If they begin with an = character, they are calculated expressions that cannot be edited. If they are field names and those fields are autonumber fields or calculated fields in a query, they cannot be edited. -- John Goddard Ottawa, ON Canada jrgoddard at cyberus dot ca Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1
|
|
#7
November 26th, 2009, 04:21 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
None of the fields are expressions ... the are directly from the table.
Thanks J_Goddard via AccessMonster.com wrote: Hi - Go and take a look at the source query itself. If some of the fields in that query are expressions, then they can't be edited either. John BobC wrote: Based on your comments, I created a test form using the original query as a source. I was 'UNABLE'to edit the fields! The fields are not outonumber nor calculated. Any other suggestions? Bob What are the values in the ControlSource property for those fields? If they begin with an = character, they are calculated expressions that cannot be edited. If they are field names and those fields are autonumber fields or calculated fields in a query, they cannot be edited.
|
|
#8
November 26th, 2009, 04:36 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
What happens if you run the query directly from the database window - can you
edit the fields from there? Can you edit ANY of the fields? John BobC wrote: None of the fields are expressions ... the are directly from the table. Thanks Hi - [quoted text clipped - 13 lines] edited. If they are field names and those fields are autonumber fields or calculated fields in a query, they cannot be edited. -- John Goddard Ottawa, ON Canada jrgoddard at cyberus dot ca Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1
|
|
#9
November 26th, 2009, 04:50 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
I never thought about doing that!? ...
I cannot edit any of the fields. J_Goddard via AccessMonster.com wrote: What happens if you run the query directly from the database window - can you edit the fields from there? Can you edit ANY of the fields? John BobC wrote: None of the fields are expressions ... the are directly from the table. Thanks Hi - [quoted text clipped - 13 lines] edited. If they are field names and those fields are autonumber fields or calculated fields in a query, they cannot be edited.
|
|
#10
November 26th, 2009, 05:44 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Cannot enable editing of some fields
BobC wrote:
The data for the query is from 'one' table of 4 joined tables. The tables are joined in a 1 to many. The query is a 'select' query. I see nothing related to totals. It does not matter how the tables are related in the relationship window. Do you have more than one table in the query? If so the odds of the result- set being editable decrease as you add more tables. A query with four tables will almost certainly not produce editable output.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
