Re: JPG, OLE, Questions on how to best use images in ACCESS
- From: "Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@xxxxxxxxxxxx>
- Date: Tue, 24 May 2005 19:16:46 -0300
First you can export all of the embedded JPG images to disk. 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
To view Images stored in a folder you need to get the Filename of each
Image linked to a record.
Artvin has a solution here to do this:
http://www.datastrat.com/Download/Picture2K.zip
Place a TextBox control on your form and bind it to the field containing
the Image names. Add a standard Image control(NOT an OLE Frame control)
to your form. Then in the Current event of the Form, use the field now
containing the Image's name to load the JPG into the Image control.
Me.TheNameOfYourImageControl.Picture =
txtNameOfTextBoxControlBoundToImageNames
Take a few minutes to read the KB articles listed here:
http://www.mvps.org/access/forms/frm0030.htm
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Sissy" <sisnseatle@xxxxxxx> wrote in message
news:B5C8701A-62D0-46DC-9890-B3968AE23D0F@xxxxxxxxxxxxxxxx
> Hello,
> I have questions about using JPG's in an OLE Bound Frame in Access
2003.
>
> First off in my db table where my OLE images are set - some of the
pictures
> show Photoshop and the rest show MS Image Paint..... Why would 1/2 be
one
> program and the rest a different....????
>
> Secondly I have never had a problem inserting images before into my
OLE
> Frame - but now all of a sudden the images are coming up as the file
name and
> the image is not showing?????
>
> Now with reading all the posts - I have come to the conclusion that I
don't
> want to use a OLE to imbed my JPG's into my database records.... This
far I
> have gotten.
>
> BUT I want 1 jpg saved with each record so that it's all together...I
don't
> want a seperate database of the images...
>
> So perhaps I should say what I want to do - and someone tell me if it
is
> possible
>
> Save all my JPG's in a directory on my hard drive... NOT AN ACCESS
DATABASE
> - just a straight folder off the hard drive.
> and in each access record save the URL - or destination of where each
> picture is.... but have the image display when the record comes up. I
don't
> want to see just a path on my form.... I want ACCESS to go out and
search the
> path and view the picture when it finds it? IS THIS POSSIBLE?-- And
if
> this is possible - how is it done without clogging up the space....
>
> I have looked into a product called DBPix 2.0 which I am still trying
to
> understand how it works - my understanding is it imbedds the image but
it
> saves it in a manor that doesn't clog up the file...saves it at a
small size
> in raw binary form.
>
> My problem as it stands right now is I have a 1700 record database in
which
> I have OLE JPG's in place in about 1/2 of the database...I don't want
to
> start over re-inserting all those images.... So whatever I decide -
the
> biggest factor is how to handle all the existing embedded images...
>
> I hope someone can help me in laymans terms.......
> Sissy
.
- Follow-Ups:
- Re: JPG, OLE, Questions on how to best use images in ACCESS
- From: Tom Gettys
- Re: JPG, OLE, Questions on how to best use images in ACCESS
- References:
- Prev by Date: RE: Check Box Message
- Next by Date: Re: When you call a form in add, how to keep it from rolling to ne
- Previous by thread: JPG, OLE, Questions on how to best use images in ACCESS
- Next by thread: Re: JPG, OLE, Questions on how to best use images in ACCESS
- Index(es):
Relevant Pages
|
