Location Of Url, And Not Picture

[ben3001]

I have my database which can be found here

ive made a report that has been made from a form containing pictures in an OLE object.

In the report i just get the location of the image. Ive tried looking around this forum and i cant seem to find the solution.

I'd appreciate any suggestions

Thanks

ben

 

[Rickster57]

report

In that report in design view drop an image control into the detail section of your report next to your textbox called photo.
In the On Print event of your detail section try this code:

If Not IsNull(Me.MyImage) Then Me.MyImage.Picture = Me.photo

 

[ben3001]

Hi there im not too sure if i did it right but it didnt work, heres how i did it:

Step 1:

Step 2: The Ole object

Step 3: Adding to the detail section

Step 4: error

 

[Rickster57]

report

Incorrect. Remove the code you have in the On Print. Click on the 3 dots to the right. Then paste that code in there.

 

[ben3001]

Ok now i have typed this into the code builder

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Not IsNull(Me.MyImage) Then Me.MyImage.Picture = Me.Photo
End Sub

but i have recieved this error

 

[Rickster57]

object

me.myimage refers to the name of the control you placed in the report. Right click on that image object you inserted in the report. Go to properties>Other. That is the name you must use.

 

[Rickster57]

report

Here is your database with the correction. Just change the image's data to a picture on your computer in design view

 

[ben3001]

Thanks alot for all your help Rick

Cheers

 

[ben3001]

Hi rick sorry to bother you again but on my hotel form record 2, i cant amend it, i cant delete it would you know why?

I get the error message:

3709

The search key was not found in any record