Solved

Pivot table and Chart fails to refresh in Microsoft Access 2003 form

Posted on 2007-03-20
4
1,684 Views
Last Modified: 2013-11-28
How do I refresh a access pivot chart and pivot table on the same form by vba?
I have an access 2003 form which contains a series of combo boxes allowing a user to filter the data they would like viewed in a graph and pivot table for analysis.  I have tried a requery command through vba to have the chart and table refresh, it fails to do so. Can someone give me a hand with this.
0
Comment
Question by:nzbeaston
4 Comments
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 18762070
Whether the requery works or not often depends on the timing (event) and the object reference used for the object that the requery method is executed for. Also, assumed that the pivot table and chart are just on a form, and not on a subform, correct?  You did not post your code, so it is difficult for any expert to help you. .
0
 

Author Comment

by:nzbeaston
ID: 18797526
Thanks for the feedback. Sorry about the delay I have been away.

I've managed to correct the problem which was a piece of code looking at the wrong control.  I had a unbound combo box called "Contractor", the pivot table embedded in the form was looking at the Contractor ID as the Link child and parent fields. As the whole form had an underlying record source of a Contractor Table - the pivot would only update when I moved to the next record. I was attempting to move to the next record through the unbound control which is what I wanted. Once I updated the link child and parent fields to the unbound control and used the requery command the pivot chart and table would refresh. Thanks for your opinion and I will post better code next time.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 21130191
PAQed with points refunded (50)

Computer101
EE Admin
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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

760 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

18 Experts available now in Live!

Get 1:1 Help Now