Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pictures (2000 sp3)

    Please don't yell yet as I know this is inefficient but it also doesn't work.
    I am cleaning up and simplifying a very complex database whose complexity is not helped by its total lack of normalisation. (started a long rant about the normalisation here but not the current problem so wont bore you with it)
    Each product type has an associated picture, stored on the hard drive in gif format - (Note I have no control over these and had to download some 200 of them from the net at very slow speed
    In the old version of the database, I had an OLE field called Diagram and I had managed to put the gifs in there for the appropriate product type. These showed up in the Table as MSPhotoEd.3 but when I viewed them in a form or report, I saw the actual diagram for the particular product. Exactly what I wanted! Except I cant remeber how I did it
    When I try to insert these same gifs into the clean version of the database,(which also has an OLE field called Diagram), the Diagram field shows Packager and when I try to see the actual gif in a form or report, I get just the icon. I used Insert ..Object..from file and chose the appropriate Gif file to put the picture in the field
    I know it is horribly inefficient to store a picture in a table but please tell me how I can achieve what I want : Have a diagram (gif format) associated with a product and have it appear on forms and reports in final form rather than as a link or icon.
    PS the database needs to be complete in itself ie I need to be able to move it to a different machine and have all the gifs still viewable within the database. Database size and efficiency are a secondary issue here
    PPS I even tried copying and pasting the original MSPhotEd.3 files from the old table but I get a message that the OLE Server isnt registered and it should be re-installed - I dont even understand the error, let alone know how to respond to it. The gifs in the old table are working like a charm by the way, available in forms and reports. However they are incomplete and the whole database has changed so much, so I cannot continue to use them
    TIA
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

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

    Re: Pictures (2000 sp3)

    Things you can try:
    - Reinstall MS Paint (from your Windows CD)
    - Associate .gif files with MS Photo Editor (Tools | Folder Options..., File Types tab in Windows Explorer.)
    - Perform a repair installation of Access/Office, in particular the graphics filters (no need to reinstall Office as a whole)

    Be careful with the scroll wheel when editing your profile - you ended up in Bosnia and Hercegowina <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pictures (2000 sp3)

    Thanks Hans (yet again) - ps thanks for heads up on Bosnia
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pictures (2000 sp3)

    Hans you're a genius - too bad you're not in Oz or I'd shout you a beer.
    As Willie Nelson (I think) sang, "Dont let your sons grow up to be cowboys or to play with your graphics fileassociations on your computer"
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  5. #5
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pictures (2000 sp3)

    This also applies to Fathers who know enough about computers to make them dangerous

Posting Permissions

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