How do I - Images in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Just upgraded to Office 2003. I have been running a access report with this
code in it to get, linked, WMF images on my reports:

Function setImagePath()
Dim strImagePath As String
On Error GoTo PictureNotAvailable
strImagePath = Me.txtImageName
Me.ImageFrame.Picture = strImagePath
Exit Function

PictureNotAvailable:
strImagePath = "G:\prodoc\refmatl\toolgrph\nopic.wmf"
Me.ImageFrame.Picture = strImagePath
End Function


Has worked great until I upgraded to 2003. Now I get an error that Access
does not support this format. I converted the images to bitmaps but the
images look terrible.

What do i need to do to get Access 2003 to work with WMF images.


Thanks in advance.


Barry
 
WMF works here without issue.

Barry just for fun would you try changing the capitalization of the starting
character in the 3 character file extension. For example if your current
images are named like:
whatever.wmf
change it to
whatever.Wmf
or vice versa.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
This did not work. All that I have read says you need a program that can
open the WMF file, act as Ole server. One suggestion was to install
Microsoft Photo Editor from Office 2000. Tried that too and still have the
same problem.

Barry
 
Barry can you Email me one of the WMF's that you cannot load on your system?
(e-mail address removed)


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Ok will do.

Thanks for your time!

Barry

Stephen Lebans said:
Barry can you Email me one of the WMF's that you cannot load on your system?
(e-mail address removed)


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
Click to expand...
 
Ok found the problem.

The field that contains the path to the picture had spaces in it to fill up
the field length. I just used a Rtrim$ in my query to strip the spaces and
now all is well.


Barry
 
Back
Top