Access Access 2000 pivot table not refreshing data

Joined
Apr 3, 2008
Messages
1
Reaction score
0
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.

 
Joined
Apr 3, 2008
Messages
4
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top