Report Image Based On VBA Path

[CharlesWhiteman]

I'm trying to control a variable which is the path to an image which occurs in various reports but keep getting Debug issues. Here is my code can anyone shed any advise please?

OnOpen Event In Report:-

Dim strLogo As String
strLogo = (DLookup("Logo", "Tblconfiguration"))

Me.PicLogo = strLogo

 

[KeithG]

What is the error message?

 

[CharlesWhiteman]

runtime error 438

object doesnt support this property or method

 

[ecawilkinson]

hi,

I'm assuming the Image is called PicLogo, in which case the syntax is:

me.piclogo.picture = strLogo

HTH,
Chris

 

[KeithG]

What type of control is me.piclogo? Is it an image control? If so use me.piclogo.picture=strlogo

 

[CharlesWhiteman]

Thanks, that worked a treat and opens up a whole host of possibilities!

 

[CharlesWhiteman]

I'm using this code as follows:

Dim strLogoFront As String
strLogoFront = (DLookup("Logo", "Tblconfiguration"))
Me.PicLogoFront.Picture = strLogoFront

In order to have a picture objecvt on a form or report there has to be a reference to a physical location, i have found, even if then referencing it as above.

The problem I continue to have is with this code, on other computers, where clearly the original physical location isnt there i get an error message relating to the image object properties location reference but then it works as per my code.

Any ideas?