Results 1 to 7 of 7

How to Link to Photos to each Record and Display in Report (Access 2010)

  1. #1
    giblets is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    21

    How to Link to Photos to each Record and Display in Report (Access 2010)

    How can I link multiple images from a folder on my drive to each record without making the database file huge?
    Each record is a plant species. I want to link to photos of flower, seed, etc. See attached database example.

    I would then like those images to appear on a report for each species. How would I go about doing this, if it is indeed possible? Thanks!
    Attached Thumbnails Attached Thumbnails examplereport.png  
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,852
    Store the image path\name in a text field in table. Use an Image control with ControlSource set to the field.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    giblets is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    21
    Quote Originally Posted by June7 View Post
    Store the image path\name in a text field in table. Use an Image control with ControlSource set to the field.
    I'm not quite sure how to "use an Image control." I inserted an image (just chose a random image from my desktop), then changed the Control Source field to the field with the file paths/names of images. However, no images appeared when I switched over to Report View. How do I "use an Image Control"?

    Thanks!

    Click image for larger version. 

Name:	ControlSource.png 
Views:	10 
Size:	14.8 KB 
ID:	11074

  4. #4
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,852
    What do you mean by 'inserted an image'? If you want to reference external image files, just save text string for the path\filename.

    You can either put the full path string in the text field:
    C:\Images\image1.jpg

    Then the ControlSource would be:
    =[fieldname]

    Or enter just the filename in the field and concatenate the path with the field name:
    ="C:\Images\" & [fieldname]

    Works for me.

    If you want to provide the database, I will test the setup.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    giblets is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    21
    I get the point about entering the file name for each record in the table, but when I go to the report, I'm not sure what I'm supposed to click to place an image next to each detailed record. See attached example database in my first post. The column "leaf" in the Plant Inventory would be an example of where I would place the file name.

    Thanks!

  6. #6
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,852
    Oh, did not see the zip link.

    I did these steps with your report.

    1. report in design view

    2. drag Image control from ribbon Design tab into Detail section (Cancel on the wizard to add image)

    3. set ControlSource, I used photobloom field

    4. enter data in field, I used a jpg from my folder

    It works.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  7. #7
    giblets is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    21
    Indeed it does! I think the problem I had was that I chose a random image instead of canceling the wizard to add an image. Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Link from report to record form
    By John2360 in forum Access
    Replies: 8
    Last Post: 08-13-2013, 12:29 PM
  2. Replies: 9
    Last Post: 05-07-2013, 07:37 PM
  3. Replies: 2
    Last Post: 12-26-2012, 12:58 PM
  4. Replies: 4
    Last Post: 05-18-2012, 11:42 AM
  5. Link a report to a record
    By prv in forum Reports
    Replies: 2
    Last Post: 12-14-2010, 10:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums