469,949 Members | 2,203 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,949 developers. It's quick & easy.

external image files on a report

I have a problem with displaying image files (jpg) on my report.
I got a solution from Larry Linson (Microsoft Access MVP) for which I'm
grateful, but I still don't exactly know how to link an image control with
the specific file - all information: path name, file name and file extention
are included in one field of each record in the report source table (data of
this shape: \\server_name\folder_name\file_name.jpg).
Any help appreciated.
Cheers
Nov 12 '05 #1
3 2639
In the Print event for the Section of the Report that contains the Image
control, set the Picture property of the Image control to that fully
qualified path-and-file name.

Asf you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP

"Veetold" <ve*****@veetold.pl> wrote in message
news:c4***********@news2.ipartners.pl...
I have a problem with displaying image files (jpg) on my report.
I got a solution from Larry Linson (Microsoft Access MVP) for which I'm
grateful, but I still don't exactly know how to link an image control with
the specific file - all information: path name, file name and file extention are included in one field of each record in the report source table (data of this shape: \\server_name\folder_name\file_name.jpg).
Any help appreciated.
Cheers

Nov 12 '05 #2
It works - thank you. :)
Użytkownik "Larry Linson" <bo*****@localhost.not> napisał w wiadomości
news:%2******************@TK2MSFTNGP11.phx.gbl...
In the Print event for the Section of the Report that contains the Image
control, set the Picture property of the Image control to that fully
qualified path-and-file name.

Asf you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm. PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver. This MDB also contains code showing how to convert the contents of the Image control to a Bitmap file prior to printing. This helps alleviate the "Out of Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP

"Veetold" <ve*****@veetold.pl> wrote in message
news:c4***********@news2.ipartners.pl...
I have a problem with displaying image files (jpg) on my report.
I got a solution from Larry Linson (Microsoft Access MVP) for which I'm
grateful, but I still don't exactly know how to link an image control with the specific file - all information: path name, file name and file extention
are included in one field of each record in the report source table

(data of
this shape: \\server_name\folder_name\file_name.jpg).
Any help appreciated.
Cheers


Nov 12 '05 #3

"Larry Linson" <bo*****@localhost.not> wrote in message
news:#k**************@TK2MSFTNGP11.phx.gbl...
In the Print event for the Section of the Report that contains the Image control, set the Picture property of the Image control to that fully
qualified path-and-file name.

Sorry to piggy-back this :)

Is there a way to avoid the full path?

--
FatMax
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Richard Speiss | last post: by
reply views Thread by Cameron | last post: by
4 posts views Thread by Ed Landau | last post: by
3 posts views Thread by Veetold | last post: by
reply views Thread by Jacky11 | last post: by
6 posts views Thread by Kevin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.