drawing circles and lines in a database field

[compmail]

In Windows XP Access (2003 I think) i collect electrical data on motors. I
want to be able to include in a field sketches or drawings of the terminal
box connections which includes usually six circles with lines crossing to
each and each line labelled a colour. Some of the data sheets will have a
larger drawing of connecting lines almost looking like a block of trellising
each line in a different colour. with text labls to each line. How can I do
this in a data bases field so that when I recall a brand name it ill bring up
its data (set out in many fields) along with the drawing diagram for that
brand name.

 

[pietlinden]

In Windows XP Access (2003 I think) i collect electrical data on motors.  I
want to be able to include in a field sketches or drawings of the terminal
box connections which includes usually six circles with lines crossing to
each and each line labelled a colour.  Some of the data sheets will have a
larger drawing of connecting lines almost looking like a block of trellising
each line in a different colour. with text labls to each line.  How canI do
this in a data bases field so that when I recall a brand name it ill bring up
its data (set out in many fields) along with the drawing diagram for that
brand name.

I would store a link to the drawing, and load that using LoadPicture
or similar. If you try to store images in your database, it will
bloat really quickly.

 

[compmail]

Thanks it will give it a shot tomorrow when I have more time. Based on this
would I be able to scan a picture and then use loadpicture from within the
field. That might be easier to draw out the connections, scan then then load
them in this manner. Its a lot of work to redraw them into the computer.
Thanks for your help

 

[pietlinden]

Thanks it will give it a shot tomorrow when I have more time.  Based onthis
would I be able to scan a picture and then use loadpicture from within the
field.  That might be easier to draw out the connections, scan then then load
them in this manner.  Its a lot of work to redraw them into the computer.
Thanks for your help

What I would probably do is use the FileOpen API from Access web...
www.mvps.org/access... it's the first article in the API section.
then you can prompt the user for the file and just store the path in
your database. Then use LoadPicture or whatever to view it.

 

[compmail]

Hi, thanks for your interest. I tried this on my computer and found I
actually had Access 2000 and couldn't find LoadPicture anywhere. Your
suggest to access FileOpen API from Access web seems a little too complicated
for me. I am an amatureat this stuff but have a good understanding of
setting up databases, except the 'advanced' stuff. My database that I want
to put on has the core information which will be set in separate fields. At
the bottom of the card is the sketches (or drawings) of the instructions to
go in the job. From your first info acess might not be the right program for
this, the database is large.
Any suggestions for an alternative programe. Like, like 3000 data cards all
with set tags, but variable information on each card and all with a drawing
or sketch at the bottom of it.
Thanks