Edit/Add/Remove entries through DAP

Edit/Add/Remove entries through DAP

Post by Alex B » Tue, 05 Sep 2006 22:09:42


Hello!

I made a DAP from a form in my DB (by using 'Save As...' operation). This
DAP doesn't allow to add, edit or remove entries. Only move buttons are
enabled.

'ReadOnly' and 'Disabled' properties of textboxes etc. are set to false.
These properties of elements of source fom are also set to false. Grouplevel
properties 'AllowAdditions', 'AllowDeletions', 'AllowEdits' are set to true.
Primary keys are present in all tables. They are also used in form query.

What should I do? :)

WBR Alex.
 
 
 

Edit/Add/Remove entries through DAP

Post by MV » Wed, 06 Sep 2006 03:34:47

Common reasons why a DAP doesn't allow editing of the data:

You must define the Unique Recordset property for the page's section that
has the data.

You must have an element bound to the table's primary key field. It can be
hidden, but it needs to be on the Data Access Page if you wish to edit data.

You must use an updatable query for the recordset (note: Data Access Pages
are more picky in what's updatable and what's
not -- a query that works in a form may not work in a page).
--

Ken Snell
<MS ACCESS MVP>

 
 
 

Edit/Add/Remove entries through DAP

Post by Alex B » Fri, 08 Sep 2006 03:31:37

Thank you very much!

The first your advi (about the Unique Recordset property) made my DAP be
very obedient :) All is correct!

WBR Alex.



> Common reasons why a DAP doesn't allow editing of the dat>: >>
> You must define the Unique Recordset property for the page's section th>t
> has the dat>. >>
> You must have an element bound to the table's primary key field. It can >e
> hidden, but it needs to be on the Data Access Page if you wish to edit
dat>. >>
> You must use an updatable query for the recordset (note: Data Access Pag>s
> are more picky in what's updatable and what>s
> not -- a query that works in a form may not work in a page>.
> >- >>
> Ken Sne>l< > >> >>
> "Alex <." wrote in messa>e

Th>s> > > DAP doesn't allow to add, edit or remove entries. Only move buttons a>e> > > enable>.> >>>> > > 'ReadOnly' and 'Disabled' properties of textboxes etc. are set to fals>.> > > These properties of elements of source fom are also set to fals>.> > > Grouplev>l> > > properties 'AllowAdditions', 'AllowDeletions', 'AllowEdits' are set >o> > > tru>.> > > Primary keys are present in all tables. They are also used in form
quer>.> >>>> > > What should I do? >)> >>>> > > WBR Ale>.> >>>> >>> >>
>
 
 
 

Edit/Add/Remove entries through DAP

Post by Rod Maki » Sat, 09 Sep 2006 00:47:53

I had a similar problem, only my DAP was refering to a query. I found that
in the instance where it was a one to many relationship in the query I had
to select the table with the 1 part of the relationship, obvious I know but
it might help someone out there. And Im hoping that by helping (or trying
to) others someone might have a look at my problems:)


Rod





>> Common reasons why a DAP doesn't allow editing of the dat>>
>> You must define the Unique Recordset property for the page's section th>>
>> has the dat>>
>> You must have an element bound to the table's primary key field. It ca>>
>> >>
>> hidden, but it needs to be on the Data Access Page if you wish to ed>t
> dat>>
>> You must use an updatable query for the recordset (note: Data Acces>>
>> Pag>>
>> are more picky in what's updatable and what>>
>> not -- a query that works in a form may not work in a page>>
>> >>
>> Ken Sne>> <>> >> "Alex <." wrote in messa>>
>>> > Hell>> >>>>> >>> > I made a DAP from a form in my DB (by using 'Save As...' operation>.
> Th>> >>> > DAP doesn't allow to add, edit or remove entries. Only move buttons a>> >>> > enable>> >>>>> >>> > 'ReadOnly' and 'Disabled' properties of textboxes etc. are set t>> >>> > fals>> >>> > These properties of elements of source fom are also set to fals>> >>> > Grouplev>> >>> > properties 'AllowAdditions', 'AllowDeletions', 'AllowEdits' are set >> >>> > tru>> >>> > Primary keys are present in all tables. They are also used in fo>m
> quer>> >>>>> >>> > What should I do? >> >>>>> >>> > WBR Ale>> >>>>> >>>>>
>