real time graph in FP from MS Access query

[mahmad]

Hi,

I would like to be able to show a chart in IE containing some data from a MS
Acess query. Whenever the query is updated the chart will get updated as
well. Also how do i go about having multiple charts.

If i have 2 queries this will produce 2 charts these will then flip between
chart 1 and chart 2 similar to powerpoint slide show but in Internet Explorer.

thanks for your help

Mo

 

[Stefan B Rusynko]

See http://www.asp101.com/Samples/bar_chart.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi,

I would like to be able to show a chart in IE containing some data from a MS
Acess query. Whenever the query is updated the chart will get updated as
well. Also how do i go about having multiple charts.

If i have 2 queries this will produce 2 charts these will then flip between
chart 1 and chart 2 similar to powerpoint slide show but in Internet Explorer.

thanks for your help

Mo

 

[Stefan B Rusynko]

PS
and to switch charts try any of the DHTML at
http://www.dynamicdrive.com/dynamicindex17/index.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


See http://www.asp101.com/Samples/bar_chart.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi,

I would like to be able to show a chart in IE containing some data from a MS
Acess query. Whenever the query is updated the chart will get updated as
well. Also how do i go about having multiple charts.

If i have 2 queries this will produce 2 charts these will then flip between
chart 1 and chart 2 similar to powerpoint slide show but in Internet Explorer.

thanks for your help

Mo

 

[MickB Tenerife]

Hi Stefan, really interested in this thread. I have been to the page, however
, Im not sure where to inject the code, and where it icks up the data. Can
you please just put a few more words together for me , thanks

:
to explain

 

[Stefan B Rusynko]

The 2 main samples on the page code use an array (created in the code) for the charts
But there is a also sample using a DB
(the last screen shot - w/ negative #)
- download the zip file in the link at "download the code (19 KB) and give it a look"
(which also has a sample access DB in it)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi Stefan, really interested in this thread. I have been to the page, however
, Im not sure where to inject the code, and where it icks up the data. Can
you please just put a few more words together for me , thanks

:
to explain

 

[mahmad]

Hi,

I am a little confused, can i open the default file within FP and preview
the chart. What do i need to do once i have downloaded the zipped file.

Sorry i am new to this and FP so appricate you help.

cheers

The 2 main samples on the page code use an array (created in the code) for the charts
But there is a also sample using a DB
(the last screen shot - w/ negative #)
- download the zip file in the link at "download the code (19 KB) and give it a look"
(which also has a sample access DB in it)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi Stefan, really interested in this thread. I have been to the page, however
, Im not sure where to inject the code, and where it icks up the data. Can
you please just put a few more words together for me , thanks

:
to explain

See http://www.asp101.com/Samples/bar_chart.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi,

I would like to be able to show a chart in IE containing some data from a MS
Acess query. Whenever the query is updated the chart will get updated as
well. Also how do i go about having multiple charts.

If i have 2 queries this will produce 2 charts these will then flip between
chart 1 and chart 2 similar to powerpoint slide show but in Internet Explorer.

thanks for your help

Mo


.

.

 

[Stefan B Rusynko]

Import the zipped files into your online site in FP
- make sure you import the Access mdb file into the fpdb folder
then edit the imported files ASP code to correct your db connections to the sample db

PS

You will need to understand how to set up DB connections and how to hand code in ASP to use the examples
- there is no "wizard" to do it for you

--




Hi,

I am a little confused, can i open the default file within FP and preview
the chart. What do i need to do once i have downloaded the zipped file.

Sorry i am new to this and FP so appricate you help.

cheers

The 2 main samples on the page code use an array (created in the code) for the charts
But there is a also sample using a DB
(the last screen shot - w/ negative #)
- download the zip file in the link at "download the code (19 KB) and give it a look"
(which also has a sample access DB in it)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi Stefan, really interested in this thread. I have been to the page, however
, Im not sure where to inject the code, and where it icks up the data. Can
you please just put a few more words together for me , thanks

:
to explain

See http://www.asp101.com/Samples/bar_chart.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi,

I would like to be able to show a chart in IE containing some data from a MS
Acess query. Whenever the query is updated the chart will get updated as
well. Also how do i go about having multiple charts.

If i have 2 queries this will produce 2 charts these will then flip between
chart 1 and chart 2 similar to powerpoint slide show but in Internet Explorer.

thanks for your help

Mo


.

.

 

[mahmad]

Hi Stefan,

i need to get something up and running very quickly, what would be the best
way of creating a graph from MS Access.

Are you aware of any other programs on the web which allow dynamic updates
to graphs via MS Access.

thanks for your help

Import the zipped files into your online site in FP
- make sure you import the Access mdb file into the fpdb folder
then edit the imported files ASP code to correct your db connections to the sample db

PS

You will need to understand how to set up DB connections and how to hand code in ASP to use the examples
- there is no "wizard" to do it for you

--




Hi,

I am a little confused, can i open the default file within FP and preview
the chart. What do i need to do once i have downloaded the zipped file.

Sorry i am new to this and FP so appricate you help.

cheers

The 2 main samples on the page code use an array (created in the code) for the charts
But there is a also sample using a DB
(the last screen shot - w/ negative #)
- download the zip file in the link at "download the code (19 KB) and give it a look"
(which also has a sample access DB in it)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi Stefan, really interested in this thread. I have been to the page, however
, Im not sure where to inject the code, and where it icks up the data. Can
you please just put a few more words together for me , thanks

:
to explain

See http://www.asp101.com/Samples/bar_chart.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hi,

I would like to be able to show a chart in IE containing some data from a MS
Acess query. Whenever the query is updated the chart will get updated as
well. Also how do i go about having multiple charts.

If i have 2 queries this will produce 2 charts these will then flip between
chart 1 and chart 2 similar to powerpoint slide show but in Internet Explorer.

thanks for your help

Mo


.

.

.