G
Guest
I've got a weird problem with an Access 2003 report. Each row of the report
presents the data from one row of the database, including a zoomed-down
thumbnail of an image. The database actually contains the filename of the
image, which is imported during the report's Format event. In the event
that the import fails, since some images may legitimately be missing, the
image is made invisible and the label "No image" is made visible in its
place.
Where things become strange is that the report looks perfect in Print
Preview when the recordsource contains up to about 1500 rows (a 127-page
report). As the number of rows increases beyond that, images display on the
first few pages of the report, but images on subsequent pages are replaced
by blank space. Even stranger, all images on pages towards the end of the
report are replaced by the "No image" label. As the number of rows
increases further, the image problems begin earlier in the report, to the
point where even the images on the first page-which displayed properly
earlier-are replaced by "No image," even though the "Importing." dialog
flashes constantly on the screen and a code trace of the first few rows
shows that they are being imported properly.
OK, a further code trace reveals that the format event is being executed
twice for each row, apparently in two complete successive passes through the
recordset. The first time, the image imports properly, and the second time,
for the same image, the import fails with the message "Microsoft Access
doesn't support the format of the file 'xxx.jpg,' or the file is too large.
Try converting the file to BMP or GIF format." There must also be some
intermediate state in which the image fails to import, but no error is
raised.
Is this an Access problem? Does the JPG import filter have some sort of
memory leak?
Ideas, anyone?
Thanks in advance.
presents the data from one row of the database, including a zoomed-down
thumbnail of an image. The database actually contains the filename of the
image, which is imported during the report's Format event. In the event
that the import fails, since some images may legitimately be missing, the
image is made invisible and the label "No image" is made visible in its
place.
Where things become strange is that the report looks perfect in Print
Preview when the recordsource contains up to about 1500 rows (a 127-page
report). As the number of rows increases beyond that, images display on the
first few pages of the report, but images on subsequent pages are replaced
by blank space. Even stranger, all images on pages towards the end of the
report are replaced by the "No image" label. As the number of rows
increases further, the image problems begin earlier in the report, to the
point where even the images on the first page-which displayed properly
earlier-are replaced by "No image," even though the "Importing." dialog
flashes constantly on the screen and a code trace of the first few rows
shows that they are being imported properly.
OK, a further code trace reveals that the format event is being executed
twice for each row, apparently in two complete successive passes through the
recordset. The first time, the image imports properly, and the second time,
for the same image, the import fails with the message "Microsoft Access
doesn't support the format of the file 'xxx.jpg,' or the file is too large.
Try converting the file to BMP or GIF format." There must also be some
intermediate state in which the image fails to import, but no error is
raised.
Is this an Access problem? Does the JPG import filter have some sort of
memory leak?
Ideas, anyone?
Thanks in advance.