Results 1 to 1 of 1
  1. #1
    cagliostro52 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    1

    Print record : field with photo

    Thank you sincerely for the answer.
    A brief description is required:
    I created a table see attached
    Then a mask (to populate the table) I have not inserted because it goes beyond what I have to ask
    Then a Query see attachment (with the particularity of a criterion for the search of the specific ID)
    Then a report from this query see attached



    Well.
    Suppose I have inserted a picture for the Lunch field (which for short exposition I call P1 and a photo for the Cena camp (C1)
    When I go to the Report, the press (which I appropriately arranged) brings me back
    horizontally Lunch the photo P1 Dinner the photo C1

    If in the Lunch field, through the mask I add another photo (P2), when I go to print I find:
    In a first horizontal line Lunch and photo P1 Dinner and photo C1
    On the other horizontal line Lunch and the photo P2 Dinner and the and C1

    Here is my question
    I would like in the case of more photos to have this type of print:

    on the first horizontal line ALL the photos related to the lunch field (in the above example the P1 and the P2)
    on the second horizontal row ALL the photos related to the Dinner field (in the above example of course only the C1)

    Is it also possible ? VBA code?

    Thanks again, I look forward to you,
    cordiality
    Attached Thumbnails Attached Thumbnails Report.PNG   Query.PNG   Tabella.PNG  

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

Similar Threads

  1. Print record based on field value.
    By MFS in forum Programming
    Replies: 1
    Last Post: 11-29-2018, 02:23 PM
  2. Replies: 1
    Last Post: 11-21-2018, 05:02 PM
  3. Replies: 0
    Last Post: 06-23-2016, 05:09 PM
  4. Adding a different Photo per employee record
    By Beamarshall in forum Access
    Replies: 11
    Last Post: 09-26-2014, 11:45 AM
  5. Replies: 5
    Last Post: 07-29-2014, 01:05 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