Another OLE issue

[thatlemhome]

I am having a problem with embedding a bmp file as OLE.
It has been working fine, but a few weeks ago I downloaded SP3 for Office 2007 and now have a problem.

At first I was getting the error 502750, OLE Object failed, reinstall. I followed the advise noted by Sinfathisar and was able to remove the offending DDL file. So now the OLE at least works.

However, now the OLE wants to embed the file as a package instead of simply displaying the bmp picture. This is especially annoying as I am in the final testing stages of production and the bmp is a user defined image that appears on all the reports.

I prefer not to link the image but have within the table (there is just one).

Does anyone have a solution? I see lots of stuff on the web for 2003 and earlier, but can't seem to locate a solution for 2007.

Any help is greatly appreciated.
Thanks

 

[Simon_MT]

You as use .picture and external files:

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

Simon