Search results for query: *

The problem lay in the fact that I needed the graph to be in a Form, not a report. Once I created the graph in a form all the object properties were available.

I have the object defined as OLEunbound0 and have tried the solution as a form and as a report.

I do have it checked. That is what allowes me to dimension the variable as a Graph.Chart. However, the enabled and locked actions keep comming up with an error.

I am using Access 2003 and am trying to save a Microsoft Graph chart unbound object in a report as a GIF file for uploading to Sharepoint. I have copied code from the Microsoft support shown below. However, when I run the code my system does not recognize the unbound.locked and unbound.enabled...

Thanks dhookom and Golom for your feedback. Since my original search for a Median calculation returned dozens of options I am trying other alternatives to see if they will work for my needs.

Duane, I apologize for missing your first question. Although I use SQL I am not used to thinking of queries in SQL view? Attached is the SQL code for the query. We do display null records for the LeadTimeVariance field but I was assuming I would filter those out in the Median function using...

I tried this replacement with no affect. My actual call statement within the report is: =IIf([CountMeSum]=0,0,IIf([CountMeSum]=1,[LeadTimeVariance],Median("qWEDnetEcoData","[LeadTimeVariance]","[CountMe] = 1 and Month([Plan Due Date]) = " & [ForMonth] & " and [FunctionalArea] = '" &...

I am trying to calculate the Median value for a field in a grouped report. The wierd thing is it works in my beta-test version but not in my production version. I am assuming I am missing some setting in my production version. I have confirmed my VBA references match in both versions. I am...