General discussion

Locked

Acc 97 doesn't Display Charts Correctly

By gary.wong ·
I am using Win 98 v2 with Access 97 with SR1 patch. I have developed a report with one graph 97 chart object on it. There is not Link Master Fields and LinkChild Fields properities in the chart object. The Access report prints correct at home.When I send this program to someone else, who is using Win 2000, Access 97 with SR2, the graph charts don't always display the correct results (I print a table show the same thing too just next to the graph). For example, their results may preview or print correctly for 2 or 3 times, and the next time the results are not correct on the graphs.

I am aware of a know problem with "Acc97: Graph 98 Chart Object Does Not Update Display Correctly" from Article I Q165836 of the knowledge base from Microsoft. I have not Link fields in the graph.

Do you have any suggestions on how I can get it to give consistent results

Your help is deeply appreciated.

Thanks,

Gary

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Acc 97 doesn't Display Charts Correctly

by Crowmoor In reply to Acc 97 doesn't Display Ch ...

I havn?t used the graph function before because i always dump the data to excel and makes an exceldokument with the graphs there(I have coded so that everything is made via code and a finished Exceldokument is ready. Then I mail it via docmd.sendobject to the person who should have it. Rather smooth)

Anyhow I have had the same problem using SP2 and often found out that I had to requery the page to get complete data. If you are using a recordset beware of the Recordset malfunction. Always runthis code before working on a recordset.

If not rst.BOF and not rst.EOF then
rst.Movelast
rst.Movefirst
Endif

That way you you could be sure that your recordset is filled before you start working on it.

Hope this help!

Jesper

Collapse -

Acc 97 doesn't Display Charts Correctly

by gary.wong In reply to Acc 97 doesn't Display Ch ...

The question was auto-closed by TechRepublic

Collapse -

Acc 97 doesn't Display Charts Correctly

by Crowmoor In reply to Acc 97 doesn't Display Ch ...

I havn?t used the graph function before because i always dump the data to excel and makes an exceldokument with the graphs there(I have coded so that everything is made via code and a finished Exceldokument is ready. Then I mail it via docmd.sendobject to the person who should have it. Rather smooth)

Anyhow I have had the same problem using SP2 and often found out that I had to requery the page to get complete data. If you are using a recordset beware of the Recordset malfunction. Always runthis code before working on a recordset.

If not rst.BOF and not rst.EOF then
rst.Movelast
rst.Movefirst
Endif

That way you you could be sure that your recordset is filled before you start working on it.

Hope this help!

Jesper

Collapse -

Acc 97 doesn't Display Charts Correctly

by gary.wong In reply to Acc 97 doesn't Display Ch ...

The question was auto-closed by TechRepublic

Collapse -

Acc 97 doesn't Display Charts Correctly

by gary.wong In reply to Acc 97 doesn't Display Ch ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums