MS Chart and MS Graph with forms and reports

[The Frog]

Hi guys,

I have never touched really on this area before with forms and
reports, and now I would like to be able to incorporate some graphs /
charts for a new little app I am building, and I need some guidance.
Can someone point me in the right direction?

1/ What is the difference between MS Chart and MS Graph?

2/ Which is better to work with for Access 97?

3/ Is there anywhere I can find a good tutorial on using either /
both?

4/ Are there any known issues with late binding with either of these?

5/ Any problems using ADO recordsets for the source of the data?

If anyone has the time to steer me the right way at the start I would
appreciate it.

Cheers

The Frog

[Jens Schilling]

Hi,

The Frog wrote:

I have never touched really on this area before with forms and
reports, and now I would like to be able to incorporate some graphs /
charts for a new little app I am building, and I need some guidance.
Can someone point me in the right direction?

First let me emphasize that I have no experience with chart or graph beside
from playing around with it.

But as you have got no responce right now, I will try to translate to you
the quintessences from a presentation I've attended some years ago.

One of the importent facts mentioned within this presentation is that the MS
support for Chart ended already on the 1.7.1999 ( as a single threaded
control it doesn't support IE 4 ).

Furthermore the presentation stated that chart has less functions then
graph, needs a DataGrid-Control (Graph uses SQL) und contains less
capabilities regarding depictions and manipulation.

Apart from these translation assistance I can only try to help you with some
links taken from my collection:

On the site of the Access User Group of San Diego you may find the
presentation "Charting for Access" ( see 3/24/04) and "MS Graph Use in
Access 97" (see 08/01/99 ).

On Microsofts site you may find :

Access 97 Graph Sample Database
http://support.microsoft.com/kb/186855/en-us

Sample that shows a generic method to control the data for pie charts
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

Microsoft Graph Visual Basic Reference
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

And at last a A97 sample using carts as trend displays in Access:
http://www.access-programmers.co.uk/...d.php?t=107870

HTH
Regards
Jens

[Jens Schilling]

Hi,

Jens Schilling wrote:

On the site of the Access User Group of San Diego you may find the
presentation "Charting for Access" ( see 3/24/04) and "MS Graph Use in
Access 97" (see 08/01/99 ).

Oh ;-)
Here's the link:

http://www.augsd.org/Articles.html

Regards
Jens

[The Frog]

Jens, thankyou very much for this information. I have found it so
difficult to find good advice on this topic and I really appreciate
your input. Thankyou for the links too, they are most helpful indeed.
I think I will be good from here to be able to figure the rest out.

I really do appreciate this Jens.

Thankyou

The Frog