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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top