Re: Missing methods in MS Access

[Software FX]

Your ChartFX1 object seems to be wrong, check the name of your Chart FX

control in your form.

--

Frank

SFX

"Per Skjondal" <skjoenda@online.no> wrote in message

news:qzRnf9oGAHA.1920@sfxserver.softwarefx.com...

> Hi, I've added ChartFX 98 to an Access report and run the example code

from

> a SoftwareFX page:

>

> Dim MyDB As Database, MyTable As Recordset

>     Dim j, i As Integer

>

>     Set MyDB = DBEngine.Workspaces(0).Databases(0)

>     Set MyTable = MyDB.OpenRecordset("SELECT DISTINCTROW Graph.* FROM

> GrapfTable", DB_OPEN_SNAPSHOT)   ' Open table.

>

>     ChartFX1.Visible = False

>     ChartFX1.OpenDataEx COD_VALUES, 2, COD_UNKNOWN

>     MyTable.MoveFirst   ' Locate first record.

>     j = 0

>     Do Until MyTable.EOF    ' Begin loop.

>         For i = 0 To 1 ' 2 Numeric Fields to pot

>             If Not IsNull(MyTable.Fields(i).Value) Then

>                 ChartFX1.ValueEx(i, j) = MyTable.Fields(i).Value

>             Else

>                 ChartFX1.ValueEx(i, j) = CHART_HIDDEN

>             End If

>         Next i

>         ' X-Axis labels

>         ChartFX1.Legend(j) = MyTable.Fields(2).Value

>

>         MyTable.MoveNext    ' Locate next record.

>         j = j + 1

>     Loop                    ' End of loop.

>     MyTable.Close           ' Close table.

>     Chart1.CloseData COD_VALUES

>

> MS Access gives me a "Method does not exist" message on the OpenDataEx and

> ValueX methods.

> What can be the problem?

>

> Per Skjondal

> skjoenda@onlne.no

>

>