How to make a Chart (MS Chart) with data from a DB????

Hi all,


Can u show me how to have a chart produced from data directly (or indirectly) from a MDB (access2000)???



An example project would be brilliant, or the code???




Please help

kiesmithuk, here is a sample code for you.

Enjoy it!

Don't forget that MSChart leaks memory like a sieve, so if that's a concern, get a better charting control.

- gaffa

Thanks Chris that was just what i was after :-), now ill just convert it to DAO and wahey ;)

Oops, I was using the ADO object :p why not continue use the ADO? since that the trend for the database accessing in VB. 'coz DAO is rather old and less function as compare to ADO, although in some occasion it ran faster :rolleyes:

Well in my project i have used DAO throughout so it would make no sense to use ADO just for the chart as it would not be consistent with the rest of my project. I have found DAO to be more or less as fast as of yet, although it is old, it is still good. :D