Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PivotChart Requery in VBA

Status
Not open for further replies.
itlee

itlee

Programmer
Feb 14, 2001
34
CH
I have a pivotchart form displaying data from a table that is updated periodically, but when the data is updated and I call requery on the form the chart is cleared!

Does anyone know how to requery the chart without losing the layout?

I have searched for over 2 hours on the net and cannot find an answer.

I have found references to pivottable.requery, but that returns a method not supported error. And I cannot put the form into design mode and then back to pivotchart view as this needs to be automated.

Thanks,
Lee.

itlee. MCP\Analyst\Programmer\SQL\.NET\VB\C#
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
451
Kennelbloke
Kennelbloke
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
371
PrimoSteve
PrimoSteve
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
208
Xavierparkash
Xavierparkash
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
399
Andrzejek
Andrzejek
Modex
  • Locked
  • Question
How to Close Desktop Application Windows using VBA
Replies
3
Views
195
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top