photo in fo

Friend I have select Filed as OLE object to add passport
size photo,I found only when I select photo with extaion BMP it work
and with JPG not I am right.my photo size about hight 3cm  whith 2.5
i want if some photo begger is make auto size with my field size

thx

miziriAsked:
Who is Participating?
 
jjafferrCommented:
It is NOT advised to have the images embeded, it will make your mdb grow big in size and might get corrupted too.

http://www.thenelson.name/
have 2 examples,
1 for embeded, and the other for linked,
we all recommend linking your photos to the mdb.

jaffer
0
 
jjafferrCommented:
Hi miziri,

Access can read the following formats:
"(*.JPG,*.JPEG,*.JPE,*.GIF,*.BMP,*.DIB,*.TIF,*.TIFF,*.PNG,*.PCX,*.PCD,*.ICO,*.WMF,*.EMF,*.EPS,*.fpx)"

On the menu bar, use the icon with the tag IMAGE, don't use Bound or Unbound Object.

jaffer
0
 
miziriAuthor Commented:
HI
Can plz tell in short differnt in bound and unhound object.
also how can i control side as u know t will differnt size but i want alwasy photo size 3cm*2.5cm
passport size

thx
thx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jjafferrCommented:
for the size,
right click on the image control,
in the properties,
look for "Size Mode", set it to:
Zoom, which means, any picture you load will be displayed with the correct aspect ratio,
Strech, which means, the picture will fill the image control, but will not repect the aspect ratio,
Clip, means, the picture will be shown in it's original size, but since it might be big, you can see only the part which can be displayed in the image control.
0
 
miziriAuthor Commented:
Hi,
Friend with Image it will load one photo for all new recode ,in my case when i pres new recod
i will add new photo for ever new recode ,image it always have same photo.
i am right.


thx
0
 
jjafferrCommented:
assuming your photos are saved with the RecordID number, like this
123.jpg
356.jpg

and assuming your image control on the Form is called Image1,
"On Current" of the Form you can use this code:
MyPath="C:\Temp\"
me.Image1.picture= MyPath & me.RecordID

this will make each Record show its picture.

jaffer
0
 
jjafferrCommented:
or if you have the picture name and path are already in the Table, called PicturePath, then

"On Current" of the Form, have this:

me.Image1.picture=PicturePath
0
 
miziriAuthor Commented:
Friend
On Current" of the Form you can use this code:
MyPath="C:\Temp\"
me.Image1.picture= MyPath & me.RecordID

this will make each Record show its picture.

can make sure abou the plz
what is me.recoded is also like folder
===
0
 
jjafferrCommented:
Question:
How does Access know what is the name of the picture (and it's path) it is suppose to place in the Form?
Do you have a field in the Table which has this info? what is the name of this field?

jaffer
0
 
miziriAuthor Commented:
Hi,
Friend , let make more clear
I have create in c:  foler name Photo
and in table which name is table1 filed call image1 with type of filed is  OLE OBJECT
so with any new recode I will add new photo,my data base like personal info it must contain photo of person,,,, I hope I am clear to

thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.