I am not able to find any graphName object. But If I can edit in runtime the Form - datasheet .. then my objective fullfills..is that possible to change values of the datasheet in runtime? How?
Rey Obrero (Capricorn1)
graphName - you have to change this with the actual name of your graph.
suvmitra
ASKER
I have OLE Class as Microsoft Graph Chart
Name as OLEUnbound0
I am trying the below query but it is not working, can you suggest?
SELECT [Index],Sum([P1]) AS [forms]![Form_frmMain]![txtD7]
Rey Obrero (Capricorn1)
where is your graph located? in form frmMain?
suvmitra
ASKER
No my graph is located on Form1 ; but I am opening frmMain, from frmMain I am opening frmReports, from frmReports I am opening frmCharts and from frmCharts I am opening Form1,
the below is the default SQl, but I need to modify the [SumOfP1] with some text box data I have stored in the frmMain.
SELECT [Index],Sum([P1]) AS [SumOfP1],Sum([P2]) AS [SumOfP2] FROM [tblSlide6A5] GROUP BY [Index];
Rey Obrero (Capricorn1)
what is the name of the second textbox, the first one is txtD7. is this correct?
Hi,
Every thing is fine now..but I need one more thing to know. In the X Axis (look at the picture) there are values like 13, 14, 15 which I want to replace as 13= jan, 14 = Feb like ways .. can you please further guide me to accomplish that? Many thanks!