Advanced graph design

[Tadynn]

Hi all,

I was wondering if anyone could help me, or possibly point me in the direction I need to go.......

Here's the situation. I'm currently in the process of designing a database that I'm going to use to run a host of reports that were created in excel.
These reports are currently used daily. Because of this, I'm currently in the process of creating the data sources (input forms, tables, etc) for all these reports in access.

My next goal, is to try and recreate the same excel reports in access one by one so that I can (hopefully) have the data as well as the reports all contained in the one program.

The problem is, that some of the excel reports are quite technical and require a lot of graphs. For example, I use LCL, FCL, trends, MAT projections and a whole host of other statistical tools. I've noticed that while it's quite easy to create the graphs in excel. The same can't be said for access.

My question is, does anyone know anything about creating technical graphs in access or where I can get information on the subject? I really want to try to do this. So any information you can provide would be a great help.


Thanks in advance

Tadynn.

 

[MichaelRed]

As far as I know, Excel and MS Access (and most / all MS Office products) use the same 'applet' (MSGRAPH) for generating graphs. It is -unfortunatly- true that much of the user functionallity seen in Excel is 'buried' in MS Access, and must be accessed PROGRAMATICALLY but it is there and can be used. I have only seen one third party reference to manipulating graphs/charts programatically (SAM'S Access Unleashed), and even there the information was a bit sketchy. But it was sufficient to write a small test program to get the properties which are exposed and it did have a few examples of manipulation of parts of the graph/chart to enable me to generate a variety of standard reports with various graph/chart types from a template. The major reference in the section was to the "Microsoft Office Developer's Kit".




MichaelRed
m.red@att.net

Searching for employment in all the wrong places