I have a table in Access containing file paths to images along with various other data.
I have created a report to display this information along with the picture that the file path points to.
In the detail section of the report i have included the following code in the OnFormat property.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim Image As String
Image = Me![PictureLocation]
MsgBox Image
Me![Image1].Picture = Me![PictureLocation]
End Sub
My problem is that when i run the report I am displayed with the following error message,
Runtime error '2220':
Microsoft Access can't open the file
'../images/imagename.jpg#images/imagename.jpg#'.
Can anyone explain how this is happening and how to avoid it?
Thanks in advance
I have created a report to display this information along with the picture that the file path points to.
In the detail section of the report i have included the following code in the OnFormat property.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim Image As String
Image = Me![PictureLocation]
MsgBox Image
Me![Image1].Picture = Me![PictureLocation]
End Sub
My problem is that when i run the report I am displayed with the following error message,
Runtime error '2220':
Microsoft Access can't open the file
'../images/imagename.jpg#images/imagename.jpg#'.
Can anyone explain how this is happening and how to avoid it?
Thanks in advance