使用Access 2007 VBA创建数据透视图 [英] Pivot Chart Creation Using Access 2007 VBA

问题描述

OK在互联网上绝对没有好的文章，我可以找到解释或有关如何使用VBA创建数据透视图的代码示例。我需要这个，因为我需要透视表来显示不同的结果，取决于用户在表单中的选择。有一些为Excel，但语法是不同的Access。我知道这是一个跛脚问题，但如果任何人有一个例子，如何创建一个透视图在VBA我真的很感谢帮助。

OK there are absolutely no good articles on the internet that I can find that explain or have code examples on how to create a pivot chart using VBA. I need this because I need the pivot chart to show different results depending on user selection in a form. There are some for Excel but the syntax is different for Access. I know this is a lame question, but if anyone has an example of how to create a pivot chart in VBA I would really appreciate the help.

推荐答案

大约3天的搜索后，我想我找到了。不是任何人真正关心，这只有6次意见，说了很多VBA的完全可怕。无论如何，MSDN有这个隐藏在Office XP，而不是在Access下，但任何。

Well after about 3 days of searching I think I found it. Not that anyone really cares, this only has like 6 views, says a lot for VBA's utter horribleness. Anyway, MSDN had this hidden under "Office XP" instead of under Access, but whatever.

http://msdn.microsoft.com/en-us/library/aa662945.aspx#

这篇关于使用Access 2007 VBA创建数据透视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！