Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-26-2005, 01:15 AM   #1
muzza79
Registered User
 
Join Date: Oct 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
muzza79 is on a distinguished road
Error message when trying to display image

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

__________________
Get down! What dance?
muzza79 is offline   Reply With Quote
Old 06-07-2005, 06:59 AM   #2
muzza79
Registered User
 
Join Date: Oct 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
muzza79 is on a distinguished road
I found an answer here for anyone who needs it,

http://support.microsoft.com/default...b;en-us;285820
__________________
Get down! What dance?
muzza79 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
display image in a subform LPayne Forms 2 02-15-2005 08:23 AM
about different image display at the same time borislo General 0 02-07-2005 10:28 PM
Set Day Name by Date DaniBoy General 7 11-22-2004 10:41 PM
hyperlink for image display on form isn't working lscheer Forms 1 06-29-2004 01:26 PM




All times are GMT -8. The time now is 05:43 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World