charting in ms access 2000

R

raypiscopo

does anyone have any vb code for charting in ms access 2000 that they don'y
mind sharing?
 
D

Duane Hookom

I will sometimes create a similar chart in Excel and then record a "maco"
while I change properties of the chart. Afterward, I copy and paste the code
into Access. Sometimes I have to modify the code but it at least gets me
kick started.
 
R

raypiscopo

Thanks Duane,

I will try to do exactly that to see if I can access the charts properties
in vb and get it to do what I want. Like most people it seems, I am having a
go at developing an interactive stock market charting package

cheers

Ray
 
R

raypiscopo

thanks anon,

I am trying to create something a little more sophisticated so that I won't
need excel

Ray
 
R

raypiscopo

Hi again all,

I think a little more explanation of my needs is required. I don't just need
to chart data. I need to be able to make edits to the chart at runtime. i.e.
adding lines and text which can then be stored to the native database for
the chart and be displayed exactly as they were created the next time the
chart is displayed. Can anyone help?

cheers
 
D

Duane Hookom

I don't think Access can do this without a LOT of work. Displaying results
of numbers is not that difficult. Creating and storing mark-up information
adds a level of complexity that would require a third-party application.
 
R

raypiscopo

Duane,

I was aware this will be difficult, but I have already invested a heap of
time in this and don't want to abandon it. If you have any useful samples
they would be much appreciated


cheers
 
Top