Inserting a JPEG object in a field

[Lana]

How do I insert a JPEG image into an OLE field. It just
seems to hang for me when I do the "insert object". Any
advice on how to do this or another more productive way
to manage photos with associated info would be helpful!

 

[mark]

First of all, you probably do not want to actually store
your jpegs in the db (really bloats the db size). What
you can do, however, is something similar to this:
- add a field or two to your table that references the
file path and file name of the appropriate jpeg;
- add an unbound image to your form;
- add code in the Current event for the form that grabs
the file path and file name as the source of the image.

Hope that helps.