[AccessD]Error loading picture

Kath Pelletti KP at sdsonline.net
Mon Jun 13 21:01:25 CDT 2005


Just change the filename string or just the extension part via UCase or 
LCase
when you pass to the Picture property of the Image control.
Great idea.


You can also download and install, if something has gone wrong with your 
filters.
Office File Converter Pack   OCONVPCK.EXE
Will try.

Kath

  ----- Original Message ----- 
  From: MartyConnelly 
  To: Access Developers discussion and problem solving 
  Sent: Monday, June 13, 2005 7:14 AM
  Subject: Re: [AccessD]Error loading picture


  Actually it is a bit more bizarre
  You don't have to change the actual physical filename extension case.

  Just change the filename string or just the extension part via UCase or 
  LCase
  when you pass to the Picture property of the Image control.

  lower case bypasses Office Graphics filters, something to do with 
  metafiles in the image.
  If the file extension is in uppercase  then the Office Graphicsfilters 
  will be used to load the image.

  You can also download and install, if something has gone wrong with your 
  filters.

  Office File Converter Pack   OCONVPCK.EXE
  This download provides file converters and image filters for Microsoft 
  Office programs, from Microsoft Office 97 to Microsoft Office 2003.
  It depends on what version of office is installed.

  http://www.microsoft.com/downloads/details.aspx?FamilyID=cf196df0-70e5-4595-8a98-370278f40c57&DisplayLang=en

  Info here
  http://office.microsoft.com/en-us/assistance/HA011513581033.aspx

  If you use Lebans method (a bit convoluted) to get .jpeg extensions make 
  this change in Function fLoadPicture
   
  Select Case right$(strfName, 3)

      Case "bmp", "dib", "Gif", "emf", "Wmf", "ico", "cur", "jpg", "peg"

  I gave up using jpegs for other reasons, I was getting microfilm images
  and so used djvu format as it can be up to 10 times smaller on black and 
  white text type images
  and has a text searchable metafile plugins. Some University libraries 
  are using for historical
  archive display on the web. Things like old manuscripts and folios.

  http://www.djvuzone.org/wid/index.html
  http://www.djvuzone.org/

  Kath Pelletti wrote:

  >Re: this problem:
  >
  >  
  >
  >>When the user opens a form which attempts to load a .jpg or .gif picture the system come up with "...the database doesn't support the format of 
  >>'E:\Database\Photos\Peru.jpg' so it can't load the picture.
  >>    
  >>
  >
  >I found a bizarre solution in a line on the Lebans website to the effect that if the file extension is upper case it is treated differently by Access to it being in lower case. Disbelieving, I tried it and it works. If I change the file extension of the 350 photos which this system uses (which I can do with one DOS command) from .jpg to .JPG then Access manages to load them correctly.
  >
  >It's a bit of a bizarre solution but having uninstalled and re-installed the graphics filters for Office twice, then doing a complete re-installation of Office I am relieved to find any kind of a simple solution. 
  >
  >BTW - Marty - I did spend some tine on this:  http://www.lebans.com/loadjpeg­gif.htm but found that it was difficult to follow. Have you used it?  
  >
  >Kath
  >
  >______________________________________________
  >Kath Pelletti
  >Software Design & Solutions Pty Ltd.
  >Ph: 9505-6714
  >Fax: 9505-6430
  >KP at SDSOnline.net
  >  
  >

  -- 
  Marty Connelly
  Victoria, B.C.
  Canada



  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com


More information about the AccessD mailing list