Hi John, thanks for helping. Well yes, it's true, although amazing. When I hit the save button while being in the form's PivotTable or PivotChart view (NOT design view) I loose everything accept for the data source. When in design view its OK to hit save but I don't see the actual PivotTable or Chart. My practice is to save the SQL code of the query as a form's (a PivotTable or Chart form in this case) data source and not the corresponding Access query itself. As I said I tried it on different PCs and it's all the same. I've to mention that I've installed the latest JetEngine and I run Access 2002.
The problem is that the same happens (loosing ALL settings and getting an empty PivotTable -mostly- or Chart) even if I haven't hit 'save'. Just by opening the PivotTable or Chart on another instance. Thanks for your help, Theodore --- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote: > > Theodore- > > Pivot Tables and Pivot Charts resize themselves (and often change scale) > depending on the size of the window they're in - which can explain why one > looks different when opened as a subform. Users can also mess with them, > and any changes the user makes gets saved. But I've never heard of a pivot > table or chart losing all its setting just because you save it. You might > try for the same result using an embedded Excel pivot table or chart - which > is different and more stable code. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of tyki9799 > Sent: Tuesday, November 15, 2005 10:26 AM > To: ms_access@yahoogroups.com > Subject: [ms_access] Trouble with pivot tables and charts > > Hi to all! > > I got a major problem with pivot PivotCharts and mostly PivotTables (forms > viewed as pivot tables and pivot charts). It really drives mad! > > I apply some settings such as dragging fields to drop areas, show/hide > details, field captions, show/hide details, expanded/collapsed views etc. > > If I dare hitting the save button, disaster strikes! All settings are called > of (disappeared)! Even the drop areas are now empty of fields (especially > concidering PivotTables. > > Other times when the PivotTable or PivotChart is in fact a subform, I get > another view when I just open the PivotTable/Chart subform stand alone and > another when I open the same subform inside its parent form. > > If I don't hit save, sometimes they first look OK but later on I come to > find an empty table or chart. The same has happened in the past but lately > it's all gone crazy. > > It seems there no logic in it at all. They act as they wish! I checked the > database on other PCs and its the same! But as I told this happens all the > time. > > Is there a solution to this madness? > > Thanks, Theodore > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most > low income households are not online. Help bridge the digital divide today! > http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM > --------------------------------------------------------------------~-> > > > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/