how to export binary data as image files

[caitlin]

Hi folks -

I've done a search on "long binary" on this site, but found mostly VBA suggestions for my problem, and honestly I don't know how to do anything in VBA.

Here's the situation - my employer has an ID-card-making database through which digital photos are added to student record data to create ID cards. The images are stored in an Access database as "long binary data". They would like for me to do one of two things:
1. Figure out how to make the images appear as photos on an Access form. Currently, a bound image control shows nothing, even if I know there is binary data in the field.
OR--
2. Figure out how to extract the binary data as separate images files, external to Access.

I know I may be asking the impossible, but is it at all plausible to do either of these things without writing VBA code? It scares me.

Thanks!!
-Caitlin

 

[nomad8169]

Hi caitlan,
I have a similar database that i have created that does what you are asking.My database form displays data and a photo pertaining to the data being displayed. Here is how i did this and i hope it helps you.If understand you correctly

Go to table that you are pulling informatio from and go into design mode.Add a field and choose its type as a OLE Object. and save, Go to Form and go to toolbox and pick Bound Frame Object and make your display area.Then click its properties and choose the field name you named it from the Table as the control source.

If you are trying to display a document that is text only then the document or text has to be scanned and put into a JPG or BMP file format before you can do the instructions above. Hope this helps Good Luck

 

[caitlin]

Thanks - I did try this method, and it doesn't work. The OLE field already exists ("Photo&quot. If I add Photo to a form, either as a bound object control or from the field list, it displays nothing. I have checked all the properties for something that would change the display, but to to avail...