report footer and data

[gingergina]

1. I have just built some access charts, and sometimes when I or a client clicks one open...it will display no data when there is data. When it is closed and reopened, the normal data then shows. Anyone have a

cure/idea/longshoot for me.

2. I have a report which displays the date in the aDate Header(top). I have ProductName in a Header just above the Detail section and below the aDate header. Below the Detail section is the ProductName Footer which summarizes the Detail info. Below that is the aDate Footer. If there is only 1 or 0 Products in the ProductName of the Header, there is no reason for the ProductName Footer. In the ProductName Footer I have textboxes that summarize and average data, and if only one product, no need to sum/avg, no need to see the ProductName footer. If the "number of occurances for the" ProductName Header < 2 then ProductName Footer=invisible or its height=0...but what vba or query etc can grab a handle to this "occurance being <2)...any ideas/thought/wild stabs are welcome.

michael.lynn@us.gases.boc.com or respond to forum

 

[simongallop]

Part 1: Graphs are a pain in the **** when it comes to updating the data!! In the section bar containing the graph, place this code in the OnFormat event

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)

Dim objChart As Object
Set objChart = Me.GraphName
objChart.Refresh
Set objChart = Nothing

End Sub