Photos on forms

  • Thread starter Thread starter Mike Busch
  • Start date Start date
M

Mike Busch

Is there anyway to insert Photos into forms, making all
records have different photos. OK let me state I'm
looking for a easy way, I don't know to much VB. Thanks
in advance.
 
Hi Mike

couple of questions - how many records are we talking about and how do you
know what picture matches what record?

Cheers
JulieD
 
When filling out a form we need to fill in personal
information and a Photo to appear on the form. I don't
know how many will at this time but has the potential to
raise into the 1000's. Thanks in advance.
 
Mike,

I wouldn't call this task easy for someone who has little VB skill.
(like myself) However, by following some advice in this group, and
picking up some methods in their recommendations, it can be done
because I did it.

Go to this site: http://accdevel.tripod.com

You'll find various approaches to accomplishing that task there. What
you want to remember is that you should store _only_ the file name and
it's path in your db, keeping the actual photos in their own
directory. Also, use .bmp files instead of .jpg files. Doing that
will avoid huge database bloat.

Russ
 
Russ said:
Mike,

I wouldn't call this task easy for someone who has little VB skill.
(like myself) However, by following some advice in this group, and
picking up some methods in their recommendations, it can be done
because I did it.

Go to this site: http://accdevel.tripod.com

You'll find various approaches to accomplishing that task there. What
you want to remember is that you should store _only_ the file name and
it's path in your db, keeping the actual photos in their own
directory. Also, use .bmp files instead of .jpg files. Doing that
will avoid huge database bloat.

Russ
Click to expand...

As long as you store only the path\file name in the database, it doesnt
matter what type of image you refer to, bmp, jpeg, tiff, whatever. The
image file is never 'in' your database, so it cannot cause 'bloat'

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
"Russ" wrote
. . . by following some advice in this group, and
picking up some methods in their recommen-
dations, it can be done because I did it.

Go to this site: http://accdevel.tripod.com
Click to expand...

Thanks for the vote of confidence, Russ. Actually, if you are storing the
images as OLE Objects, using BMP will not eliminate the bloat, because
Access and the COM-automation-enabled graphics program will still create a
bitmap thumbnail. It just won't be as _obvious_ because the original files
will be larger. If you aren't storing the images as OLE Objects, it isn't an
issue.

I'll add the following, in case the original poster needs to do some reports
with pictures:

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