current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I have an access file and i want to find a way to reduce the file size of the images that i insert using VBA code.

More specifically they gave me an access application where you can insert an image by drag and drop. I want these images when they drop them in the application immediately reduce their file size. For example if the image is 195KB i want to reduce it to 35KB.

I am new in the vba coding and and in access and i search the web but nothing helps me.

Any ideas??

Thanks in advance.

share|improve this question
    
Do you mean "reduce the size" of the image? (the "capacity" is the maximum size you would store) –  Barranka Jul 29 '14 at 18:18
2  
Do not use the term 'capacity'. It's called file size. What you're aiming to do is image compression. Here are two links: here and here. If you're new to VBA coding, you'll have to study some basic tutorials before you can do something as complicated as what you want. –  The Laughing Man Jul 29 '14 at 18:35
    
you are right for the file size. Thanks a lot and sorry for the mistake –  lostromos Jul 30 '14 at 10:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.