Recent content by Atomsk

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...

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...

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...

"Wrong number of arguments, or invalid property assignment: 'PivotTable5.ActiveData.Cells'" Supposedly the following is the correct code in VBA, I'm just trying to figure it out for VBS: Dim CellValue Dim ActView As PivotView Dim fldSets As PivotFieldSets Dim Sel As PivotDetailRange Dim...

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

Unfortunately, I don't seem to have one of those (this is a data access page).

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...

But wait! <SCRIPT language=vbscript event=onclick for=DropdownList0> <!-- Set pview = PivotTable5.ActiveView Set c = PivotTable5.Constants Set fld = pview.FieldSets("Request ID").Fields(0) fld.FilterFunction = c.plFilterFunctionInclude If DropdownList0.selectedIndex = 0 Then fld.FilterMembers...

...and maybe it doesen't.... /sigh With multiple dropdown indexes, the line Set pview = PivotTable5.ActiveView screws everything up since, after the view is modified, the table has no way to revert back to what it was before, and ends up working off of those values instead of...

BuMp! Progress has been made! <SCRIPT language=vbscript event=onclick for=DropdownList0> <!-- If DropdownList0.selectedIndex = 0 Then Set pview = PivotTable5.ActiveView Set c = PivotTable5.Constants Set fld = pview.FieldSets("Request ID").Fields(0) fld.FilterFunction =...

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...

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...

...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...