Adding images to records

[thalam]

Hi there,

I got myself pretty much backed into a corner here. I am trying to add images to records. For example, in my database there will be certificates scanned and put on each specific record. I have been searching high and low and found that the OLE object tool will allow me to do this. However, the only method I've found was to right click right in the table and selecting add object. I'm trying to find a more userfriendly method. I was hoping someone can point me in the right direction.

Thanks in advance!

 

[PercyPercy]

Inserting OLE Objects

I'm not an expert, but while you're waiting for the experts to reply, you could try this. This is how I've done it and it seems to work for me.

First thing though -- make sure you have a place to keep the graphics files on your server so the data base can "fetch" them when they are called for.

As you said, in your table design, add a field for your "picture" and make it an OLE Object.

THEN go to your table under data sheet view -- and "double click" in the blank line under that column. A window will pop up that will allow you to define a path -- much like attaching a file to an email. You'll have to do this for each graphic... but once they are there, you'll have them.

Don't know if this is clear or not -- but good luck! And of course, the experts will be giving you better guidance!

PercyPercy

 

[MStCyr]

The sample database that I posted a while back might be of some help to you.

http://www.access-programmers.co.uk/forums/showthread.php?t=108698

 

[The_Doc_Man]

There is a thing called an "IMAGE" control that allows you to include a picture of any of several types including .JPG, .TIF, and a few other popular ones. Note that the processor-helpers (actually, .DLL files) that do this are an option at installation, but Office allows you to re-install selected options without installing everything.

OK, look up help on the IMAGE control. There is a property of this control that is the pointer to the file you want to see. The way I have done this in the past is that I have a folder set aside for images. I load the image to the folder. I then put a field in my table so that my form can see a fully qualified file specification. In the form's OnCurrent routine, I load the file spec to the image control's appropriate property. You will have to play with the other properties to get the pix like you want them, but loading the file spec to the (is it .PICTURE?) property is the key. Oh, set it up as a LINKED picture because external picture files are the quickest way I know to create serious database bloat.