Changing Image on a report

[Jmsteph]

I have a database that exports letters for the team to be mailed each morning. The issue I am running into is that they have to sign each letter. I have a digital image of each of their signatures and would like to pull that signature on to the letter.

Basically for the letter it does a DLookup to pull their name and title to print on the letter. I’d like to use this same function to pull their signature on the report as well. If anyone has any ideas on how to change the image based on the user I would really appreciate it.
Thanks,

JS

 

[DCrake]

Of hand it is either .Picture or LoadPicture. Try to get it on a form control first then apply the same to the report.

Is the signature embedded or linked to an image file?

 

[Simon_MT]

Either:

On the Employee Table create a ImageFile field and add the image

Or

Store the Images according to each User / Employee

Then

On the form the [ImageFile] = User + ".jpg"

A Public Function for GetImageDir for the Path and Image Directory

then

Function GetPicture()
Dim FullPath As String
    With CodeContextObject
        FullPath = GetImageDir & .[ImageFile]
        If Dir([FullPath]) <> Empty Then
            .[ImageControl].Visible = True
            .[ImageControl].Picture = FullPath
        Else
            .[ImageControl].Visible = False
        End If
    End With
End Function

Simon