Converting tiff to jpeg

[macca007]

Hi all,

I have access 2003 on windows xp. My situation is i would like to convert a tiff file to a jpeg file. Has n e body done this before in access using vba code. Or is there code already done that i could use. Or something that could get me going.

Cheers

 

[GingerR]

Do you have to convert it using VBA? Do you mean this is an ongoing function you want to use? Or you simply want to convert a file to use in your db or some place else?

If it's a one-time thing (or not something you need functionality in your database to do), I use Graphic Workshop by Alchemy Mindworks:

http://www.handyarchive.com/free/alchemy-mindworks/

Free and easy

 

[macca007]

I would like to incorporate this into my functionality within the database. The problem is we get some images from our server and they are placed in a folder. Wat i would like to do is have access have a button to convert those into jpegs. They are then placed under certain file structures. Which can later be viewed in access.

thanks for the reply

any other suggestions anyone?

 

[GingerR]

I looked around on line and it looks like there are lots of utilities available. Some the manufacturer supplies code for VB, C++ and other programming languages, but I don't find many for VBA. My guess is that you'll have to use a combo of a utility that you call from Access, or just use the utility on it's own.

Here's one called DBPix that actually references VBA:

http://www.handyarchive.com/free/convert-jpeg/index14.html

 

[HitechUser]

macca007,

I believe you can accomplish what you need (for FREE).

Goto --

http://www.irfanview.com/

After you install it, consult the help option. The program accepts command line agruments. You can build the command line string using VBA. Then do a system call to launch the command (or batch file). The software supports converting to and from virtually all file types.

Did I mention is was FREE?

I hope this helps.

Good Luck...