Create an image in VBA

[aclelland]

Hiya,

I have been given a task to do which involves generating a graph
inside Access 2003 using VBA. I then have to output the image as a
jpg, gif or bmp.

I'm just in the early stage of planning this and I really have no idea
which direction to go in at the moment because I have never done any
image creation in VBA.

Any suggestions of tutorials, tools or modules which may help will be
appreciated

Thanks,
Alan

 

[Bob Hairgrove]

Hiya,

I have been given a task to do which involves generating a graph
inside Access 2003 using VBA. I then have to output the image as a
jpg, gif or bmp.

I'm just in the early stage of planning this and I really have no idea
which direction to go in at the moment because I have never done any
image creation in VBA.

Any suggestions of tutorials, tools or modules which may help will be
appreciated

Thanks,
Alan

VBA was not designed to do this kind of thing. However, there are ActiveXgraph
libraries you might be able to use. I don't know if any of these will save a
graph as a file, though. One good one (expensive, but very professional) is
called "Lead Tools" (or is it "Leed Tools"??)

At worst, it is always possible to use the native Windows GDI functions and file
creation API's to do it. But you need to know how to use them, and they can get
tricky, especially with the new Windows Vista.

 

[Stephen Lebans]

See the vbPictureBox class here:
www.lebans.com


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.