473,480 Members | 1,884 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Data source for PivotTable-Form in ACCESS 2000

Hi, this drives me crazy,

4 years ago I defined in an ACCESS 2000 application a "PivotTable-Form". The

resulting EXCEL table inclusive the "Data refresh" works perfect. I now want

to update/change the query for the "Data Source" but cannot find which query

is behind the "PivotTable-Form" or behind the resulting EXCEL spreadsheet.

When editing the properties for the "PivotTable-Form" or the EXCEL

spreadsheet the "Data Source" is always blank.

Question: Where does Access 2000 or EXCEL 2000 hide the respective data

source (Query)??

Helmut
Apr 2 '07 #1
0 1440

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1501
by: spacecake | last post by:
I want to dynamicaly filter the members in my pivottable. Here you see how it's done the static way: pview.RowAxis.InsertFieldSet pview.FieldSets("manager) Set fld =...
0
1293
by: Michal Chmielus | last post by:
I wanna get from PivotTable control including in Microsoft Office XP Web Components such as recordset and manipulate that. Exactlly what I want is to have a simply function 1 to 1 that provides for...
0
1215
by: sal | last post by:
Can the pivottable.mdx property be changed on an excel pivot table? Can this be used as a datasource?
0
1645
by: Chrysan | last post by:
I have dragged a PivotTable(which id="PivotTable1") control on my page(Index.aspx). And, How do I reference this PivotTable control in my code-behind(index.aspx.vb)? Because I notice when I...
0
1065
by: Chrysan | last post by:
I have create an asp.net(.aspx) page, with a PivotTable control. I noticed that, I can't reference it in my code-behind(.aspx.vb), because it doesn't has the line 'Protected WithEvents PivotTable1...
0
1126
by: Jesus Carmona | last post by:
Good day everyone. Is there any way to create an Excel PivotTable from VB.NET? Any links on the Internet? TIA Jesus Carmona
9
1926
by: Ben R. | last post by:
Hi guys, I've got a DB table of timecards with these fields in the table: ID (Int) UserID (Int) DateWorked (DateTime) HoursWorkedOnThatDate (Double) I'd like to display a grid, with...
0
3103
by: BillE | last post by:
I am using Visual Studio 2005 to create a web site which includes reports. The web site has several sub-folders. When working with reports I can't get the website data sources (classes and...
2
1598
by: Tommaccoy | last post by:
I have a table in which a "short Date" is entered. When I make a pivot table out of this table I want just the Month be displayed. How can this be donne? PivotTable Person Date A ...
0
786
by: julianosoares | last post by:
Hi, I need create one relatioship between two tables in PivotTable. Someone can help me to do, or indicate some material for me. I´m using visual studio 2005 with microsoft office web component,...
0
7051
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6915
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7054
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
6993
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
4794
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3003
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
2993
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
567
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
193
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.