Solved

Chart displays sample data

Posted on 2002-07-18
4
263 Views
Last Modified: 2008-02-26
I am trying to create a chart on a form in Access.  This morning I was able to do it. Now the query that I used to create this chart has changed and there is an additional category to chart.

I tried starting from scratch with a new report, and I still keep getting the sample data. When I review the report in print preview, it has the correct data. However when I try to open or edit the object from design view, all I get is the sample data. I need to make changes in the colors, text size so I need the real data.

I also saved the report several times and closed and reopened Access without any luck.

Anybody know what is going on and how to fix this?
I am using Access 2000.

Nancy
0
Comment
Question by:NancyCope
4 Comments
 
LVL 5

Expert Comment

by:funke
ID: 7163392
ACC: Microsoft Graph Always Shows Sample Data in Design View
PSS ID Number: Q154454
Article last modified on 11-18-1998

7.0 97
WINDOWS
======================================================================
---------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Access versions 7.0, 97
---------------------------------------------------------------------

SYMPTOMS
========

Moderate: Requires basic macro, coding, and interoperability skills.

After you insert a Microsoft Graph object into a Microsoft Access form or
report, the graph object always displays sample data in Design view. This
occurs even if you have opened the form or report, and the graph object
correctly displays the actual data in Form view or Print Preview.

RESOLUTION
==========

The resolution to this problem depends upon whether you are using the graph
in a form or a report.

Form
----

To update the form's Design view with the graph's actual data, you must
activate Microsoft Graph while the actual data is being charted in Form
view. To view actual data in the chart in Design view of the form, follow
these steps:

 1. Create the graph on the form.

 2. Set the graph's Enabled property to Yes and Locked property to No.

 3. Close and save the form.

 4. Open the form in Form view.

 5. Click the Graph object so it has the focus.

 6. On the Edit menu, point to Chart Object and then click Open to start
    Microsoft Graph.

 7. Note that Microsoft Graph displays the actual data.

 8. On the File menu, click Update.

 9. On the File menu, click Exit & Return to <FormName> (where <FormName>
    is the name of your form).

10. Close the form.

11. Open the form in Design view. Note that the sample data has been
    replaced by the actual data.

Report
------

Because Microsoft Graph objects cannot be activated during print preview,
there is no way to directly update reports with the actual charted data. In
order to see the actual charted data in Design view of reports, you must first
create the graph in a form, follow the previous steps in the "Form" section to
view the actual data in the form, and then copy and paste the updated graph
object into your report.

NOTE: The actual charted data shown in Design view of reports is static.
Reports cannot automatically update graphs in Design view as forms can.
each time you want to see the latest charted data in Design view of the
report you must follow the steps in the "Form" section and then copy and
paste the updated graph object into your report.

STATUS
======

Microsoft has confirmed this to be a problem in Microsoft Access 7.0
and 97.

MORE INFORMATION
================

Steps to Reproduce Problem
--------------------------

 1. Open the sample database Northwind.mdb.

 2. Open a new, blank form in Design view.

 3. Start the Chart Wizard by clicking Chart on the Insert menu.

 4. Click the Orders table, and then click Next.

 5. Add the EmployeeID and Freight fields to the Fields for Chart box, and
    then click Finish.

 6. Note that a new graph with sample data displays in Design view.

 7. Open the form in Form view and note that the graph displays the actual
    data instead of the sample data.

 8. Save and close the form.

 9. Open the form in Design view.

10. Note that the graph object displays the original sample data, instead
    of the actual data.

Additional query words:

======================================================================
Keywords          : FmrHowto IntpGrph kbinterop
Version           : 7.0 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbbug
=============================================================================
Copyright Microsoft Corporation 1998.
-------------------------------------
0
 
LVL 1

Author Comment

by:NancyCope
ID: 7163616
THis solution is for Access 7 and Access 97. I am using Access 2000.  I also had a graph working on a report earlier today. The problem started when I changed the query that the graph used. I can still go back to the previously saved database and view this graph. I can also delete the graph from the report and insert a new one, select the query and the data is displayed correctly.

I did notice that I had also created a form with a graph that uses the same query. But I did not copy and paste the graph object.

Nancy
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7281494

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 7315390
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
Administrator @ EE
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now