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
|
|||
|
|||
Edit Data in Forms
I am unable to edit my data or create a new entry in my form. I can only
sort the data that I have already imported into tables. I am only able to edit the data in the tables. I have set all the "Allow" options in the form selector to Yes but am still unable to make any changes. Please help! Thank you, AccessIlliterate |
#2
|
|||
|
|||
Edit Data in Forms
What is the recordsource of the form? If it is a multi-table query, these are
often not updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: I am unable to edit my data or create a new entry in my form. I can only sort the data that I have already imported into tables. I am only able to edit the data in the tables. I have set all the "Allow" options in the form selector to Yes but am still unable to make any changes. Please help! Thank you, AccessIlliterate |
#3
|
|||
|
|||
Edit Data in Forms
Here's Allen Browne's excellent explanation of why some queries are Read-Only:
http://allenbrowne.com/ser-61.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Edit Data in Forms
The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries. Thanks for your help! AccessIlliterate "Beetle" wrote: What is the recordsource of the form? If it is a multi-table query, these are often not updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: I am unable to edit my data or create a new entry in my form. I can only sort the data that I have already imported into tables. I am only able to edit the data in the tables. I have set all the "Allow" options in the form selector to Yes but am still unable to make any changes. Please help! Thank you, AccessIlliterate |
#5
|
|||
|
|||
Edit Data in Forms
The sourse of the form is made up of 3 table. The three tables all have a
related field and thus are connected. It does not involve any queries. I'm not exactly sure what you mean here. Either; 1) You have a form with two subforms, each with it's own recordsource table. Or 2) You have one form that gets data from three tables. If it's No. 2, then the only way that would be possible is if the recordsource of the form is a query that combines the three tables, in which case it will not be updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: The sourse of the form is made up of 3 table. The three tables all have a related field and thus are connected. It does not involve any queries. Thanks for your help! AccessIlliterate "Beetle" wrote: What is the recordsource of the form? If it is a multi-table query, these are often not updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: I am unable to edit my data or create a new entry in my form. I can only sort the data that I have already imported into tables. I am only able to edit the data in the tables. I have set all the "Allow" options in the form selector to Yes but am still unable to make any changes. Please help! Thank you, AccessIlliterate |
#6
|
|||
|
|||
Edit Data in Forms
Sorry, but if the Record Source for the form consists of 3 tables, a query
has to be involved! That's the only way this can be done! In Design View for the form, goto Properties - Data and what does it say in the Record Source Property box? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#7
|
|||
|
|||
Edit Data in Forms
Beetle, thank you for your help.
I have 1 form that gets data from 3 tables, but none of that information comes from a query. When I created the form using the design wizard, I chose all the fields from the 3 tables I want the information from. On 2 of the 3 table I do not choose the field that links all 3 tables together (Client Code). At no point do I see the words "Read-Only" on the form, tables or fields. AccessIlliterate "Beetle" wrote: The sourse of the form is made up of 3 table. The three tables all have a related field and thus are connected. It does not involve any queries. I'm not exactly sure what you mean here. Either; 1) You have a form with two subforms, each with it's own recordsource table. Or 2) You have one form that gets data from three tables. If it's No. 2, then the only way that would be possible is if the recordsource of the form is a query that combines the three tables, in which case it will not be updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: The sourse of the form is made up of 3 table. The three tables all have a related field and thus are connected. It does not involve any queries. Thanks for your help! AccessIlliterate "Beetle" wrote: What is the recordsource of the form? If it is a multi-table query, these are often not updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: I am unable to edit my data or create a new entry in my form. I can only sort the data that I have already imported into tables. I am only able to edit the data in the tables. I have set all the "Allow" options in the form selector to Yes but am still unable to make any changes. Please help! Thank you, AccessIlliterate |
#8
|
|||
|
|||
Edit Data in Forms
Thanks to you too LA;
The properties box contains a long list of the fields that I am using to create the Form. Here it is exactly: SELECT Clients.Code, Clients.Client, Clients.[Dom Code], Clients.reimbcode AS Clients_reimbcode, [Client Plus].Parent, [Details on Management Agreements].Agreement, [Reimbursement Codes].reimbcode AS [Reimbursement Codes_reimbcode], [Reimbursement Codes].comments AS [Reimbursement Codes_comments], [Details on Management Agreements].Status, [Details on Management Agreements].ODate, [Details on Management "Linq Adams via AccessMonster.com" wrote: Sorry, but if the Record Source for the form consists of 3 tables, a query has to be involved! That's the only way this can be done! In Design View for the form, goto Properties - Data and what does it say in the Record Source Property box? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#9
|
|||
|
|||
Edit Data in Forms
Then Access created the query for you, but it's still a query. You are going
to have to redesign this using a form and sub forms. -- _________ Sean Bailey "AccessIlliterate" wrote: Beetle, thank you for your help. I have 1 form that gets data from 3 tables, but none of that information comes from a query. When I created the form using the design wizard, I chose all the fields from the 3 tables I want the information from. On 2 of the 3 table I do not choose the field that links all 3 tables together (Client Code). At no point do I see the words "Read-Only" on the form, tables or fields. AccessIlliterate "Beetle" wrote: The sourse of the form is made up of 3 table. The three tables all have a related field and thus are connected. It does not involve any queries. I'm not exactly sure what you mean here. Either; 1) You have a form with two subforms, each with it's own recordsource table. Or 2) You have one form that gets data from three tables. If it's No. 2, then the only way that would be possible is if the recordsource of the form is a query that combines the three tables, in which case it will not be updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: The sourse of the form is made up of 3 table. The three tables all have a related field and thus are connected. It does not involve any queries. Thanks for your help! AccessIlliterate "Beetle" wrote: What is the recordsource of the form? If it is a multi-table query, these are often not updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: I am unable to edit my data or create a new entry in my form. I can only sort the data that I have already imported into tables. I am only able to edit the data in the tables. I have set all the "Allow" options in the form selector to Yes but am still unable to make any changes. Please help! Thank you, AccessIlliterate |
#10
|
|||
|
|||
Edit Data in Forms
Beetle--thanks for the help. I am taking a Access online class and sub-forms
on part of level three and I am stil on two. Hope the tutorial will help me create this form properly--Thanks again. AccessIlliterate "Beetle" wrote: Then Access created the query for you, but it's still a query. You are going to have to redesign this using a form and sub forms. -- _________ Sean Bailey "AccessIlliterate" wrote: Beetle, thank you for your help. I have 1 form that gets data from 3 tables, but none of that information comes from a query. When I created the form using the design wizard, I chose all the fields from the 3 tables I want the information from. On 2 of the 3 table I do not choose the field that links all 3 tables together (Client Code). At no point do I see the words "Read-Only" on the form, tables or fields. AccessIlliterate "Beetle" wrote: The sourse of the form is made up of 3 table. The three tables all have a related field and thus are connected. It does not involve any queries. I'm not exactly sure what you mean here. Either; 1) You have a form with two subforms, each with it's own recordsource table. Or 2) You have one form that gets data from three tables. If it's No. 2, then the only way that would be possible is if the recordsource of the form is a query that combines the three tables, in which case it will not be updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: The sourse of the form is made up of 3 table. The three tables all have a related field and thus are connected. It does not involve any queries. Thanks for your help! AccessIlliterate "Beetle" wrote: What is the recordsource of the form? If it is a multi-table query, these are often not updateable. -- _________ Sean Bailey "AccessIlliterate" wrote: I am unable to edit my data or create a new entry in my form. I can only sort the data that I have already imported into tables. I am only able to edit the data in the tables. I have set all the "Allow" options in the form selector to Yes but am still unable to make any changes. Please help! Thank you, AccessIlliterate |
Thread Tools | |
Display Modes | |
|
|