Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Image controls (2002)

    I'm hoping someone can point me in the right direction. Awhile back, I read a really good article or post on using image controls in reports. I thought I had saved it, but now I can find it or remember where I read it. Basically, you assigned a string stored in a table to the picture property of the control. It also gave several good reasons why to use the image control and string versus using an OLE Object. Any help would be greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Image controls (2002)

    The reason for not storing images in an OLE field is that this causes the database size to balloon. Access stores an uncompressed bitmap image of each picture. So say that you store 100 full color JPEG images of 640 by 480 pixels each; the JPEG files might be 100 KB on average. So that would be 100 * 100 = 10,000 KB or 10 MB. Not so bad, you'd think. But Access would store the 100 JPEGs plus 100 bitmaps of 640 * 480 * 24 bits = 900 KB each, so the total would be about 100 MB. <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>

    You will find a database that demonstrates how to handle images in forms and reports attached to <post#=296892>post 296892</post#>.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Image controls (2002)

    Thanks Hans, you're the man.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Image controls (2002)

    Hello again, Hans: I downloaded your sample database and tried to apply your example to a database of my own. Alas, I've hit a snag already.

    I can't get past the point where I insert a graphic control into my form. As soon as I insert the graphic control, Access immediately launches the Insert Picture dialog box. That says to me that Access thinks I'm trying to put a static photo into my form

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Image controls (2002)

    That's the way the image control wizard works. Stick anything in there for now. You can remove it after the control is created and the form saved.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •