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 * **************************************