charting in ms access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

raypiscopo - 01 Mar 2005 12:19 GMT

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

Reply to this Message

Duane Hookom - 02 Mar 2005 02:44 GMT

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.

Signature

Duane Hookom
MS Access MVP

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

Reply to this Message

raypiscopo - 02 Mar 2005 06:59 GMT

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

> 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
[quoted text clipped - 4 lines]
> > don'y
> > mind sharing?

Reply to this Message

anonymous@discussions.microsoft.com - 02 Mar 2005 04:10 GMT

EXPORT FIELDS W/MACRO TO EXCEL

CHART WITH EXCEL

>-----Original Message-----
>does anyone have any vb code for charting in ms access 2000 that they don'y
>mind sharing?
>.

Reply to this Message

raypiscopo - 02 Mar 2005 07:01 GMT

thanks anon,

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

Ray

> EXPORT FIELDS W/MACRO TO EXCEL
>
[quoted text clipped - 5 lines]
> >mind sharing?
> >.

Reply to this Message

raypiscopo - 02 Mar 2005 07:53 GMT

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

Reply to this Message

Duane Hookom - 03 Mar 2005 03:14 GMT

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.

Signature

Duane Hookom
MS Access MVP

> Hi again all,
>
[quoted text clipped - 7 lines]
>
> cheers

Reply to this Message

raypiscopo - 06 Mar 2005 15:09 GMT

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

> 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
[quoted text clipped - 11 lines]
> >
> > cheers

Reply to this Message

Duane Hookom - 06 Mar 2005 20:49 GMT

I would consider rolling my own. I have a report in the Corp Tech Demos at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4 that creates charts with
labels without using a graph control. You could store your markup
information in a table that sets the position. This would only work in a
report.

Signature

Duane Hookom
MS Access MVP

> Duane,
>
[quoted text clipped - 23 lines]
>> >
>> > cheers

Reply to this Message