Results 1 to 3 of 3
  1. #1
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150

    Use images from a directory in a report


    Hello, I was wondering if you could help. I want to get images from a directory into a report. At present the idea is not store any information about the images in the database itself. The directory location is known and I want to use all images in that directory. Is that possible? I can do I in a form but have no idea how to start in the report. It's a little more complicated than that, I need the images to be grouped by file name, but if someone could suggest a starter solution, I can probably sort out the rest. Robyn

  2. #2
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    If the report's record source has the full path to the image files you can simply use those in the controlsource property of an image control. Or you can set the Picture property dynamically in the report_open event or some other one depending on your needs. Your requirement is a bit unclear, if you don't know the file names but just the directory you will have to build a temporary table and use recursion to loop through the directory and populate the table.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150
    Hey thanks. Yes I'm sorry it's not very clear. The file names are all in the same format in the format TC####<description>, these correspond to items in the database called TC####. I need images corresponding to each TC####to be grouped together under that item in the report. i.e. a linked picture sub report. I was trying to avoid loading the image paths into the database as it's not information we need to store, but I think a temporary table is the most sensible idea. Thanks, I will do it that way.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-10-2019, 06:15 PM
  2. Replies: 2
    Last Post: 03-16-2014, 02:12 PM
  3. Replies: 6
    Last Post: 10-26-2012, 12:53 PM
  4. Replies: 6
    Last Post: 06-15-2011, 04:38 PM
  5. Replies: 17
    Last Post: 08-26-2009, 11:27 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
  •  
Other Forums: Microsoft Office Forums