how to show pictures using DAO?

[sparky23]

I need solution as RecordSet to pull Attachment from table and show it in a form.
I'm trying to use the same procedure that I used to find and grab the integer data from the tblDistance table.
The table contains two points, distance, and a cell with a attachment.
I made it work to compare two variables with those two points in order to find the right distance, but I need beside the distance (integer), to show the picture
attached in the same row.


Please checks my work and give me suggestions how can I accomplish.


I'm not a programmer and I know that there is far better way to write my this program than I did.
Anyway, it works for me, but I'm still stock with the pulling the pictures from this table.


The main form is SearchPoint.
When I choose FRA 1, Room CPR, on A side: Rack ODF1, HU 48, Port 1, and on B side: Rack ODF1, HU 48, Port 24,
it should show me 0.8 meter and a picture NoBridge.png.


Thanks in advance
mFinder.zip

[June7]

Can't use DAO to pull object from attachment field and display it in Image control unless you want to save image to file folder - https://sourcedaddy.com/ms-access/wo...nt-fields.html.

Since the form uses unbound controls and code to populate, bind form to tblDistance, bind Image control to the attachment field, use code to apply filter to display record with the correct image.

Have a textbox set with the appropriate DistanceID because there are multiple records for same distance, unless the image is the same for the distance, then can reference txbResult.

RecordSource: SELECT * FROM tblDistance WHERE DistanceID = Forms!SearchPoint!txbID;

Have code refresh the form.