Confused on Microsoft Graph Chart

[jamez05]

Hi,

I'm using Access 2003. There is a button that has an on click event that populates the following tables:

tblProbabilityPlot
tblProbabilityPlot_A
tblProbabilityPlot_B

Once these are populated it opens a form that graphs the information. This form uses OLE CLASS Microsoft Graph Chart and its source comes from tblScale.

The confusing part is that tblScale does not get populated on the button's onclick proceedure or anywhere on the graph form. I'm complete lost. Does anyone have an idea about how to figure this out?

 

[SkipVought]

Hi,

Not a whole lot of helpfule information.

Change the source to one of the PLOT tables.

Where did tblScale come from?

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[jamez05]

Thanks for the response, I will get back once I analyze this some more. Not sure where anythings coming from (taking over a project - no documentation like usual).

 

[SkipVought]

Changing a horse in the middle of a stream, hmmmmmm.

I'd hunt a bit before tanking the chart source data link.

I'd want to know what sort of data was in tblScale.

What is it linked to?

"Scale" seems to indicate Axis-related data.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[jamez05]

Thanks again for the response.

tblScale has coordinate related data:
ID, Label, XLabel, YLabel.

May be on to something. The graph can plot up to 10 chemicals. (Looks like separate graphs that overlay each other, each chemical is in a different color) Each chemical has its own label. The label displays the chemical name on the graph form.

Found out the graph itself uses a datasheet. The datasheet has two columns: XLabel and YLabel. There must be a separate graph and datasheet for each label. Somehow the info between the probability tables and each datasheet and its label are linked. Slowly figuring it out.

 

[jamez05]

O.K, the vba code is writing to a text file and I have a hunch that this is what's used for the datasheet. I haven't seen anything like this before, if anyone can help me decifer what this is doing it would be greatly appreciated:

Open "test.txt" For Output As #1

' does some appending to - doing some looping
Write #1, i, fld.Name, strS

' then closes
 Close #1

Is there anyway to view test.txt?

 

[SkipVought]

Search for and open.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[jamez05]

Thanks, thinking I'll research the Microsoft Graph Chart class and try and recreate it. The file thing doesn't seam to make much sense.