Picture in image field in access 2003

[Dr Alok Modi MD]

I am devising a database for storing my OPD patients vital parameters. I have
given a image field which is an OLE field. But everytime I insert a picture,
either as a link or as an embedded picture from my hard disk, the box only
shows picture.jpg No picture is shown. Lets say my picture is stored in my
documents as "Alok Picture". When I insert it it comes as Alok Picture.jpg.
There is no other image processing program installed on my pC like photosdhop
etc, which can change the registry settings and I am running Win XP SP1 .

 

[JohnFol]

you need some sort of application that will display jpg's. For example
MSPaint is perfectly capable of displaying the image.

 

[Mark M]

If you store images in your database, you will soon find that it's size
grows quickly and out of control. Access is very inefficient when it stores
images. The better option would be to keep the images external and store
the full path to them in a text field. There are many articles and
discussions on this subject.

Basically, you have an unbound image control on your form/report and assign
the Picture property as you move from record to record, which will update
the image based on the path stored in your text field.

 

[Lynn Trapp]

Mark is correct. You need to only store the path to your image file. There
is an example of how to get the correct image to display in the Northwind
database. It is in the Employee form

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Dr Alok Modi MD]

Mark is correct. You need to only store the path to your image file. There
is an example of how to get the correct image to display in the Northwind
database. It is in the Employee form

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html





I saw the northwind datatabase. There as you rightly said the images are all stored in a saparate folder so the size of the database is not on the higher side. I can also store my images as a link rather than embed it. But my problem is that access does not recognise images stored in .jpg format. It only shows it in the form as "alok pictiure.jpg". The images stored in the northwind database are all in .bmp format, but surprisingly they are small in size, otherwise .bmp formats give huge picture sizes and JPEG is the industry standard format for storing images. oon the hard disk. Opening these images is also not a problem I can get aplications to open them, but I would like my images to be seen on my forms when my form is open and not as a sentence as "alok picture.jpg"

Could you guide me please ?

And thanks for your time.

Dr Alok Modi MD

 

[Mark M]

I'm not sure if it will help or not, but you could try running your Office
installation in Custom mode and add (reinstall) just the graphics filters
and anything else that looks like it has to do with pictures.

 

[Lynn Trapp]

You might take a look at this website:

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

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Dr Alok Modi MD]

You might take a look at this website:

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

Hi Lynn

I downloaded 2 zip files as you recommended on the link. GDIplusDLL and
A2KLoadJpegGifVer33GDiPlus. In the dll file it says that I am not supposed to
replace the supplied dll file with the one in the system if my OS is Win XP.
So I have not changed the dll file. The second A2KLoadJpegGifVer33GDiPlus
folder has an access database which loads all jeg, png etc images nicely and
manipulates them well. So I coped the modules from there and pasted them in
my database , but again it does not work.
What am I supposed to do now?

Dr Alok Modi MD

 

[Mark M]

In the sample database that works, go into any of the modules and check the
references (Tools|References menu) and make sure your database has all the
same references enabled.