Anyone ever used the Chart Export database that lets you export your charts to jpeg files? Well, I use it's code quite a bit in my applications and I've run into some snags. I've edited my code to be in a central database that I reference all the databases that use this export feature to. So it's somewhat universal and the user sets a global variable to his object (Chart) each time the function of exporting to a file or email is called. It's pretty neat. You can get the original version here.
If you want the module I created that works with the code in tihs database, just ask. I'll post it in this thread.
My problem is this:
I set the object being exported to stretch so that I have a good looking jpeg (full size), and that it doesn't clip the images - it only will export what's in the immediate window. Well, my exported jpeg file looks good... but the labels somehow get shortened by Access if they are too long (IE: '15 Passenger Vans' becomes '15 Passeng...', which is OK... But if anyone knows how to change this, that'd be nice.
Second problem, we all love to link data from our forms into our Graphs. Ie: if the chart is built from a query and the query gets values from our form that we input manually, we enjoy placing those values ON the chart so that the user has some clue as to what he/she has just graphed, right? Well none of the linkd values get exported with the chart. JUST the actual chart itself. If you have any idea how to export the Graph in it's entirety, that'd be nice. Bear in mind that the code can't be too complex since it is linked from a universal database and is called by about 40 different graphs.
Thirdly, anyone have an alternative method of exporting graphs to files?
Thanks everyone.
-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------
If you want the module I created that works with the code in tihs database, just ask. I'll post it in this thread.
My problem is this:
I set the object being exported to stretch so that I have a good looking jpeg (full size), and that it doesn't clip the images - it only will export what's in the immediate window. Well, my exported jpeg file looks good... but the labels somehow get shortened by Access if they are too long (IE: '15 Passenger Vans' becomes '15 Passeng...', which is OK... But if anyone knows how to change this, that'd be nice.
Second problem, we all love to link data from our forms into our Graphs. Ie: if the chart is built from a query and the query gets values from our form that we input manually, we enjoy placing those values ON the chart so that the user has some clue as to what he/she has just graphed, right? Well none of the linkd values get exported with the chart. JUST the actual chart itself. If you have any idea how to export the Graph in it's entirety, that'd be nice. Bear in mind that the code can't be too complex since it is linked from a universal database and is called by about 40 different graphs.
Thirdly, anyone have an alternative method of exporting graphs to files?
Thanks everyone.
-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------