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
|
|||
|
|||
Query is Updatable - but the form based on it - is not - Why??
Hi,
I have a query - There everything is ok The data can be changed But when I create a form base on the query (Using Wizard - just select the table) the data caould not be changed via the form, Why?? Here is the query: SELECT Q_EMP_WORK_PCT_PREV_AND_CURRENT.SignOut, Q_EMP_WORK_PCT_PREV_AND_CURRENT.EmpNumber, Q_EMP_WORK_PCT_PREV_AND_CURRENT.[Emp Name], Q_EMP_WORK_PCT_PREV_AND_CURRENT.Year, Q_EMP_WORK_PCT_PREV_AND_CURRENT.Month, Q_EMP_WORK_PCT_PREV_AND_CURRENT.CurrentMonthPct, Q_EMP_WORK_PCT_PREV_AND_CURRENT.PrevMonthPct FROM Q_EMP_WORK_PCT_PREV_AND_CURRENT; In order to have the ability to change data in the query window - I changed the recordset type to: Dynaset (Inconsistent Updates), so now the query is ok. But the form based o the fom - The data could not be changed (I would like to give the user the option to change th SignOut value Many Thanks, Dola |
#2
|
|||
|
|||
Query is Updatable - but the form based on it - is not - Why??
wrote in message
... Hi, I have a query - There everything is ok The data can be changed But when I create a form base on the query (Using Wizard - just select the table) the data caould not be changed via the form, Why?? Here is the query: SELECT Q_EMP_WORK_PCT_PREV_AND_CURRENT.SignOut, Q_EMP_WORK_PCT_PREV_AND_CURRENT.EmpNumber, Q_EMP_WORK_PCT_PREV_AND_CURRENT.[Emp Name], Q_EMP_WORK_PCT_PREV_AND_CURRENT.Year, Q_EMP_WORK_PCT_PREV_AND_CURRENT.Month, Q_EMP_WORK_PCT_PREV_AND_CURRENT.CurrentMonthPct, Q_EMP_WORK_PCT_PREV_AND_CURRENT.PrevMonthPct FROM Q_EMP_WORK_PCT_PREV_AND_CURRENT; In order to have the ability to change data in the query window - I changed the recordset type to: Dynaset (Inconsistent Updates), so now the query is ok. But the form based o the fom - The data could not be changed (I would like to give the user the option to change th SignOut value Many Thanks, Dola Did you set the *form's* RecordsetType property to "Dynaset (Inconsistent Updates)"? -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#3
|
|||
|
|||
Query is Updatable - but the form based on it - is not - Why??
Did you set the *form's* RecordsetType property to "Dynaset (Inconsistent
Updates)"? I Tried it but... When I did so - I only was able to enter new data - In datasheet view the existing rows are not display at all!! What is wrong?? Many thanks! On Apr 28, 5:29*pm, "Dirk Goldgar" wrote: wrote in message ... Hi, I have a query - There everything is ok The data can be changed But when I create a form base on the query (Using Wizard - just select the table) the data caould not be changed via the form, Why?? Here is the query: SELECT Q_EMP_WORK_PCT_PREV_AND_CURRENT.SignOut, Q_EMP_WORK_PCT_PREV_AND_CURRENT.EmpNumber, Q_EMP_WORK_PCT_PREV_AND_CURRENT.[Emp Name], Q_EMP_WORK_PCT_PREV_AND_CURRENT.Year, Q_EMP_WORK_PCT_PREV_AND_CURRENT.Month, Q_EMP_WORK_PCT_PREV_AND_CURRENT.CurrentMonthPct, Q_EMP_WORK_PCT_PREV_AND_CURRENT.PrevMonthPct FROM Q_EMP_WORK_PCT_PREV_AND_CURRENT; In order to have the ability to change data in the query window - I changed the recordset type to: Dynaset (Inconsistent Updates), so now the query is ok. But the form based o the fom - The data could not be changed (I would like to give the user the option to change th SignOut value Many Thanks, Dola Did you set the *form's* RecordsetType property to "Dynaset (Inconsistent Updates)"? -- Dirk Goldgar, MS Access MVPwww.datagnostics.com (please reply to the newsgroup)- Hide quoted text - - Show quoted text - |
#4
|
|||
|
|||
Query is Updatable - but the form based on it - is not - Why??
Is your form's Data Entry property set to Yes? It should be No.
-- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) wrote in message ... Did you set the *form's* RecordsetType property to "Dynaset (Inconsistent Updates)"? I Tried it but... When I did so - I only was able to enter new data - In datasheet view the existing rows are not display at all!! What is wrong?? Many thanks! On Apr 28, 5:29 pm, "Dirk Goldgar" wrote: wrote in message ... Hi, I have a query - There everything is ok The data can be changed But when I create a form base on the query (Using Wizard - just select the table) the data caould not be changed via the form, Why?? Here is the query: SELECT Q_EMP_WORK_PCT_PREV_AND_CURRENT.SignOut, Q_EMP_WORK_PCT_PREV_AND_CURRENT.EmpNumber, Q_EMP_WORK_PCT_PREV_AND_CURRENT.[Emp Name], Q_EMP_WORK_PCT_PREV_AND_CURRENT.Year, Q_EMP_WORK_PCT_PREV_AND_CURRENT.Month, Q_EMP_WORK_PCT_PREV_AND_CURRENT.CurrentMonthPct, Q_EMP_WORK_PCT_PREV_AND_CURRENT.PrevMonthPct FROM Q_EMP_WORK_PCT_PREV_AND_CURRENT; In order to have the ability to change data in the query window - I changed the recordset type to: Dynaset (Inconsistent Updates), so now the query is ok. But the form based o the fom - The data could not be changed (I would like to give the user the option to change th SignOut value Many Thanks, Dola Did you set the *form's* RecordsetType property to "Dynaset (Inconsistent Updates)"? -- Dirk Goldgar, MS Access MVPwww.datagnostics.com (please reply to the newsgroup)- Hide quoted text - - Show quoted text - |
#5
|
|||
|
|||
Query is Updatable - but the form based on it - is not - Why??
On Apr 29, 5:07*pm, "Dirk Goldgar"
wrote: Is your form's Data Entry property set to Yes? *It should be No. -- Dirk Goldgar, MS Access MVPwww.datagnostics.com (please reply to the newsgroup) wrote in message ... Did you set the *form's* RecordsetType property to "Dynaset (Inconsistent Updates)"? I Tried it but... When I did so - I only was able to enter new data - In datasheet view the existing rows are not display at all!! What is wrong?? Many thanks! On Apr 28, 5:29 pm, "Dirk Goldgar" wrote: wrote in message ... Hi, I have a query - There everything is ok The data can be changed But when I create a form base on the query (Using Wizard - just select the table) the data caould not be changed via the form, Why?? Here is the query: SELECT Q_EMP_WORK_PCT_PREV_AND_CURRENT.SignOut, Q_EMP_WORK_PCT_PREV_AND_CURRENT.EmpNumber, Q_EMP_WORK_PCT_PREV_AND_CURRENT.[Emp Name], Q_EMP_WORK_PCT_PREV_AND_CURRENT.Year, Q_EMP_WORK_PCT_PREV_AND_CURRENT.Month, Q_EMP_WORK_PCT_PREV_AND_CURRENT.CurrentMonthPct, Q_EMP_WORK_PCT_PREV_AND_CURRENT.PrevMonthPct FROM Q_EMP_WORK_PCT_PREV_AND_CURRENT; In order to have the ability to change data in the query window - I changed the recordset type to: Dynaset (Inconsistent Updates), so now the query is ok. But the form based o the fom - The data could not be changed (I would like to give the user the option to change th SignOut value Many Thanks, Dola Did you set the *form's* RecordsetType property to "Dynaset (Inconsistent Updates)"? -- Dirk Goldgar, MS Access MVPwww.datagnostics.com (please reply to the newsgroup)- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Wow!! Thank you very much! You solved it for me - after a lot of hours I waste - You did it!! Many thanks Can you please give me some explanation - so I will know what is the meaning of it? Best Regards |
#6
|
|||
|
|||
Query is Updatable - but the form based on it - is not - Why??
On Apr 29, 5:07 pm, "Dirk Goldgar"
wrote: Is your form's Data Entry property set to Yes? It should be No. Wow!! Thank you very much! You solved it for me - after a lot of hours I waste - You did it!! Many thanks Can you please give me some explanation - so I will know what is the meaning of it? Best Regards Hi -- "Data Entry Mode" = True (or Yes) really means that viewing (or changing) existing records is *not* allowed -- that is, "Data Entry Only" "Data Entry Mode" = False (or No) really means that viewing (or changing) existing records *is* allowed -- that is, "Data Entry *and* viewing / changing Allowed" I find that the included documentation is often difficult to understand, and that coming here for help is *very* useful. To see the Access Help, press F1 for context sensitive help from the properties dialog that you used to change the Data Entry setting. -- Clif Still learning Access 2003 |
Thread Tools | |
Display Modes | |
|
|