drawing functions in VBA?

R

rob

Hi,
I am looking for a way to print boxplots of Access data.
As far as I know, Excel doesn't have this capability, and
we're not happy with SPSS.

If necessary, I can build a custom tool. As far as I
know, VBA doesn't have any drawing functions, but maybe
VB.Net? Anyone have any suggestions?
 
M

Marshall Barton

rob said:
I am looking for a way to print boxplots of Access data.
As far as I know, Excel doesn't have this capability, and
we're not happy with SPSS.

If necessary, I can build a custom tool. As far as I
know, VBA doesn't have any drawing functions, but maybe
VB.Net? Anyone have any suggestions?
Click to expand...

Access reports have the Line, Circle, PSet and Print methods
that allow you to draw most anything on a report page.

For form's it's much more problematic, but take a look
around at www.lebans,com

Or were you asking about using a graph object?
 
S

Stephen Lebans

The vbPictureBox class on my site exposes a handle to a Device Context
so you can use the GDI API's directly on the standard Access Image
control. There are several exposed drawing methods, Line, Box, CIrcle
etc. to get you going.
http://www.lebans.com/imageclass.htm

--

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