Charts Erroneously Showing Design Data

[Wayne]

I have posted this problem a couple of times over the last few years
but have been unable to find a solution that works. Sometimes charts
in reports will display showing the design data instead of the actual
query data the first time they are opened. If the report is closed and
reopened the correct data is shown. This seems to be a nasty Access
bug that has carried across the last few versions at least.

One post that I saw on the subject suggested that the issue was one of
timing and suggested adding the following to the report code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error Resume Next
Call TestProc
End Sub

The called procedure is:

Function TestProc()
Dim i As Integer
For i = 1 To 15
DoEvents
Next i
End Function
Problem is, it doesn't actually work. This issue has risen its head on
several databases that I have written and I am still to see a solution
that works.

Any help or ideas would be greatly appreciated.

[Thelma Lubkin]

Wayne <cq*******@volcanomail.com> wrote:
: I have posted this problem a couple of times over the last few years
: but have been unable to find a solution that works. Sometimes charts
: in reports will display showing the design data instead of the actual
: query data the first time they are opened. If the report is closed and
: reopened the correct data is shown. This seems to be a nasty Access
: bug that has carried across the last few versions at least.

I have never written nor looked at the structure of a report, so
if this makes no sense, that's my excuse...

Can you have the query return one extra value whose sole purpose
is to be different from that variable's value in the design data?

If the TestProc below knows the design data's value for this
it could close and reopen automatically. I don't know whether the
calling procedure you show is the correct place to put this.
--thelma

: One post that I saw on the subject suggested that the issue was one of
: timing and suggested adding the following to the report code:

: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
: On Error Resume Next
: Call TestProc
: End Sub

: The called procedure is:

: Function TestProc()
: Dim i As Integer
: For i = 1 To 15
: DoEvents
: Next i
: End Function
: Problem is, it doesn't actually work. This issue has risen its head on
: several databases that I have written and I am still to see a solution
: that works.

: Any help or ideas would be greatly appreciated.

[Br]

Wayne wrote:

I have posted this problem a couple of times over the last few years
but have been unable to find a solution that works. Sometimes charts
in reports will display showing the design data instead of the actual
query data the first time they are opened. If the report is closed
and reopened the correct data is shown. This seems to be a nasty
Access bug that has carried across the last few versions at least.

One post that I saw on the subject suggested that the issue was one of
timing and suggested adding the following to the report code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error Resume Next
Call TestProc
End Sub

The called procedure is:

Function TestProc()
Dim i As Integer
For i = 1 To 15
DoEvents
Next i
End Function
Problem is, it doesn't actually work. This issue has risen its head
on several databases that I have written and I am still to see a
solution that works.

Any help or ideas would be greatly appreciated.

I haven't encountered this and Ive done a fair bit of charting in Access.

Have you tried changing where the chart appears in the report? (eg. try
putting it in the header or something?).
--
regards,

Br@dley

[Wayne]

Br@dley, I'm not sure why you have suggested this, but I gave placing
the chart in the report's header a try, but to no avail. About every
10th time I open the chart it displays the design data or it displays
no data if the design data has been removed. This is driving me nuts!

[Tim Marshall]

Wayne wrote:

I have posted this problem a couple of times over the last few years
but have been unable to find a solution that works. Sometimes charts
in reports will display showing the design data instead of the actual
query data the first time they are opened. If the report is closed and
reopened the correct data is shown. This seems to be a nasty Access
bug that has carried across the last few versions at least.

HI Wayne,

I may have posted this years ago when I was heavily involved with
charts, but I've found a behaviour that is somewhat similar and seems to
be related to the MS Chart object rather than Access. My exerience has
been that several charts in MS Word (I have an app that generates single
charts and I and some users copy and paste these into Word for various
reports and briefs) would often, when printing, print the same chart 5
or 6 times instead of 5 or 6 different charts. This would occur even
when the print preview clearly showed the 5 or 6 different charts.
Turning off Word and restarting it would cause a saved document to print
correctly.

NO it's not quite the same as what you've described but I think it's
somewhat similar. This happened with Access 97 and the MS Chart version
that came with it (8, I think). I never came up with a solution to it
and had live with it. 8(
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto