A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2008, 02:57 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 3
Default 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  
Old April 28th, 2008, 03:29 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default 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  
Old April 29th, 2008, 09:32 AM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 3
Default 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  
Old April 29th, 2008, 03:07 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default 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  
Old April 30th, 2008, 02:42 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 3
Default 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  
Old April 30th, 2008, 05:57 PM posted to microsoft.public.access.forms
Clif McIrvin[_2_]
external usenet poster
 
Posts: 629
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.