Add images to report run-time?

  • Thread starter Thread starter Olof
  • Start date Start date
O

Olof

Hi,

I have a table that contains 0 or more paths to images
for a specific entry in another table. When I run the
report I want the images to appear at the end of the
report. Is there a way to add image controls runtime or
is there another way to solve this problem?

Thanks in advance,


Olof
 
Hi,

You wrote:
"..When I run the report I want the images to appear at the end of the
report. Is there a way to add image controls runtime or is there another
way to solve this problem?.."

Have you considered this solution:
ACC2000: How to Display an Image from a Folder in a Form or in a Report
http://support.microsoft.com/default.aspx?scid=kb;en-us;210100


Thank you for using the Microsoft Access Newsgroups.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
 
Thanks for your reply!

This looks lite something that I could use. The
difference for me is that the underlying table for my
report is not the images table but the parent table of
the images table so to speak. Is it possible to create
a "sub"-report that displays the images corresponding to
the parent id?

thanks again,


Olof
 
Yes, you could. If there is a variable number of images per parent record,
this would be best. But, just to caution, you cannot use the method
described on a continuous forms view Form, but it will work very nicely in a
Report embedded in a Subreport Control. Instead of the OnCurrent event used
in Forms, put the code in the Print event of the Report.

You can download sample databases illustrating three approaches to handling
images in Access from http://accdevel.tripod.com. They use Forms but the
controls and code are the same in Reports.

If your pictures are not .BMP files, you should also visit MVP Stephen
Lebans' site, http://www.lebans.com and take a look at his sample database
PrintFailure.ZIP which you will find at
http://www.lebans.com/DownloadFiles/PrintFailure.ZIP. It contains code for
converting the contents of the Image control to a Bitmap file prior to
printing. Otherwise, an "issue" in Reports may cause you to run out of
memory if you have many pictures.

Larry Linson
Microsoft Access MVP
 
Back
Top