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

查看:174
本文介绍了透视图表创建使用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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆