Solved

Pivot tables from visual basic 6

Posted on 2004-09-03
4
497 Views
Last Modified: 2013-11-25
Hi,

I need to generate pivot tables for various queries which may involve different tables. I want to be able to bring up the pivot table view along with the Pivot Table Field List for a resulting set using visual basic 6.

Can you refere me to some examples.


Thanks
0
Comment
Question by:skyrise11
4 Comments
 
LVL 26

Expert Comment

by:Rejojohny
ID: 11987335
do u want to do this using the microsoft office component?
0
 

Author Comment

by:skyrise11
ID: 12049623

I wanted to bring up Pivot Table reports from VBA. But I got it. you simply set the default view of a form to PivotTable.

0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 12094586
Closed, 250 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Which Microsoft MSDN Package Is The One I need? 3 38
DIR issue 7 48
VBA color chart bars 12 67
VB error "Type mismatch" 2 43
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now