Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sadnaot10@gmail.com - 28 Apr 2008 14:57 GMT
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 - 28 Apr 2008 15:29 GMT
> Hi,
>
[quoted text clipped - 22 lines]
> Many Thanks,
> Dola

Did you set the *form's* RecordsetType property to "Dynaset (Inconsistent
Updates)"?

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Sadnaot10@gmail.com - 29 Apr 2008 09:32 GMT
> 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"
<d...@NOdataSPAMgnostics.com.invalid> wrote:
> <Sadnao...@gmail.com> wrote in message
>
[quoted text clipped - 36 lines]
>
> - Show quoted text -
Dirk Goldgar - 29 Apr 2008 15:07 GMT
Is your form's Data Entry property set to Yes?  It should be No.

Signature

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!

On Apr 28, 5:29 pm, "Dirk Goldgar"
<d...@NOdataSPAMgnostics.com.invalid> wrote:
> <Sadnao...@gmail.com> wrote in message
>
[quoted text clipped - 36 lines]
>
> - Show quoted text -
Sadnaot10@gmail.com - 30 Apr 2008 14:42 GMT
On Apr 29, 5:07 pm, "Dirk Goldgar"
<d...@NOdataSPAMgnostics.com.invalid> wrote:
> Is your form's Data Entry property set to Yes?  It should be No.
>
[quoted text clipped - 61 lines]
>
> - 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 - 30 Apr 2008 17:57 GMT
On Apr 29, 5:07 pm, "Dirk Goldgar"
<d...@NOdataSPAMgnostics.com.invalid> 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.

Signature

Clif
Still learning Access 2003

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.