BMP to JPEG Conversion

[jkurpias]

I have an Access2000 image database loaded with JPEG's and want to write a program in Access VBA that will put text on several JPEG's and email them.

Access doesn't include the VB PictureBox control and the Image control doesn't permit editing. The Kodak Image Edit control has great annotation features but will only save images as BMP's, TIFF's & AWD's and these image formats are too big and don't display on the email message.

Is there a control/code that will convert a BMP to a JPEG and work within Access VBA? Any advice?

[Mongo]

You're on the right track using the Image Edit control (Imgedit.ocx). Look in Imgocxd.hlp, using keyword "SaveAs" I know you cannot do this in non/pre-SR2 Win95 -- and, even then, Win95 with SR2 end-users must install the imaging automation separately from your "distributed" ocx for it to work. It'll work in Win98 and NT. However, this will not work when a URL is entered in the Image property (fully qualified name).

yourObject.SaveAs "C:\girly\duhImage.JPEG", 6,6,6,1024