E
Erik BZ
Hi
I'm trying to generate a PivotTable in an access form by using VBA.
The reason is that changes made to a pivot table access form are stored so a
user might mess up the report - and not be able to restore it. To prevent
that I would like to progammatically generate the PivotTable each time the
form are loaded.
I found this article on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_acprogpvt.asp
The problem is first of all that the library reference OWC10.dll is not to
be found on my machine. I'm using Access 2003 and would expect to find
OWC??.dll or someting but no. Second - The code seems to work if I don't
declare the variables and leave out the Option Explicit statment. However,
I'm no able to add totals to the pivot table.
Any ideas anyone..
Best Reg. Erik B
I'm trying to generate a PivotTable in an access form by using VBA.
The reason is that changes made to a pivot table access form are stored so a
user might mess up the report - and not be able to restore it. To prevent
that I would like to progammatically generate the PivotTable each time the
form are loaded.
I found this article on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_acprogpvt.asp
The problem is first of all that the library reference OWC10.dll is not to
be found on my machine. I'm using Access 2003 and would expect to find
OWC??.dll or someting but no. Second - The code seems to work if I don't
declare the variables and leave out the Option Explicit statment. However,
I'm no able to add totals to the pivot table.
Any ideas anyone..
Best Reg. Erik B