Solved

Chart displays sample data

Posted on 2002-07-18
4
276 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

730 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