Add Photos into DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a small database that I am using for scouting. I would like to have
..jpg images of my subjects (robots) show up on my final scouting report.
There are not a lot of images, so I want to directly put them in the
database. I have created an OLE field. In the table, they show up as
"Package". When I add the field to my report, a square comes up (the size of
the photo) and the name of the photo (robotname.jpg) shows up in the square.
How do I get the photo to actually display on the report?

I am using Access 2002.
Thanks.
 
You are probably going to hear from programmers that you are committing a
design mistake, but I use Access 2002 and do exactly what you are trying to
do. Although I use the link feature in the wizard to add the picture to the
form/table, I drop the ole control into the report and the pictures show up
in the report. They need to be resized for a good print, but it works fine. I
also use a query for my reports, but I tried adding the ole directly from the
table and it still works OK.

I haven't seen the word "Package" in the ole row, so I don't know what that
means. In my tables it shows "Microsoft Photo Editor 3.0 Photo", which came
with my software package. I assume that "Package" may be the photo editor on
your computer.

Are the pictures in the same table from which your report data is taken
from, or are they in a separate table? If in a separate table, then you'll
need to link them to your 'scouts' table.

If you do a search for your question in the "Search for:" dialog box, you
may find another way to fix your problem.
 
"data cruncher" wrote
I have a small database that I am using for scouting.
I would like to have .jpg images of my subjects
(robots) show up on my final scouting report.
There are not a lot of images, so I want to directly
put them in the database. I have created an OLE
field. In the table, they show up as "Package".
When I add the field to my report, a square
comes up (the size of the photo) and the name
of the photo (robotname.jpg) shows up in the square.
How do I get the photo to actually display on the report?
Click to expand...

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects. When you use OLE
Objects, you are "at the mercy" of whatever software is registered to be
used for the file type. You need to also check the Properties of the Bound
OLE Frame you are using to display the picture.

If 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
 
Back
Top