[UPDATED] VBscript Access data pages Charts

Hi,
I'm trying to follow this page:
http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx
to programatically generate a chart in an access 2003 data page using VBscript.
The page refers to an example on a developper CD with samples on it. I could not find the CD or that page anywhere and I can't seem to find a way to generate a chart and have its datasource (an SQL query to my access database) changed dynamically by my users on our intranet.

That sample would be perfect for me to base my code on. However, since it seems difficult to find, does someone know how to do this?

Thank you

Quote:

---

Originally Posted by SebADM

The page refers to an example on a developper CD with samples on it. I could not find the CD or that page anywhere

---

If you are referring to Msowcvba.chm then you need the OWC (Office Web Components) installed.

http://support.microsoft.com/kb/319793

Thank you for answering.
OWC is installed on my system. I am using Access 2003 to create a web data page that will be accessible on our intranet. I was able to place the chart I want on the page and have it show the data I want from a query. What I want to do next is make it so that the users can choose two dates and click a button that will add the string "WHERE dateAvis BETWEEN 'fromDate' AND 'toDATE' ;" to the query feeding the chart, thus creating a report showing only data between the selected dates.

My problem is that I dont know how the query is fed to the chart. I thought I could program the chart in with a <script language=vbscript> tag in my HTML file and place the chart with an <object> tag...
I keep searching but I can't find a way to do this. I dont even know if that would be the proper way.

I found pretty good sites explaining how to programmatically create charts using VBscript and OWC:
http://www.ozgrid.com/forum/showthre...t=36501&page=1
http://www.4guysfromrolla.com/webtech/022101-1.2.shtml

My question is now how to make it so that the query changes when the user enters the date fields and presses the command button. Much like php and MySQL where the page would be reloaded with a diffrent value in the sql string variable...