Query is Updatable - but the form based on it - is not - Why??

[Sadnaot10]

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

 

[Dirk Goldgar]

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)"?

 

[Sadnaot10]

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!

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 -

 

[Dirk Goldgar]

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)

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!

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 -

 

[Sadnaot10]

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)

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!

news:[email protected]...

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)"?

(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

 

[Clif McIrvin]

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.