Search results for query: *

Hello!! I have been working with Access for many years, but came across something I can't find out to fix. In years past, when I was using the properties window, if I clicked on any of the events, in the bottom left of my access window, it would give a little note about when each event would...

Maybe I am wanting too much flexibility. I wanted this column of info added to the pivot table as management wants to see the percentages, but I also wanted them to have the ability to manipulate what data they see. unfortunately, adding the percent column now gives me inaccurate totals. I'm...

I've accomplished by turning off grand totals on the rows and adding a calculated field to show that info. Looking at an alternative to the column grand totals.. thanks!

thanks again. The next thing I am researching is how to get the percentages to not add into the grand total. any suggestions on that part? from what I am seeing, that is the way Excel is designed to work, so am not sure if it's possible. I've considered the possibility of adding another...

Well it's working- but now My Grand totals are off.. LOL.. oy. Count of TRRID Timely OpenMonthYear No Yes Percent Timely Grand Total 04-Apr-2011 1 100 101 05-May-2011 194 3176 94.24 3464.24 06-Jun-2011 147 2537 94.52 2778.52 07-Jul-2011 307 1613 84.01 2004.01 Grand Total 648 7327 372.77...

FINALLY! After a day of banging my head against the wall - here is the elusive Pain in the.. you know what.. single little line of code (if I could break something now I would...) Pt.PivotFields("Timely").CalculatedItems.Add "Percent Timely", "= timely[yes]...

Actually - I had not tried that yet - mainly because I have only done the macro's in excel maybe 2 times before, and since I haven't used them much, it simply didn't occur to me. I didn't answer right away because I was trying that option first, so I could reply with a result. Here's the...

that is the table the code is creating at the moment. the percent timely field is not showing in the right location at all, and isnt giving me any values (which could be because the column references are wrong)

thank you for your help, unfortunately, I am nearly 5 hours into researching this and am only gaining tiny steps in the progress. I really would like it to work, but I am beginning to think I will have to give up and come back to it in the future (maybe weeks or months away). I just can't...

attempting to paste a copy of the table here:

Thanks Skip. After playing with this for awhile, I am beginning to think what I want to happen is probably not possible. Right now, I have columns in the pivot table that look like this No Yes Grand Total I created one outside the table that is called "Percent Worked Timely"...

Let me add that the code above is code that is added AFTER the pivot table is created - it manipulates the data in the sheet after the pivot table. The code to generate the raw pivot table is thus: objWB.Activate With objWB.PivotCaches With .Add(SourceType:=xlDatabase...

the program is working - currently i am forcing the formula into the last column of the pivot table. I know that column E is the last column, the row is determined by a subroutine that finds the last row of the pivot table. Since I know the column and number of rows, I am autopopulating the...

here's a section of the code. let me know if this helps.. If InStr(1, sFullPath, "TRRTimelyPivotTableData_AsOf_", 1) Then With oXL.ActiveWorkbook.Worksheets("qryBasicReportInfo-Pivot").Range("E5") .Value = "Percent Worked Timely" End With With...

Good Morning!! I currently am using Access 2003 vba to export data to an excel pivot table via automation. The table creation works great - and I have added a column to the end of the table to calculate percentages on 2 of the rows (it looks like this): ClosedBy (All) Closed (All)...

well I found it. SOMEHOW the trust center settings were corrupted. I never changed them, and when i was viewing the trust center settings the folder and 'sub folder' option was checked. I decided to re-fresh the path just to see, and when I went to 'modify' the path, I noticed the 'sub...

Thank you for the reply - i did try this but it wasn't giving me the results I wanted. For the time being, I am bypassing it and hoping the users won't mind getting taken to the tab control that was being refreshed. i.e., instead of it flipping to that control and back, I am just going to...

Help :( I have HOURS into this database setup, and noticed all of a sudden my ENVIRON("USERNAME") was not working.. I thought it was acting funny based on other posts(i.e. not reliable), but then tried it as a function/api instead - still didnt work, then I noticed that NONE of my code is...

hello all! My issue is this: I have a main form frm_Tasks with a suform frm_TasksTracking. Because this will be used heavily, I want to NOT force the users to click a button or 'goto' a new record, I want to the New record on the subform to auto set when the form loads, and when navigating...

just some additional info - it's access 2007 and the only default value I had set originally on the subform was a date field. I removed that setting to test it, and still get the error. here are the only fields on the subform/table: id - autonumber fldchangesid - number (this is the field...