you were right. i didn't enable the x-axis properties.. and all along i thought that i must have done something wrong in my code. now the labels are all coming out.. :)
and for the Count function, i think i'm gonna try to use it instead of opening and closing my recordset. thanks a lot!
the reason why i kept on opening and closing the recordset is because i want to run different sql statements each time i go into the loop.. i couldn't think of another way..
Private Sub monthlyReport()
dateFrom = "1/" & aFrom & "/" & yrFrom
dateTo = "1/" & aTo &...
i try to set my chart back to defaults (mschart1.ToDefaults) and the labels at the bottom actually appeared! but other things such as the chart title and colours doesn't come out the way i want it to anymore (all have changed to the default settings). sigh.. this is giving me headaches.
thanks a lot for the reply! appreciate it a lot. yeah.. think i understand better now. there's another thing i want to ask. for your chart, the strLapNo is the label on the x-axis, am i right? i've tried something but the label doesn't seem to display.
arrMonth(mth, 1) = "Month " &...
hi James,
i went through your code as i am doing something similar to yours. i'm not familiar at all with MSChart.. hope you can help me out here.
(Me.rstSessionStatistics.Recordset.Fields("MinLapTime") * 0.95)
what's rstSessionStatistics used for? cause when i do 'Me.' in my vb...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.