Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bound Object Frame (Acess 2003)

    I have a database developed way back and one of the forms has a Bound Object Frame. I use Insert/Object/File to pop a different thumbnail photo into each record. It worked fine in Access 95 up to Access 2002 but not in Access 2003. In Access 2003 I can insert a Word, Excel, Powerpoint or Publisher file into the frame OK but whenever I try to insert an image file (gif,jpg,png,bmp,tif,pdf) all that comes up inside the frame is the name of the file.... if I am lucky. If it is not in the mood I just get an error dialog saying OLE is broken, restart it. And the only way to restart is apparently to reboot (is there some other way) but it doesn't fix the basic problem.
    I have-
    1.Unchecked script blocking and Office plugin in Norton Antivirus and anything remotely looking like script blocking in Zone Alarm Pro and in Outlook 2003 and in IE6.0 and rebooted. Reduced all security to just about zero.
    2.Checked file associations. I normally use Paintshop Pro for everything but have also tried the new Microsoft Picture Manager, Irfan, and MSPaint.
    3. Uninstalled Norton Antivirus and Paintshop Pro, tried the Insert function again without result, and reinstalled them.
    4. Done the Detect & Repair thing on Office 2003.
    5. Uninstalled all applications installed since I installed Office 2003.
    6. Restored all my disk drives from a Ghost backup of a week ago (but I backed just after I installed Office 2003 so can't go back to Office XP easily)
    7.Pulled my hair out.

    All with no result.

    Has anybody got any ideas?

    Roger

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bound Object Frame (Acess 2003)

    <P ID="edit" class=small>(Edited by D Willett on 03-Nov-03 12:00. Sample Attached)</P>Roger

    It seems that the original paint program you used way back in your different versions of Access is probably different to the one you use now.
    I think if you check in the underlying table, the field may contain the word "Package".

    If you're inserting a thumbnail to each record, you'll probably have problems later on with bloating.
    Hans recently addressed this problem and attached a demo which can be changed to
    suit another approach you may want to look at.

    It is better to store the filename only and pull the relevent image through the path instead of embedding in OLE.

    Using the .Picture property on the On_Current event of the form, you'll find this to be far more reliable and not bloat your application.
    Attached Files Attached Files

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

    Re: Bound Object Frame (Acess 2003)

    >> Hans recently ... attached a demo

    See <post#=296892>post 296892</post#> for this demo.

    (This is meant for Roger and others reading this)

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bound Object Frame (Acess 2003)

    Thanks but your demo appears to be a demo of setting up one image for a whole database rather than a Bound Object Frame that can record a different image for every record.
    Yes, indeed, when I manage to get a file name rather than an image come up in the frame the underlying database shows that record has a Package rather than Picture (as before) but what that means or how you fix it I don't know.
    I probably mislead you by talking about thumbnails... I meant a small sized photo, not an actual thumbnail, so bloat is not a
    problem.
    Not being a coder I don't understand your remark about .Picture property on the On-Current event of the form. I can't even find such an event!
    And no doubt I am using a different paint program, or different version of it, since I set up the the original but so what? If that makes a difference how do I fix it? I have uninstalled and reinstalled paintshop pro several times and using other paint programs, including MSPaint, makes no difference!

    Still at a loss

    Roger

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

    Re: Bound Object Frame (Acess 2003)

    The demo posted by Dave (which is essentially the same as the one I pointed to) uses an unbound image control to display a different picture for each record. The images are not stored in a table in the database itself but as separate image file; the table only stores the path and filename of the image files.

    See attached screenshot of the Properties window for the form. It shows the Event tab, with the On Current event at the top of the list. "[Event procedure]" inducates that there is VBA code for this event; you can view this code by clicking the Builder button (the three dots ...) to the right.

    The reason for not storing images in an Access database is that whatever the original format (.png, .jpg, ...), Access always stores an uncompressed bitmap image in the table. Say that you store 1,000 full-color thumbnails of 240 x 180 pixels, in .jpg format. Each .jpg is maybe 20 KB, so you'd expect a total of about 20 MB. But Access stores 1,000 bitmaps in addition to the .jpgs, adding a whopping 124 MB for a total of 144 MB worth of image data in the database!
    Attached Images Attached Images
    • File Type: png y.PNG (10.0 KB, 2 views)

  6. #6
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bound Object Frame (Acess 2003)

    Roger

    I really don't know whats going on in the background of your current OLE scenario, but just to comment again.
    By using the attached method, a single picture can be used for a single record.

    If you like, post some specs, ie the table definition for the OLE inserts
    and we'll see if we can provide a demo showing you how to achieve your goal.

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bound Object Frame (Acess 2003)

    Thank you for all your support but I finally got it worked out with Microsoft Support. I had to reinstall a minimal installation of OfficeXP, then install Microsoft Photo Editor from the OfficeXP CD (which is removed by Office 2003 along with all the rest of the OfficeXP application), then associate my jpg files with Photo Editor, test, and it all finally worked again (except the Insert /Object won't work if I associate jpgs or any other image file with any other Paint program!). Think that counts as a "bug" in Access 2003 doesn't it?

    Roger

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

    Re: Bound Object Frame (Acess 2003)

    That's the risk of being an early adopter. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    I think I'll stick with XP for a while, until the wrinkles have been ironed out... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

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