I created a DAP from a form I have built, but none of the text fields, or
check boxes allow me to edit them while in the DAP. I am trying to read up
on DAP's but I have not found anything that helps me understand how to set
them to be editable. Can someone help?

more info for you: I am using office 2003 SP3 and IE7. I have installed
OWC11. I have the access database and the DAP (HTML Document) saved in the
same folder as the db.

"Cameron" wrote:

> I created a DAP from a form I have built, but none of the text fields, or
> check boxes allow me to edit them while in the DAP. I am trying to read up
> on DAP's but I have not found anything that helps me understand how to set
> them to be editable. Can someone help?

Data Access Pages are more often noneditable because the query does not
allow the identification of the unique table being edited.

Did you set the Unique Table property of the Section's Data tab to be the
table that is being edited?

Also, do you have a control on the page that is bound to the primary key
field of the table? The control can be invisible/hidden, but it needs to be
on the page for the page to correctly identify the record.

Also, note that DAPs will not allow editing with many queries that are
editable in a form. This can be somewhat frustrating....

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Cameron" <(E-Mail Removed)> wrote in message
news:3ECF3FF2-FF4F-49DD-953E-(E-Mail Removed)...
>I created a DAP from a form I have built, but none of the text fields, or
> check boxes allow me to edit them while in the DAP. I am trying to read
> up
> on DAP's but I have not found anything that helps me understand how to set
> them to be editable. Can someone help?

I added a primary key and made sure it was added to the query and now the DAP
is editable. Thanks. I have a button on the form to close the form.
Obviously now it would be used to close the browser I guess. Any quick fix
to fix the button to do so? I am able to open script editor for the page.

"Ken Snell" wrote:

> Data Access Pages are more often noneditable because the query does not
> allow the identification of the unique table being edited.
>
> Did you set the Unique Table property of the Section's Data tab to be the
> table that is being edited?
>
> Also, do you have a control on the page that is bound to the primary key
> field of the table? The control can be invisible/hidden, but it needs to be
> on the page for the page to correctly identify the record.
>
> Also, note that DAPs will not allow editing with many queries that are
> editable in a form. This can be somewhat frustrating....
>
> --
>
> Ken Snell
> http://www.accessmvp.com/KDSnell/
>
>
> "Cameron" <(E-Mail Removed)> wrote in message
> news:3ECF3FF2-FF4F-49DD-953E-(E-Mail Removed)...
> >I created a DAP from a form I have built, but none of the text fields, or
> > check boxes allow me to edit them while in the DAP. I am trying to read
> > up
> > on DAP's but I have not found anything that helps me understand how to set
> > them to be editable. Can someone help?
>
>
> .
>

You don't want to close a DAP unless you have another one open, else you
lose the ability to interact with the database unless you start over with
the beginning URL. So normally one uses a button to navigate from the
current DAP to a different DAP. You don't actually close the DAP itself.

--

Ken Snell
http://www.accessmvp.com/KDSnell/



"Cameron" <(E-Mail Removed)> wrote in message
news:E2CEA507-7C46-49E4-9328-(E-Mail Removed)...
>I added a primary key and made sure it was added to the query and now the
>DAP
> is editable. Thanks. I have a button on the form to close the form.
> Obviously now it would be used to close the browser I guess. Any quick
> fix
> to fix the button to do so? I am able to open script editor for the page.
>
> "Ken Snell" wrote:
>
>> Data Access Pages are more often noneditable because the query does not
>> allow the identification of the unique table being edited.
>>
>> Did you set the Unique Table property of the Section's Data tab to be the
>> table that is being edited?
>>
>> Also, do you have a control on the page that is bound to the primary key
>> field of the table? The control can be invisible/hidden, but it needs to
>> be
>> on the page for the page to correctly identify the record.
>>
>> Also, note that DAPs will not allow editing with many queries that are
>> editable in a form. This can be somewhat frustrating....
>>
>> --
>>
>> Ken Snell
>> http://www.accessmvp.com/KDSnell/
>>
>>
>> "Cameron" <(E-Mail Removed)> wrote in message
>> news:3ECF3FF2-FF4F-49DD-953E-(E-Mail Removed)...
>> >I created a DAP from a form I have built, but none of the text fields,
>> >or
>> > check boxes allow me to edit them while in the DAP. I am trying to
>> > read
>> > up
>> > on DAP's but I have not found anything that helps me understand how to
>> > set
>> > them to be editable. Can someone help?
>>
>>
>> .
>>