real time graph in FP from MS Access query

mahmad

unread,

Nov 15, 2009, 11:43:02 AM11/15/09

to

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

unread,

Nov 16, 2009, 4:11:22 AM11/16/09

to

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

--

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

"mahmad" <mah...@discussions.microsoft.com> wrote in message news:D99AEA5B-7E46-49E8...@microsoft.com...

Stefan B Rusynko

unread,

Nov 16, 2009, 4:23:45 AM11/16/09

to

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!" (-;
_____________________________________________

"Stefan B Rusynko" <sbr_...@hotmail.com> wrote in message news:ORFNHzpZ...@TK2MSFTNGP05.phx.gbl...

MickB Tenerife

unread,

Nov 17, 2009, 8:41:01 AM11/17/09

to

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

"Stefan B Rusynko" wrote:
to explain

> .
>

Stefan B Rusynko

unread,

Nov 18, 2009, 4:19:42 AM11/18/09

to

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!" (-;
_____________________________________________

"MickB Tenerife" <MickBT...@discussions.microsoft.com> wrote in message
news:CE4181E6-F417-47A5...@microsoft.com...

mahmad

unread,

Nov 25, 2009, 5:53:01 AM11/25/09

to

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

"Stefan B Rusynko" wrote:

> .
>

Stefan B Rusynko

unread,

Nov 25, 2009, 6:05:35 AM11/25/09

to

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

--

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

To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________

"mahmad" <mah...@discussions.microsoft.com> wrote in message news:0893FDBD-0293-4DB7...@microsoft.com...

mahmad

unread,

Nov 25, 2009, 7:16:02 AM11/25/09

to

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

"Stefan B Rusynko" wrote:

> .
>