Unanswered: linked image printing in a report, error!!
Run-time error '2220':
Microsoft Office Access cant open the file '#c:\my web sites\media\543.bmp#'.
Option Compare Database
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![imageframe].Picture = Me![imagepath]
The above is an error I get when trying the methods used in various threads to display a linked image in the report. I have tried different methods of renaming the files in the table itself, i.e \\server\C\filename.bmp, etc.
It always gives the top error, the original code is located underneath and it highlights the line starting with Me! - any suggestions?
I found out what my problem was, because i got all the info from a different database, when i cut and paste, there were invisible # on the ends which appeared when i plucked the info out of the table and then put into a notepad, etc.