Image only shows on the report under certain condition

[stingray]

Since I could not generate UPC-A with a free font (If someone can help me with this, then I don't need to go through this image problem...), I decided to upload a barcode image (5KB) and have it in the accdb as attachment type.

The problem is that the image does not show in Report. The ONLY time it appears is when I register a new product (with a new barcode image) from a Form. Then barcodes appear in Report, regardless of the product (old and new) as long as I don't close the file. Once I restart the file, it does not show on the Report. It always shows in the Form. It would be great to upload an image (jpeg, png, gif) via drag & drop in a Form.
It is in an Image Control container in Report. Access 365. DB is about 3MB now. Please help.

[June7]

Suggest you provide files for analysis. Follow instructions at bottom of my post.

[jojowhite]

i think you need to Re-Open the report (Print Preview) when you want to reflect new changes to the report.
on Report View, you can try to Refresh the Report (on the Ribbon).

[June7]

Related thread https://www.accessforums.net/showthread.php?t=90599

[stingray]

Hello, OP here.
Attached is the file that I have been struggling with. I will be most glad and grateful if you solve the mystery.

I not sure how I can "refresh" the print preview page. I did not see that option. Probably that is not it, because I close and reopen the database, and everything else except for the barcode image shows.

Thank you!

[moke123]

to start, I think you need to add option explicit to your modules and correct the errors.

[June7]

It's annoying that Option Explicit is not included by default in every module for Access (it is in Excel).

In the VBA editor > Tools > Options > Editor > check "Require Variable Declaration"

Will have to manually add to existing modules.

I've never seen a db where tables have no relationships at all and query for report relies on Cartesian association of records. However, query works so report should as well. Consider that with a large dataset this can significantly slow performance.

I deleted the Image control then dragged attachment field from Field List to report. Image works.
Note difference in appearance and properties for these two controls.

Also, should be aware that attachment type field is a type of multi-value field. I avoid MVFs whenever possible.

[isladogs]

It's annoying that Option Explicit is not included by default in every module for Access (it is in Excel).

No - its the same across all Office apps.
Ticking Require Variable Declaration in e.g. Access then applies not only to all other Access apps in future but also to all Excel / Word documents as well.
Similarly, unticking in e.g. Excel will have the same effect in Access

[June7]

Oops, stand corrected. Yep, verified that behavior.

[stingray]

It's annoying that Option Explicit is not included by default in every module for Access (it is in Excel).

In the VBA editor > Tools > Options > Editor > check "Require Variable Declaration"

Will have to manually add to existing modules.

I've never seen a db where tables have no relationships at all and query for report relies on Cartesian association of records. However, query works so report should as well. Consider that with a large dataset this can significantly slow performance.

I deleted the Image control then dragged attachment field from Field List to report. Image works.
Note difference in appearance and properties for these two controls.

Also, should be aware that attachment type field is a type of multi-value field. I avoid MVFs whenever possible.

How did you do this:
> then dragged attachment field from Field List to report.

I opened the query and dragged the attachment field to the report in design view, but that was not the correct way. Could you please explain a bit more?

I would love to avoid multi-value field, but my poor skill forces me to keep it. It is because of the sample method that I found in Youtube for drag-and-drop upload.
https://www.youtube.com/watch?v=wZD0rvwl6eA&t=742s

Thank you!

[stingray]

OP here.
Did this: VBA editor > Tools > Options > Editor > check "Require Variable Declaration"

Once again, the DB is uploaded. Thank you!

[jojowhite]

here test your db.

[June7]

Report in design view.
On ribbon Report Design, click on Add Existing Fields.
Click & Drag or double click field from Field List to report.

[stingray]

Report in design view.
On ribbon Report Design, click on Add Existing Fields.
Click & Drag or double click field from Field List to report.

Thank you. I see it now.

[stingray]

here test your db.

The strange thing was that when I applied this change onto the real DB, it gave me an error, saying that it is NOT going to come from "BaseQuery" any more, are you OK? It did not work. So I went back to your sample DB. I could not find anything special, so I went back and did it again. It worked. I don't know what happened, but it is working now, so I am happy! Thank you so much. Now I have to deal with the code part to upload the image.