Search results

Is there a way to set the format of a Total field in vba? This code sets the format of the underlying field but not the total of it: Forms("Form Name").PivotTable.Activeview.DataAxis.FieldSets(0).Fields(0).DetailBackColor = "Red"

I have a pivot table in Access that is based on a query that looks like this: Project Material1 Material2 Material3 1 223 331 423 2 423 234 244 3 855 773 343 I want the materials to go from the columns into the rows of the pivot table so they can be collapsed and expanded and have a total at...

Hi, I have a table like the one attached (simplified from the original). If I make a query based on it, I cannot figuire out how (or if?!) I can get the last two columns to calculate: YearToDate and FullYear The CurrentYear and CurrentPeriod can be stored in a table called CurrentDate...

Hi, I have an Access backend database that has bloated up to over 400mb. When I do the Compact & Repair it makes almost no difference. If I ZIP the database it shrinks down to 32mb. If I import all the tables to a new database it is 70mb. Is there another way I can compact it or avoid it...