How do I display linked TIFF images within Access 2003 reports?

[Case Cybermancer]

I have developed an application using Access 2002 and it now needs to be
migrated to Access 2003. I generate a number of reports having a list of
individuals' details and their associated photos -- these images can only be
provided in TIFF format and will be frequently updated.

In Access 2002 all works as expected without errors. In Access 2003 it
complains that the TIFF format is not supported and that I should convert
the
images to BMP or GIF. As the images will be frequently updated, batch
converting a few thousand images every couple of days is not a viable
option.

Oddly enough, I can insert the link to a TIFF image into Word 2003 and
PowerPoint 2003 without a problem. Unfortunately, not in Access 2003!

Any useful input will be greatly appreciated.

TIA

 

[SusanV]

http://www.lebans.com/loadjpeggif.htm

 

[Case Cybermancer]

Hi SusanV,
I've looked at http://www.lebans.com/loadjpeggif.htm and a several other
pages on the site. Unfortunately as far as Access goes, they only have info
regarding jpeg and gif images. As for tiff the site simply states that it is
supported via the Microsoft GDI+ DLL. I've downloaded it and tried
installing it according to the instructions (and then some alternate ways).
No difference -- the problem continues...

I there something I've missed?

 

[Stephen Lebans]

The solution requires you to use the function call provided by my code to
load TIF files into the standard Image control. Did you even try to use the
sample form in the MDB you downloaded?

--

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

 

[Stephen Lebans]

Are these multi page TIFF files by any chance? My code only supports single
Image Tif files.

The solution on my site was tested with A2003

--

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

The solution requires you to use the function call provided by my code to
load TIF files into the standard Image control. Did you even try to use
the
sample form in the MDB you downloaded?

Hi Stephen!

We seem to be talking past each other :-o
Yes, I did try the sample you provided (see attached screen snapshots)
and it falls over on line 626 in module modStdPic
Set hPic = LoadPicture(strfName)
when strfName = "C:\Test1.tif" or "C:\Test1.TIF"

My existing solution works with Access 2002 and opens a TIFF image
without any problems -- it does not work with Access 2003!!!
Your solution also works with Access 2002 and opens a TIFF image without
any problems -- like mine, yours does not work with Access 2003!!! (Or
at least, I could not get it to work with Access 2003)
Unless one tries to do this with Access 2003, you will not be able to
replicate the error. So here it is back at you -- Did you even try to
use the MDB sample you developed with Access 2003 and TIFF files?

Thanks for trying to help anyway :-(
I guess when it comes to TIFF images migrating from Access 2002 to
Access 2003 should be called a downgrade. Which makes me wonder, what
else has been removed. I guess we'll eventually jump off that bridge
when we get to it

[This should not make much of a difference but I am using
MS Office Pro 2003 with BCM (French edition)
PC running on Windows XP Pro 2002 SP2
Developer running on Coffee )
]

--------------------------------------------------------------------------------






--------------------------------------------------------------------------------






--------------------------------------------------------------------------------

 

[Case Cybermancer]

Are these multi page TIFF files by any chance? My code only supports single
Image Tif files.

The solution on my site was tested with A2003

Hi Stephen!
These are single page uncompressed TIFFs. Unfortunately the client's
legacy app only outputs TIFF files. As they wish to run interim reports
every evening, I wish to avoid eventually having to batch convert a few
thousand photos at a time.

After trying a few alternatives, I tried adding the GDIplus DLL but it
made no difference. I also tried adding the tiff filter from the
previous version of Access but that also had no effect.

Possibly, I am not asking the right question. Since a full-installation
of "vanilla" MS Access 2003 does not support loading TIFF files into an
image control then what do I need to load onto the current windows or ms
access environment to enable it to do so?
I am now considering to try to add an activex control to the report. Any
ideas of any freeware or functional trial activex controls I can try.

Many thanks,
Case

 

[Stephen Lebans]

Can you send me the TIF file that failed to load? I have never heard yet of
my GDI+ based solution failing to load a single page TIF file. I'd like to
step through the code and see where it is failing with this file. By the
way, as the instructions clearly state, you only need to install the GDI+
runtime on pre windows XP installs that currently do not have the GDI+
libraries installed.

--

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

 

[Case Cybermancer]

Can you send me the TIF file that failed to load? I have never heard yet of
my GDI+ based solution failing to load a single page TIF file. I'd like to
step through the code and see where it is failing with this file. By the
way, as the instructions clearly state, you only need to install the GDI+
runtime on pre windows XP installs that currently do not have the GDI+
libraries installed.

Hi Stephen
I've send you a sample of TIF file directly at the email address I found
at your website. I initially tried posting it to the newsgroup but the
news server was complaining about the file size. Although it could be
split and reassembled I thought it best to give you an non-manipulated copy.
Regards,
Case

 

[Stephen Lebans]

The Tif file you sent loaded perfectly the first time I tried it. Are you
sure you sent me the one that is failing on your system?

What version of WIndows are you running?
What version of Access are you using?

--

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

 

[Case Cybermancer]

The Tif file you sent loaded perfectly the first time I tried it. Are you
sure you sent me the one that is failing on your system?

What version of WIndows are you running?
What version of Access are you using?

The Tif file you received definitely fails. The target PCs are setup with:
Microsoft Windows XP Professional version 2002 SP2 (French - OEM)
Microsoft Office Professional 2003 (French)
with Microsoft Office Access 2003 (11.5614.5606)
with VBA v 6.04

My laptop is loaded with Windows XP and MS Office Prof 2002 -- my code
and your code works flawlessly on the laptop -- none of the tif's work
on any of the PCs (which are all loaded with Office 2003)

As a last resort I decided to load MS Office XP (i.e., 2002) on one of
the PCs so that I can at least generate one copy of the report -- let's
consider it an upgrade to the previous version
Well, the report is generated in Access 2002 on the PC without any
problems. After installing the older version of Access, I went back to
re-test the report in Access 2003 -- to my surprise, the report now
works in both versions :-o (although in Access 2003 it occasionally
generates an error... not sure why)

 

[Guest]

Hello Case and Stephen

I am having exacttly the same problem you guys have been talking about.
Access 2003 says it does not support .tif images.
I looked at the PC and found out that it already has de DLL instaled. I do
not have Access 2002 to install here and test.
What else should I do?
Regards,

Rodrigo