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

Jul 1 '08 #1

Subscribe Reply

4705

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

Jul 2 '08 #2

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

Jul 2 '08 #3

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

Jul 3 '08 #4

Similar topics

1508

Two chart questions

by: Steven Malcolm | last post by:

I have two related chart problems. I have a simple chart which shows waste in a manufacturing process. On a basic bar chart we show waste percentage by day, I would like to be able to add the following to the chart 1. draw a line across the chart at the acceptable waste level, which is a global variable (4.5 at the moment)

Microsoft Access / VBA

2829

Faster alternative to Microsoft Graph 5.0 Chart ??

by: mark | last post by:

I've got an 83-page report which contains an Microsoft Graph 8 Chart, but the report takes FOREVER to format, probably because the row source is a bit complex: TRANSFORM Sum(qryCallsSummarizedByArbitraryYear.CallCount) AS SumOfCallCount SELECT qryCallsSummarizedByArbitraryYear.DateByYear FROM qryCallsSummarizedByArbitraryYear GROUP BY qryCallsSummarizedByArbitraryYear.DateByYear PIVOT qryCallsSummarizedByArbitraryYear.;

Microsoft Access / VBA

6796

Getting to a Chart's Props?

by: PeteCresswell | last post by:

I've been to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mschrt/html/vbobjtitleobject.asp, but still don't have a clue. For example, I've got a chart object namde 'grphStats' in a form named frmChart. ?Forms!frmChart!grphStats.Name returns "grphStats" as expected, but I can't get any further.

Microsoft Access / VBA

7202

Line Chart..

by: Serdar C | last post by:

hello there.. there used to be a usefull and simple control on vb6.0 which was a line chart.. it was quite easy to use.. but in c# theres a pani named "crystal reports" and its too much complicated for just drawing a line chart in my opinion... do u now a free control that i can use in my programs? and one more problem is i can draw a line chart in crystal reports but mysteriously it just shows the count of numbers in chart.. my data is...

C# / C Sharp

1162

HOWTO: Create Single Mixed Style Chart?

by: Don Wash | last post by:

Hi There! I'm using bulit-in CrystalReport that comes with VS.NET 2003 to create reports for use it ASP.NET. How do I configure a graph in the Report (*.rpt file) so that I can have a **single** graph with both Bar Chart and Line Chart in it? I need Line Chart to display individual categories and I need Bar Chart to display the mean of all the categories I have.

ASP.NET

309

Chart control

by: EDom | last post by:

Hi, Is there any open source server side chart control or graph control for web forms? Regards

ASP.NET

7636

Creating and manipulating an Excel Chart in Microsoft Word using Automation from VB.NET.

by: Robin Tucker | last post by:

Heres and interesting problem: I have a VB.NET program that creates reports via. Word Automation. This all works fine. What I want to do as part of this report generation process is to embed a graph/chart within the report, once again from VB.NET. I have chosen to use Excel.Chart.8. So, to embed I do this from VB.NET: Dim theNewShape As InlineShape = m_Document.InlineShapes.AddOLEObject (ClassType:="Excel.Chart", _

Visual Basic .NET

10433

Creating Gantt Chart in PHP

by: Kuna | last post by:

Hi All, I am trying to create a gantt chart in php by getting data from database. I am using WindowsXp OS and having php-4 and my-sql DB. I have installed the JPGRAPH package to my system and including the jpgraph modules accordingly. I am able to create a gantt chart by hardcoding the datas but when I am trying to get the data from database then I am not able to get the chart it is showing errors. I think thre might be some problem in...

PHP

4585

Chart Problem Under Vista

by: Wayne | last post by:

I posted about this problem over 12 months ago and even after Vista SP1 the problem still exists when running an Access database (A2003 and A2007 tested) under Vista. A workaround was suggested by another group member at that time, but it's hardly ideal. MS should really look at this and fix it. When a form containing a chart is opened the chart object is visible, but no chart data is visible. If any other form is opened over the top...

Microsoft Access / VBA

8969

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8792

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9479

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9209

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8215

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6054

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4826

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3280

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2193

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General