Results 1 to 5 of 5
  1. #1
    TOPSie is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    153

    Report with 3x3 picture "grid"

    I would have thought this was easy, but extensive googling has given me nothing.
    I have a database to track a collection of Dahlias. I would like to print out a selection on my pictures using a report(?) with pictures arranged in a grid (3x3 say).
    So if the selection produces more than 9 images the report becomes multipage.
    I already display such selections on the screen in a Form:


    When selected I add the selection to a temporary table with just two fields "Name" and "Picture" - which contains the full path to the jpg image file.
    If I was to use this table as a data source for a report datasheet view it is very easy. I would like to repace the datasheet view with a grid of 3x3 pictures as indicated in the temporary table. Something like this: (did try and ass a picture here - but the sytem is not letting me :-(Click image for larger version. 

Name:	Clipboard_07-12-2025_01.jpg 
Views:	25 
Size:	83.0 KB 
ID:	53147
    Last edited by TOPSie; 07-12-2025 at 12:04 PM. Reason: Add image

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,551
    Something like this:
    Something like what?
    You cannot just paste picture here, although it appears you can. Always check your post.

    See How To Attach Files in the top taskbar.

    I would probably have the report with the 9 images suffixed with their number, then work out a way to number the data coming in, so they go from 1 to 9 and then 1 to 9 again.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,818
    Can you not do this with a Multi Column Report?

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,551
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Is this a multi-user application? if not, don't need "temp" table. Have a yes/no field for "Select". Base report on filtered query. Code can execute an SQL UPDATE action to clear the Select field to start clean for a new selection session.

    And yes, a multi-column report should be able to produce desired output.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Creating a picture grid dynamically
    By TOPSie in forum Access
    Replies: 8
    Last Post: 09-13-2022, 07:17 PM
  2. Replies: 19
    Last Post: 05-23-2020, 05:07 PM
  3. Replies: 8
    Last Post: 12-17-2017, 12:33 PM
  4. Replies: 1
    Last Post: 08-26-2014, 03:45 PM
  5. Grid lines vs Grid Dots
    By dharriet in forum Access
    Replies: 0
    Last Post: 10-14-2008, 09:17 PM

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