Poor picture quality issue when printing..

[Raymas]

Hi All,

I've had a look around, and have not found a lot on this issue. So i'm wondering if it may be a printer problem rather than an access problem.

I am currently attaching images to tables by storing their file path locations in text boxes and then linking them to image boxes when generating a report (this saves space, by referencing rather than embedding the images). The picture quality is shocking when in print preview of a report, but that is not really an issue. What is the issue (which I did not notice at first, as it varies from picture to picture) but there are pink artifacts appearing in images when they are printed. Some pictures are worse than others. I'm wondering is there a way to remove this artifacting? Has anyone else noticed this issue?

On a side note: interestingly when I exported these reports to pdf's the artifacts disappeared during printing, however, the images lost quality overall, and came out less sharp and defined.

Cheers,

Raymas

 

[boblarson]

Access doesn't handle high resolution photos well at all. You should get better results if you resample the photos to be 1024 x 768. Resample a few and see if that works any better.

 

[Raymas]

Thanks for the reply Bob. I feel a bit stupid now, that I didn't see this as the solution, as I am an electrical and computer systems engineer, and have delt with sampling before. I guess my question now, as I am relatively novice with vba and to more an extent access, is how I would achieve resampling in vba? I've done things like this with MATLAB, but I guess that can't really be considered programming when most of the functions are done for you. Do you have any reference links? Everywhere I've looked so far just seems to be people using third party software, but I would prefer to program this myself.

Cheers,

Raymas

P.S. The reason I would like to have this done at runtime is that I want to make things as easy as possible for my client, so they will be able to use the images straight from the camera.

 

[boblarson]

I haven't ever done anything programmatically around resampling pictures so I can't give you any guidance there. You might post a new thread asking for help by using this subject:

VBA to Resample and Save Pictures

You might need to use a third party tool as well. I don't know for sure.

 

[Raymas]

No worries. Lucky I didn't dive too far into it, I spoke to the client and they made me aware that their servers will contain both high res and low res images for situations such as these. So it is now a non issue. Thanks for your help bob!

Cheers,

Raymas