Insert and show a photo

[Ixak]

Hello
How could I insert a photo on the database and show it in a form?
I have created an OLE object and try to insert a photo but I don´t success
showing the picture in the form, I can only open it clicking twice and see
the image but not surfing form one record to another.
Thanks for all

 

[Erez Mor]

hello
first, you should be aware that saving the actual picture inside an access
table is memory consuming to such an extent it should be dome only if you
really dont like other choices, like storing the pictures in a dedicated
folder and then using a text field in the table (instead of the ole/blob or
whatever), keeping only the path to those pictures, and not the pictures
themselves in the DB
then, what you should do is use an un-bound picturebox on your form, and in
the Current event of the form set the Picture property of the picturebox to
the current picture's path

hope that made enough sense
good luck
Erez

 

[gute1]

thanks for the detailed help,

I am using this method, of holding the picture name in a string field.
I want to use it in a continuous form. should I use a bound control?
is there other control to use? is there any way at all to do it or should I
have to use single form only?

Oded