Image Load

[RayMilhon]

I have an access Database frontend connected to a sql server backend I have 2 tables 1 for patients and 1 for documents scanned in for the patients each patient can have multiple documents.

I have a main form for the patient information and a subform for the documents. The table stores 4 pieces of information

1. the Primary Key of the image table
2. the foreign Key to link the image to a patient
3. the path to the scanned image of the document
4. the description of the scanned image



the problem I'm having is getting the images to display in the form.

the subform is linked to the main form via the foreign key. I have an image control on the subform but I'm not sure how to load the image to the image control since I'm storing a path to the image in SQL Server not the image itself. Any assistance on how to get the file to display would be appreciated.

[trevor40]

This uses the image filename to update the image as the records change. It does require the full path and filename to be saved in [employee photo] on the employees table.

Private Sub Form_Current()
On Error Resume Next

t = DLookup("[Employee Photo]", "[Employees]", "[barcode] = " & Me.barcode)

If IsNull(t) Then
Forms![employee list fm]![Employee Photo].Picture = ""
Else

Forms![employee list fm]![Employee Photo].Picture = t

End If
End Sub

[orange]

Hi Ray,

I looked for examples, but this video covers the basics with Access -(oops I see Trevor has provided an example)