Data Access Pages

[Guest]

1) Is it possible to create an updatable Data Access Page using a query to
populate the Access Page? At the moment I can use a table and create a page
that is updatable by the user, but when I use a query the fields are
non-editable in the Data Access Page. I need to use a query so I can specify
a start and end date to select data that I want to look at.

I am using an UpdatableSnapshot, and have set the AllowAdditions, AllowEdits
etc.

2) When creating a tabular Data Access Page, some of the headings you can
click on to sort but others are non-sortable. What controls this and how can
I choose which heading I can click on and sort?

3) If you choose the Office Spreadsheet layout and your data includes
date/time fields, the time fields seem to be automatically populated with
'30-Dec-99' values and not the actual time from the data record which I would
like to display. The date fields work fine but the time fields do not. How
can I control this so the time shown is the actual time of the transaction
that is stored in the original data table?

Any help would be appreciated.

 

[Ken Snell \(MVP\)]

answers in line....

--

Ken Snell
<MS ACCESS MVP>

1) Is it possible to create an updatable Data Access Page using a query
to
populate the Access Page? At the moment I can use a table and create a
page
that is updatable by the user, but when I use a query the fields are
non-editable in the Data Access Page. I need to use a query so I can
specify
a start and end date to select data that I want to look at.

I am using an UpdatableSnapshot, and have set the AllowAdditions,
AllowEdits
etc.

Query for a DAP often is nonupdatable than the same query in a form.
Usually, for a DAP, using more than two tables is often going to result in a
nonupdatable query. Rules of thumb -- be sure you specify the table that is
being updated (only one table's data can be edited/updated by a DAP, even in
a multitable query) in the Unique Recordset property, be sure that you have
the primary key of that table in the query's fields, and be sure that you
have an element that is bound to that primary key on the DAP (this element
can be invisible).

2) When creating a tabular Data Access Page, some of the headings you can
click on to sort but others are non-sortable. What controls this and how
can
I choose which heading I can click on and sort?

I do not know the answer to this, sorry.

3) If you choose the Office Spreadsheet layout and your data includes
date/time fields, the time fields seem to be automatically populated with
'30-Dec-99' values and not the actual time from the data record which I
would
like to display. The date fields work fine but the time fields do not.
How
can I control this so the time shown is the actual time of the transaction
that is stored in the original data table?

A time value of 0 is interpreted as the date/time value of midnight,
December 30, 1899, which is why you see that result in those time elements.
Typically, the way to show date and time is in one element, with the format
set to show both the date and time in the desired format. If you split the
time into its own element, then you need to format the element to show the
time in your desired format (e.g., "hh:nn:ss").