透视图表创建使用Access 2007 VBA [英] Pivot Chart Creation Using Access 2007 VBA
问题描述
确定有绝对没有好文章在互联网上,我可以找到解释或者对如何创建使用VBA数据透视表code的例子。我需要这个,因为我需要的数据透视图,以显示不同的结果,具体取决于用户选择的一种形式。还有一些用于Excel,但语法是访问不同。我知道这是一个蹩脚的问题,但如果任何人有一个如何在VBA创建一个数据透视表一个例子,我真的会AP preciate的帮助。
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的完全horribleness。无论如何,MSDN有这个隐藏访问的Office XP的下代替,但不管。
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屋!