Re: Load Picture from MS Access to VB6
- From: "The Merg" <howard_mergler@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 30 Nov 2005 14:13:50 -0500
Well, I figured it out I think. My problem was stemming from the fact that I
loaded images into the database directly through Access (so that I could
have some initial data to play with). When I inserted the image into Access
that way, it stored it as a Microsoft Photo v3.0 object. When VB was trying
to pull that object into the ImageBox, it failed of course. As soon as I
removed all the images from Access and then loaded images onto my form and
had VB save them to the database, everything started working fine.
Of course, now the issue is that graphics are very large when stored in an
Access database, but I guess I'll have to live with that.
Thanks for your help. Your message caused me to look at things from the
Access end where the issue was actually caused from.
As far as how I'm displaying the pictures in VB--pretty simple. I have an
ImageBox inside a PictureBox. The ImageBox is connected to a DAO object with
it's DataField property pointing to the Photo (OLE Object) field in the
Access database. No code used for the retrieval or saving. I only have code
to help resize the photo once it's been retrieved. If you want that I can
post it for you (although I stole it from this newsgroup to begin with).
- The Merg
--
Today's problems don't worry me,
I haven't solved yesterday's yet.
"Paul Clement" <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx> wrote in message
news:17qro1djp5hsdnloe35khtruot3m4nsdo1@xxxxxxxxxx
> On Wed, 30 Nov 2005 12:01:36 -0500, "The Merg"
> <howard_mergler@xxxxxxxxxxxxxxxxxx> wrote:
>
> ¤ I have the field that the pictures are stored in defined as an OLE
> Object.
> ¤
>
> Ouch. Unless the image was stored as binary (w/o the OLE header) you would
> need to use the OLE
> Object control. The alternative is to extract the binary data, strip the
> OLE header and write the
> data out to a file that can then be loaded in the PictureBox or Image
> control. AFAIK you can't bind
> a PictureBox or Image control directly to an OLE Object field in the
> database.
>
> So how are you currently displaying the image (from the database) into a
> PictureBox or Image
> control? If might help if we could see some of the code you are using.
>
> ¤ In VB, I have an image box inside of a picture box. I used some code
> that
> ¤ someone suggested on this newsgroup for resetting the size of the
> picture to
> ¤ the size of the image box. The image box is then linked to the
> appropriate
> ¤ field in the Access database. The image resize function is actually only
> ¤ exectued when the image box is double-click, so that should not be
> affecting
> ¤ anything. Any ideas would be appreciated? If you need anymore
> information,
> ¤ just let me know.
> ¤
> ¤ When you load your pictures into the PictureBox, do they resize
> themselves
> ¤ to the size of the PictureBox? That's really the only operation I need
> ¤ performed on the picture.
>
> If I remember correctly the PictureBox does not resize the image
> automatically. Only the Image
> control will resize the picture if the Stretch property is set to True.
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
.
- Follow-Ups:
- Re: Load Picture from MS Access to VB6
- From: Paul Clement
- Re: Load Picture from MS Access to VB6
- References:
- Re: Load Picture from MS Access to VB6
- From: Paul Clement
- Re: Load Picture from MS Access to VB6
- From: The Merg
- Re: Load Picture from MS Access to VB6
- From: Paul Clement
- Re: Load Picture from MS Access to VB6
- Prev by Date: Re: need proof???
- Next by Date: Re: ascii code for special characters
- Previous by thread: Re: Load Picture from MS Access to VB6
- Next by thread: Re: Load Picture from MS Access to VB6
- Index(es):
Relevant Pages
|
