attaching photos as data in a form

[xena_morph]

HI

im doing an estate agency database as a project and as well as having to add info on a property i have to add photos.

how exactly would i do this i know i could do it as a link pointer to a CD but how would someone using the database do this when first entering the data

please help!!!

 

[JCross]

I would create a field in your table with an OLE datatype and then embed the photos.

Jennifer

[This message has been edited by JCross (edited 03-12-2002).]

 

[xena_morph]

im ok with making the type an OLE object but will this method enable the user to add photos from a cd/harddrive as they go along???

if so how would i set this up on a form?

thanks

 

[JCross]

I have a database of images set up where the user enters a date and a description for the image, then clicks a button which takes them to a linked page with the date and description they just entered and a bound object frame. when the frame is empty, you can right click on it and choose 'insert object' which allows them to choose the object type and browse to it on their pc.

i can give you more infor tomorrow if you need it......it's quitting time!

Jennifer

 

[xena_morph]

yeah that would be great thankyou

 

[JCross]

Morning Xena - ok - about the pics. You're going to have to find a form that works for you.....I don't know what yours currently look like. But if you have a data entry form where you are adding infoo for a property, and you include a Bound Object Frame from your toolbar on it (bound to the OLE field that you made in your table) then your user can right click the empty frame and 'insert object'. Also - it looks better if you make the background color of the frame the same as the form....

Let me know what else you need to know.

Jennifer

 

[xena_morph]

hi

ive just gotten around to testing this out and although it allows me to add a picture it doesnt actually display it here or when ive searched and located a record witha photo, instead it has a link icon.

what am i missing in order for it to show an unstretched image

jill