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

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.

--
Duane Hookom
MS Access MVP


"raypiscopo" <(E-Mail Removed)> wrote in message
news:2AA67516-7222-4B74-A380-(E-Mail Removed)...
> does anyone have any vb code for charting in ms access 2000 that they
> don'y
> mind sharing?

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?
>.
>

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

"Duane Hookom" wrote:

> 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.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "raypiscopo" <(E-Mail Removed)> wrote in message
> news:2AA67516-7222-4B74-A380-(E-Mail Removed)...
> > does anyone have any vb code for charting in ms access 2000 that they
> > don'y
> > mind sharing?
>
>
>

thanks anon,

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

Ray

"(E-Mail Removed)" wrote:

> 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?
> >.
> >
>

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

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.

--
Duane Hookom
MS Access MVP


"raypiscopo" <(E-Mail Removed)> wrote in message
news:17324DBC-BF59-4C18-B81C-(E-Mail Removed)...
> 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

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


"Duane Hookom" wrote:

> 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.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "raypiscopo" <(E-Mail Removed)> wrote in message
> news:17324DBC-BF59-4C18-B81C-(E-Mail Removed)...
> > 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
>
>
>

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.

--
Duane Hookom
MS Access MVP


"raypiscopo" <(E-Mail Removed)> wrote in message
news:EBE24611-B93C-428D-8EE9-(E-Mail Removed)...
> 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
>
>
> "Duane Hookom" wrote:
>
>> 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.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "raypiscopo" <(E-Mail Removed)> wrote in message
>> news:17324DBC-BF59-4C18-B81C-(E-Mail Removed)...
>> > 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
>>
>>
>>