Importing pictures in reports

[dvoinoKafe]

Hi all. I have the following problem. I have created a report that
imports the required pictures stored on the server by using their path
stored in a field in the database. The problem is that a single report
contains from up to 200 pictures and it takes quite a lot of time to
load all of them. Also im many cases the system simply crashes due to
a lack of memory. the printouts are just 75 by 50 mm but the pictures
are all about a MB+.
I do not want to resize all the pictures on the server as they have to
be kept in their original quality for record purposes.

Can anybody help please.

I was thinking of creating a prog to create a resized copies of all
pictures in the folder and store them in a diferent one that can be
used for populating the report.
Any ideas how can I do this? Any alredy redy progs for this?

Any help will be kindly appreciated.
Kind Regards
Y.

 

[Stephen Lebans]

1) Use the Print event instead of the section's Format event.
2) Turn off the "Loading Image" dialog.

Here is a prior post of mine on this issue:


The one thing you must do is turn of the "Loading Image" dialog. If you
don't,
and quickly scroll through the records in Form view, or page quickly in
Print Preview, you run the risk of crashing Access. Use the Registry mod at
the Access MVP site:


Additionally, two issues in regards to the Registry modification pointed to
here:
http://www.mvps.org/access/api/api0038.htm


1) The Registry key MUST be "No" NOT "no" or "NO"


2) On systems with XP or on systems with more than one user account,
you must add/modify the key in both HKEY_CURRENT_USER and
HKEY_LOCAL_MACHINE.



--

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