PC Review Forums Software Windows XP & Applications Access 2000 pivot table not refreshing data

Reply
 
Thread Tools Rate Thread
Old 03-04-2008, 12:35 AM   #1
Hiranthi
Junior Member
 
Join Date: Apr 2008
Posts: 1
Trader Rating: (0)
Default Access 2000 pivot table not refreshing data
Hi

I have a pivot table that was created in office 97. I converted the database to office 2002.

The pivot table does not refresh based on the new data. Pleas help.

OLE Class - Microsoft Excel 2000

Row Source - MyAnalysisReportsQuery

OLE type - Embedded

OLE type allowed - Embedded

Class Excel.Sheet.8

Code

stDocName = "MyAnalysisReportsQuery"

If MyQB.CreateNewQuery("Analysis Reports Selection Form", stDocName, False, strSQL) Then

SysCmd acSysCmdSetStatus, "Data has been retrieved from your server"

Me.PivotTableTab.Visible = True

Me.Repaint

Me.PivotTable.Refresh

Me.PivotTableTab.SetFocus

Me!PivotTable.Verb = acOLEVerbOpen

Me!PivotTable.Action = acOLEActivate

Me!PivotTable.ActiveData

Me.Clear_All.SetFocus

Me.PivotTableTab.Visible = False

Else

msgbox "There are no records with the criteria you have specified."

End If

Thanks inadvance.

Hiranthi is offline   Reply With Quote
Old 03-04-2008, 05:27 PM   #2
pseudorandom
Junior Member
 
pseudorandom's Avatar
 
Join Date: Apr 2008
Posts: 4
Trader Rating: (0)
Default
One thing I've found when migrating between different versions of Access is the VB references to be unchecked. In your VB editor locate Tools, references. If theres something either Missing or not ticked that should be ticked then you've found your problem.
pseudorandom is offline   Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off