Inserting Picture in Table for Form

  • Thread starter Thread starter Frank Wagner
  • Start date Start date
F

Frank Wagner

I am creating a form that will make use of various graphic images (Line
Drawings) that I hope to create using some program such as Daw. I have added
an OLE field to the table, and included it as the data for a control that
takes up about half the screen on a form. When I open the form all I get are
two litttle boxes in the upper right hand corner of the control, and when I
click on the control, it says the text is too large to be edited.

This is the first time I have done anything like this. I am using Access
2000, and am fairly familiar with VBA if any coding is needed. Do I have to
reduce the image size? If so how do I do that with Daw? Is there something
other than Daw that I should be using?

Any help would be appreciated.

Frank Wagner
 
In order to display a bound OLE object you need a registered OLE server that
is associated with the filetype. I should also mention that storing images
in a database causes bloat at least to the file-size of the image, but can
be much larger. I suggest, storing a path to that image on your hard drive
in your table, and using an Image control in you form to display it. A
sample database that does just that and also allows you to collect and store
the paths is available at:

http://www.datastrat.com/Download/Picture2K.zip
 
Thanks. I appreciate your comments regarding bloating the database.

With regard to showing the pictures, I ended up using auto form to create a
form over the table that had the picture imbedded. It automatically created
the type of control that was needed to show the picture.

Thanks again
 
Back
Top