Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Data Access Pages

Discussion in 'Information Technology' started by Bromley, Jul 28, 2006.

Tags:
  1. Bromley

    Bromley
    Expand Collapse
    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.
     
  2. Loading...


  3. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    answers in line....

    --

    Ken Snell
    <MS ACCESS MVP>

    "Bromley" <Bromley@discussions.microsoft.com> wrote in message
    news:356DF563-CE19-468D-A756-46E623792EAC@microsoft.com...
    > 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").



    >
    > Any help would be appreciated.
     

Share This Page