Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Pivot chart graph disappeared after adding new record.

Posted on 2010-01-12
10
Medium Priority
?
554 Views
Last Modified: 2012-05-08
I created a pivot chart which was showing the graph fine with old records BUT when I added new record then run the form no chart is shown any more, I can only see the legend X any names.
0
Comment
  • 5
  • 4
9 Comments
 

Author Comment

by:Dr.Abdulwahab Al-anesi
ID: 26292485
Correction for the question:
I created a pivot chart which was showing the graph fine with old records BUT when I added new record then run the form no chart is shown any more, I can only see the legend X and Y names.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26292664
Access versions prior to 2007>Try to refresh your pivot chart by using the refresh command on the menu

Access 2007> PivotChart Tools | Design | Data | Refresh Pivot
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26292815
You can create a subroutine behind a button that programmatically builds a pivot chart view in a form and just click the button each time you want a "new" chart.
              See this link for instructions and code
                             http://support.microsoft.com/kb/304143
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

Author Comment

by:Dr.Abdulwahab Al-anesi
ID: 26292820
puppydogbubby:
It did not work even when I closed the database and opened it again.
 
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26292954
by did not work, do you mean did not refresh?
Is your pivot chart on a form? try placing the following code behind a button on the form:

Private Sub btnRefreshChart_Click()
Me.YourChartControl.Requery
End Sub
0
 

Author Comment

by:Dr.Abdulwahab Al-anesi
ID: 26292960
Do you think the reason is the Trojan virus attacked the data base
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26293147
No, what makes you think that?  Please provide more detailed information on how you set up your chart, the query that is the data source for your chart, and the version of Access you are using.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26293214
See also this link for a tutorial on how to design and build your PivotTable or PivotChart:
                             http://office.microsoft.com/en-us/access/HA010345801033.aspx
0
 

Accepted Solution

by:
Dr.Abdulwahab Al-anesi earned 0 total points
ID: 26295137
I found the problem was related to the lookup tables related  to the source record table, wen I imported copies of the table from old backed up data base the pivot worked normally I did no need to do any change in the pivot chart
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

577 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