Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    14

    Question Unanswered: Access 2002: Add image to DB & display in form

    Hey all,

    Hope someone can really help me on this one.

    My daughter has begun to collect coins. She wants me to create a way of logging her coins with a photo.

    I have tried to add a OLE to a field in a table, but when I created a form from the table using the wizard it always shows a image filename and not an image.

    Please can someone talk me through the way to make this work?

    Thanks all,

    Lensmeister.
    Access 2002 :: Windows XP (Home) :: Visual Basic 6 :: Excel 2003 ::

  2. #2
    Join Date
    May 2010
    Posts
    601
    I would recommend NOT using the OLE. You will find that it will quickly bloat your database to the 2 gig limit.

    I find it best to store just the file path to the image.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    May 2009
    Posts
    14
    Thanks,

    If I have the image in a folder what do I use, hyperlink?
    Access 2002 :: Windows XP (Home) :: Visual Basic 6 :: Excel 2003 ::

  4. #4
    Join Date
    May 2010
    Posts
    601
    You can still view the image on the form.

    See:
    Picture in a Report
    Demonstrates a method of displaying a picture/image file in a report without storing the image in a table.
    Picture in Database
    Demonstrates a method of displaying a picture/image file in a database/form without storing the image in a table.
    You might also want ot check out this:
    Document Links
    This is a basic example of how to store the path to a file and also be able to view the file. You can browse using the standards windows common dialog to select the file. You can view the file using the application defined with the Windows File Associations. It uses the ShelExec API to open the file. It does not use the .Followhyperlink method.

    This example is a continuous form that could easily be used as a sub form to attach multiple documents to a record.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  5. #5
    Join Date
    May 2009
    Posts
    14
    Thanks Mate,

    I will have a play with it in the morning

    getting late here
    Access 2002 :: Windows XP (Home) :: Visual Basic 6 :: Excel 2003 ::

Posting Permissions

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