Best way to add a .JPG image using a Form?

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi,

I am designing a db and I want to store .jpg images in it and have the
image displayed in the Form and printed on the Report. Using Access
2000.

I checked out Northwind Employees form and see that the images there
are .BMP

Can someone advise me the best way to set things up? because when I
copy in my .jpg file, only the file name is displayed in the form's
OLE field (and not the image itself) !!!

Northwind's Employee table field is an OLE Object. On my form, when
the Form is opened, I select the Field and then go Insert - what
should I select from here onwards?

I need to enter about 4000 .jpg images

Thank you very much for any advice.
 
You will find a lot of information on this here.
http://www.mvps.org/access/forms/frm0030.htm
http://www.mvps.org/access/forms/frm0044.htm
http://www.granite.ab.ca/access/imagehandling.htm
Click to expand...

thanks for that!

Decided on using the image address in a text field (to avoid bloating
the db). If my form is setup as 'Single Form' each record has its own
image displayed correctly. If I set the form up as Continuous, each
record has the image of the currently selected record - probably
because the image control is not bound to the record. I use in the
OnCurrent event

Me![imgTheImage].Picture = Me![txtImagePathAndFile]

HOW do I set things up so the FORM is continous and each image is the
right one for the record??
 
You are correct about the reason for this happening. I don't know how to fix
it. If anyone one has an answer, it would probably be Stephen Lebans. His
web site is www.lebans.com. Also, here are 3 links on his site that may
help.

http://www.lebans.com/loadsavejpeg.htm
http://www.lebans.com/loadjpeggif.htm
http://www.lebans.com/image_faq.htm

--
Wayne Morgan
MS Access MVP


Rob said:
You will find a lot of information on this here.

http://www.mvps.org/access/forms/frm0030.htm
http://www.mvps.org/access/forms/frm0044.htm
http://www.granite.ab.ca/access/imagehandling.htm
Click to expand...

thanks for that!

Decided on using the image address in a text field (to avoid bloating
the db). If my form is setup as 'Single Form' each record has its own
image displayed correctly. If I set the form up as Continuous, each
record has the image of the currently selected record - probably
because the image control is not bound to the record. I use in the
OnCurrent event

Me![imgTheImage].Picture = Me![txtImagePathAndFile]

HOW do I set things up so the FORM is continous and each image is the
right one for the record??
Click to expand...
 
There's a simple answer...it cannot be done!<grin>
For forms in Continuous view the only way to have individual images per
row is to use an OLE Frame control bound to an OLE field containing the
images.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Wayne Morgan said:
You are correct about the reason for this happening. I don't know how to fix
it. If anyone one has an answer, it would probably be Stephen Lebans. His
web site is www.lebans.com. Also, here are 3 links on his site that may
help.

http://www.lebans.com/loadsavejpeg.htm
http://www.lebans.com/loadjpeggif.htm
http://www.lebans.com/image_faq.htm

--
Wayne Morgan
MS Access MVP


Rob said:
You will find a lot of information on this here.

http://www.mvps.org/access/forms/frm0030.htm
http://www.mvps.org/access/forms/frm0044.htm
http://www.granite.ab.ca/access/imagehandling.htm
Click to expand...

thanks for that!

Decided on using the image address in a text field (to avoid bloating
the db). If my form is setup as 'Single Form' each record has its own
image displayed correctly. If I set the form up as Continuous, each
record has the image of the currently selected record - probably
because the image control is not bound to the record. I use in the
OnCurrent event

Me![imgTheImage].Picture = Me![txtImagePathAndFile]

HOW do I set things up so the FORM is continous and each image is the
right one for the record??
Click to expand...
Click to expand...
 
Back
Top