Solved Add attachment (pic) to a report.

[DBrodin]

I am trying to modify a database that I did for convention registration many years ago to print photo name tags for a reunion. My structure is a table (sheet 1) with names and a photo in an attachment field, a form (check-in) to select a record, and a report (Name tag) based on the record displayed in the form. I used this setup to print name tags without photos for years. The form loads and displays the name and photo correctly, but the image does not load in the report. My code for the attachment box of the report is

=[Forms]![Check-in]![photo]

. I am at a loss as to why the attachment loads in the form, but not in the report.

 

[theDBguy]

Did you use an Attachment control instead of a Picture control?

 

[DBrodin]

The photos are in an attachment field in the table, and attachment controls in both the form and the report.

 

[bastanu]

The photos are in an attachment field in the table, and attachment controls in both the form and the report.View attachment 98121

 

[bastanu]

Your report should be based on the same table or query as the form and the control source of the attachment control on the report should not mention the form at all, should simply be [Photo].

Cheers,

 

[DBrodin]

That brings the photo across, but it is loading every record. How do I limit it to the record selected in the form?

 

[bastanu]

You either limit the report's record source to the current record loaded in the form SELECT * FROM [Sheet 1] WHERE ID = Forms![Check-in]![ID] or if you open the report from the form use the Where clause of the Docmd.OpenReport (https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openreport)

Cheers,

 

[DBrodin]

SELECT * FROM [Sheet 1] WHERE ID = Forms![Check-in]![ID]

That did the trick!
I taught myself just enough Access ten years ago to write the database for political conventions that tracked who was present, and from what district, along with about a dozen reports. The name tag module I added about six years ago as an update. Adding photos to the mix was new territory for me. Thanks!!

 

[bastanu]

You're very welcome, good luck with your project!

Cheers,

 

[theDBguy]

Glad to hear you got it sorted out. Cheers!