A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2004, 03:49 PM
Wayne Morgan
external usenet poster
 
Posts: n/a
Default 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  
Old May 26th, 2004, 02:15 AM
Rob
external usenet poster
 
Posts: n/a
Default 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  
Old May 26th, 2004, 02:33 AM
Wayne Morgan
external usenet poster
 
Posts: n/a
Default 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  
Old May 26th, 2004, 03:00 AM
Stephen Lebans
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.