Search results

  1. A

    Edit records through access page only, not table

    In my database, I'm trying to make it so that a user may only edit the records of a table through a data access page (DAP), and not through the table itself. I know that this is already covered in the Access Security FAQ (Item 25), but I'm having a hard time understanding what it wants me to do...
  2. A

    Resetting filter members of a pivot table

    I'd like to make a "reset" button that, when clicked, resets the view of my pivot table so that all of the filters have all of their elements selected (I mean the built-in filters accessible by clicking that little arrow next to every column header). The following line does this...
  3. A

    pivot table embedded in a web page...

    In a "wizard" generated data access page, if I have a pivotTable displaying the contents of my current database table, how do I make it so that clicking on any cell in the pivotTable will jump to the corresponding record for editing? I've done this MANY times, but it was always on accident and...
  4. A

    Help with code...

    MsgBox PivotTable5.ActiveData.Cells.DetailCells(0,0).Value Gives an error when I run?
  5. A

    changing cell colors in a pivot table?

    I want to make it so that an entire row will change color if it meets a certain criteria. Though I haven't figured out how to do it for a row, I have gotten it to change an entire column: PivotTable.Activeview.DataAxis.FieldSets(1).Fields(0).DetailBackColor = "Blue" In the above example it...
  6. A

    "Last modified" for a DAP

    I'm trying to make a "last modified" field for a DAP by adding a line to the default "save" action: <SCRIPT language=javascript event=onclick for=save> XXX = Date() try { MSODSC.CurrentSection.DataPage.Save(); } catch (e) { alert (e.description);} </SCRIPT> I'd like to have it save the...
  7. A

    Running a macro from a data access page

    I'm trying to add a "last updated" field to a table. So far I've got a macro that assigns the value Date() to that field for a corresponding record when run. Now I'm trying to link it to a "save changes" command button in a DAP in its' property field "Onbeforeactivate". All I'm doing is...
  8. A

    data access page + pivotTable (yeah I know, I know...)

    ...it seems like putting "DAP" and "pivotTable" in a subject automatically guarantees a thread with zero replies, but I'll ask anyway! ------------------------------------------------------------------------------------------- In Access 2000, I have a data access page. It has a pivotTable...
Back
Top Bottom