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 pageReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10821-data-access-pages.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10821
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
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.