How to extract OLE Object (Bitmap Image) to file system?

[deko]

I have a table that contains a bunch of pictures. When the user selects a
particular image in a form, I need a way to extract the selected bitmap
image (stored in an OLE Object table field) to the file system so the user
can do stuff with "somePicture.bmp", for example.

Is there an easy way to do this?

Thanks in advance.

[Larry Linson]

"deko" wrote

I need a way to extract the selected
bitmap image (stored in an OLE
Object table field) to the file system
so the user can do stuff with
"somePicture.bmp", for example.

There is an article in the Microsoft Knowledge Base at
http://support.microsoft.com/default...b;en-us;119395, entitled
"How to Extract the Metafile from an OLE Control" that may be of help.

Larry Linson
Microsoft Access MVP

[Stephen Lebans]

See:
http://www.lebans.com/oletodisk.htm
NEW - Apr. 14/2002 A2KExportOLEtoJPEG.zip A2K ONLY! This version
saves the entire contents of a table containing OLE Object Images to
disk based Jpeg files. User selectable compression rate. Version 1.5

Use the A2KExportOLEtoJpeg above instead of these following older
versions!

SaveOLEtoBitmap.zip is a database containing functions to allow you to
save the contents of an OLE Field to a disk based Bitmap file.

SaveOLEtoBitmapAuto.zip is a database containing functions to allow you
to save the contents of an OLE Field to a disk based Bitmap file for the
entire table automatically.

NEW - Apr. 11/2000 This first version only supports Bitmap files.
Metafile support will be included in the next release. USe the
A2KExportOLEtoJpeg above instead of this older version!

SavePictureDataBitmap is a database containing functions to allow you to
save the contents of an Access Image control a disk based Bitmap file.
Specifically it creates a Bitmap file from the PictureData Property.

Updated - July 25/2000 This first version only supports Bitmap files.
Metafile support will be included in the next release. Now supports
saving of Form's Background picture to a disk based Bitmap file.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"deko" <de**@nospam.com> wrote in message
news:xl**************@newssvr21.news.prodigy.com.. .

I have a table that contains a bunch of pictures. When the user selects a particular image in a form, I need a way to extract the selected bitmap image (stored in an OLE Object table field) to the file system so the user can do stuff with "somePicture.bmp", for example.

Is there an easy way to do this?

Thanks in advance.