If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Best way to add a .JPG image using a Form?
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 -- Wayne Morgan Microsoft Access MVP "Rob" wrote in message ... 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. |
#2
|
|||
|
|||
Best way to add a .JPG image using a Form?
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 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?? |
#3
|
|||
|
|||
Best way to add a .JPG image using a Form?
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" wrote in message ... 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 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?? |
#4
|
|||
|
|||
Best way to add a .JPG image using a Form?
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" wrote in message ... 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" wrote in message ... 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 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?? |
Thread Tools | |
Display Modes | |
|
|