Jump to content
Software FX Community

Re: Missing methods in MS Access


User (Legacy)
 Share

Recommended Posts

Hi, I always use the following syntax with no trouble.

Steve

Dim objChart1 As ChartfxLib.ChartFX

Set objChart1 = Me.Chart1.Object

objChart1.OpenDataEx COD_VALUES, 2, COD_UNKNOWN

etc...

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

>

>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...