Got a picture of you

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Simple Question: Database includes pictures
(imported .jpgs). Report wizard sets up a usable report,
but the pictures aren't printed, just application icons.
What's the trick to make it print the actual pictures?
 
Take a look at the sample databases you can download from
http://accdevel.tripod.com. They illustrate three approaches to handling
images in Access. I'd guess you are using OLE Objects, and (1) the show icon
or some other property is improperly set, or (2) the image handling software
that you use doesn't do the proper job of display until the image is clicked
(which is a problem, in that reports aren't interactive like forms).

And, to avoid memory leakage when using the other techniques, see MVP
Stephen Lebans' http://www.lebans.com/printfailures.htm.

Larry Linson
Microsoft Access MVP
 
Hi Larry! Firstly thanks for your sharing..
Indeed I have adopted the "External Files" approach in developing my report,
and intended to show a image file based on the filepath info stored in a
table.

The steps i intended to use for creating my report are,
1) Create a blank imageframe named "image0"
2) Use Event Procedure to let the imageframe acquires info from table (path)
and locate the image file
3) If the image file cannot be found, the imageframe will be filled by
another file "blank.jpg"
As such, i hv written the followings in "On Format" field of Details session
of the report..

On Error GoTo Err_Detail_format
Me![image0].Picture = Me.path
Exit Sub

Err_Detail_format:
Me![image0].Picture = "blank.jpg"
Resume Next
Exit Sub
End Sub

Everything was fine in the first attempt. However, when I closed the file
and re-open it some time later, I have found that the "Picture" parameter in
the line "Me![image0]." is not working anymore... When I re-type the line
again, the "Picture" parameter even disappeared and not been offered by
Access.

What is the problem? Appreciated if you all can provide some valuable
advice!! Thanks in advance!
--
---
///////\\\\\
//// ~ \\\\
|-==. .==-. \\\
\<_o> <_o> ~c)
/ / _/
|/(..) \ '
| \____/ ) /
\ .| B Head!!! ¥²«g
\:___.-' | (e-mail address removed) ICQ: 8877121
---
"Larry Linson" <[email protected]> ¼¶¼g©ó¶l¥ó
Take a look at the sample databases you can download from
http://accdevel.tripod.com. They illustrate three approaches to handling
images in Access. I'd guess you are using OLE Objects, and (1) the show icon
or some other property is improperly set, or (2) the image handling software
that you use doesn't do the proper job of display until the image is clicked
(which is a problem, in that reports aren't interactive like forms).

And, to avoid memory leakage when using the other techniques, see MVP
Stephen Lebans' http://www.lebans.com/printfailures.htm.

Larry Linson
Microsoft Access MVP
 
I've never had a Picture property disappear; in fact, this is the first I
have heard of one disappearing. Perhaps you might look at determining if the
file exists in some other way... could be that setting the Picture property
to a nonexistent value is causing the problem, though I am almost sure that
I've set some to Null in the past.

Larry Linson
Microsoft Access MVP


B Head!! said:
Hi Larry! Firstly thanks for your sharing..
Indeed I have adopted the "External Files" approach in developing my report,
and intended to show a image file based on the filepath info stored in a
table.

The steps i intended to use for creating my report are,
1) Create a blank imageframe named "image0"
2) Use Event Procedure to let the imageframe acquires info from table (path)
and locate the image file
3) If the image file cannot be found, the imageframe will be filled by
another file "blank.jpg"
As such, i hv written the followings in "On Format" field of Details session
of the report..

On Error GoTo Err_Detail_format
Me![image0].Picture = Me.path
Exit Sub

Err_Detail_format:
Me![image0].Picture = "blank.jpg"
Resume Next
Exit Sub
End Sub

Everything was fine in the first attempt. However, when I closed the file
and re-open it some time later, I have found that the "Picture" parameter in
the line "Me![image0]." is not working anymore... When I re-type the line
again, the "Picture" parameter even disappeared and not been offered by
Access.

What is the problem? Appreciated if you all can provide some valuable
advice!! Thanks in advance!
--
---
///////\\\\\
//// ~ \\\\
|-==. .==-. \\\
\<_o> <_o> ~c)
/ / _/
|/(..) \ '
| \____/ ) /
\ .| B Head!!! ¥²«g
\:___.-' | (e-mail address removed) ICQ: 8877121
---
"Larry Linson" <[email protected]> ¼¶¼g©ó¶l¥ó
Take a look at the sample databases you can download from
http://accdevel.tripod.com. They illustrate three approaches to handling
images in Access. I'd guess you are using OLE Objects, and (1) the show icon
or some other property is improperly set, or (2) the image handling software
that you use doesn't do the proper job of display until the image is clicked
(which is a problem, in that reports aren't interactive like forms).

And, to avoid memory leakage when using the other techniques, see MVP
Stephen Lebans' http://www.lebans.com/printfailures.htm.

Larry Linson
Microsoft Access MVP

Rick said:
Simple Question: Database includes pictures
(imported .jpgs). Report wizard sets up a usable report,
but the pictures aren't printed, just application icons.
What's the trick to make it print the actual pictures?
Click to expand...
Click to expand...
 
Yes I would like to know as well, I have found it shows in both forms
and reports if the picture type is a bitmap or tif but nothing else.
However bitmaps are huge, maybe a later access version handles jpg's, a
definate upgrade for MS to include, I have 2000.
I just made the bitmaps small so it reduced the file size and it worked
well.
I also found if you left the pics in 24bit colour they printed better
on a B&W laser than if you converted them to shades of grey before
added the file to the database, just let the printer do the
converting.

Gravey
 
Yes I would like to know as well, I have found it shows in both forms
and reports if the picture type is a bitmap or tif but nothing else.
However bitmaps are huge, maybe a later access version handles jpg's, a
definate upgrade for MS to include, I have 2000.
I just made the bitmaps small so it reduced the file size and it worked
well.
I also found if you left the pics in 24bit colour they printed better
on a B&W laser than if you converted them to shades of grey before
added the file to the database, just let the printer do the
converting.

Gravey
 
In the article that downloads with my examples, I mention that for all but a
few of the most common (e.g., bitmap, TIFF) file types, you must have the
graphics filters installed. Those come with the Professional (or higher)
Editions of Offce, or with standalone Microsoft Word, but not with
standalone Access. You are not licensed to distribute them with the runtime
support, either...

If you have users who do not have the appropriate software, you'll need to
find a third-party image control. I've heard good reports on ImageN from
Pegasus Software (and, if memory serves, they have some other products that
might work, too). I haven't seen a discussion of their products recently,
and a quick visit to their site, http://www.pegasustools.com, doesn't show
ImageN in the list of products anymore. There was another nice one that I
used in Access 2.0 from another vendor, which was dropped not long after
32-bit Access included image viewing controls. Fortunately, I still have my
copies of both controls, just in case I should need them...

Larry Linson
Microsoft Access MVP
 
Back
Top