William Hindman
wdhindman at bellsouth.net
Fri Oct 10 22:23:50 CDT 2003
...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. > TIA, > -- > ************************************** > * Carlos Alberto Alves * > * Child Neurologist * > * Systems Analyst/Programmer * > * Rio de Janeiro, Brazil * > * mailto:caa at highway.com.br * > ************************************** > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >