Jump to content
Software FX Community

Missing methods in MS Access

User (Legacy)

Recommended Posts

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


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


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


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.

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.


  • Create New...