[AccessD] A2k - Exporting a Graph Object

Carlos Alberto Alves caa at highway.com.br
Fri Oct 10 22:54:17 CDT 2003


On Fri, 10 Oct 2003 23:23:50 -0400, William Hindman 
<wdhindman at bellsouth.net> wrote:

> ...just a wag ...bmp is the native Access graphic filter ...the jpg 
> graphic
> filter is installed with the other office components and not native to
> Access ...thus trying to use the O97 jpg filter with A2K may be a 
> problem.
>
> William Hindman
> <http://www.freestateproject.org> - Do you want liberty in your lifetime?
>
>
> ----- Original Message ----- From: "Carlos Alberto Alves" 
> <caa at highway.com.br>
> To: "AccessD List" <accessd at databaseadvisors.com>
> Sent: Friday, October 10, 2003 11:15 PM
> Subject: [AccessD] A2k - Exporting a Graph Object
>
>
>> Dear Mates:
>> I’d like to have your opinion on this matter. An app of mine has a form
>> with a graph object based on a query. End-users want to export this 
>> graph
>> in order to use it in a PowerPoint slide; so it might be exported as 
>> .BMP,
>> .JPG, .GIF or .WMF. I tried the code below in a cmdbutton…
>>
>> Dim objGraph as object
>> Set objGraph = Me![Graph_Name].object
>> ObjGraph.Export “c:\temp\Graph_Name.JPG”
>> ‘objGraph.Action = acOLECopy
>> Set objGraph = Nothing
>>
>> Appropriate reference to MS Graph 9 has been set.
>> The Export method worked fine and the graph was correctly exported. The
>> Action method didn’t work at all. My real problem is that both methods
>> generate an error msg stating “OLE server must be re-installed” and 
>> Access
>> itself crashed. Using Ctrl+Alt+Del I found one (sometimes two or three)
>> instances (processes?) “Graph9” still opened. Another important
>> consideration is that end-users will work with Access 2000 but other
>> components of Office 97.

I will try .BMP format and let you know the outcome.
Thanks for your reply,
-- 
**************************************
* Carlos Alberto Alves               *
* Child Neurologist                  *
* Systems Analyst/Programmer         *
* Rio de Janeiro, Brazil             *
* mailto:caa at highway.com.br          *
**************************************


More information about the AccessD mailing list