May 16 2012, 09:43 AM
Someone please help me. I'm about to pull out my hair. I've spent 10 hours trying to get this pivotchart to work in my access database. As soon as I drag a field (any field) into any of the drop zones, the chart goes blank and I lose the rest of my drop zones. I have created a second very basic table to test with and it does the same thing. I tried on a laptop that is running 32 bit windows 7 and it works. I have scoured the internet, I have uninstalled office in selective startup mode and reinstalled it to no avail... No one can help me. I am near tears, and nearing my deadline. To top it off, this database has to work on 10 different laptops--some have XP, some have 64 bit 7 and others have 32 bit 7, my confidence that this will work has plummeted. I've used an access database for the last 4 years for this same purpose but 2010 has been a nightmare! I've also created a report and added a chart that way, so if anyone can tell me how to edit the legend in design mode I will also take that as a solution. I really would hate to start throwing computers across the room...
-Desperate in the Lower Level
May 17 2012, 05:01 PM
Have you tried finishing the development in a 32 bit environment and then open it in the 64 bit environment to see its behavior there?
May 17 2012, 05:16 PM
I had a problem very recently with Access x64 in which I couldn't even view Pivot Charts.
The solution was to uninstall office, CLEAN the computer (used CCleaner, TuneUp, and Norton 360 because no one cleans complete the registry by itself)
and then reinstall it.
It works smoothly now.
I wonder if that has something to do with any update.
Hopefully that works.
If don't, find another computer to finish your project.
Also keep in mind that you cant compile (accde) your code if it is intended to run in other machines with different versions of Access.
May 18 2012, 02:12 PM
I've tested one chart that I created on the 32 bit machine on the 64 bit machine and it came up blank. It did have my fields in the legend though. Fortunately everyone will be using Access 2010, but I'm concerned because I will only physically have half of the computers to test with before this database needs to go live. What if they have registry issues as well? That seems to be what I'm hearing though--that it's the registry. If it helps, when I try a pivottable I get two errors: 1. The query could not be processed: o Database already exists. and 2. The query could not be processed: o The data provider didn't supply any further error information. My query is just taking the averages of a group of data. It works on the other laptop so I don't think there is anything wrong with it.
May 18 2012, 03:26 PM
Do those 64 bit machines also run the 64 bit version of Office (Access) ?
If so, try down-grading the 64 bit version of Office by uninstalling it and installing the 32 bit version.
Otherwise, you may need to approach it as hthomas suggested.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here