Images in forms

[Guest]

I need to create linked bound images in my database, as I need a different
picture for each entry. Being relatively new to Access, I followed every
instruction in the help file - created a bound picture box from the toolbox
--> Insert --> Object --> the .bmp picture (from file). And the picture shows
up, and it's all lovely.

Then, when I save and close the form, and open it again, the picture
disappears! How can I get it to stay there?? Please help me.

 

[Guest]

If I were you, I would rather be looking for a solution on how to create
unbound images in a form, 'cause following the same help file, you will
surely notice that bound images take up much space as MS Access has to create
a DIB (device independent bitmap) for each image it holds in the database
file. While unbound images take u only the space needed for the file (ex.
jpg) and the path to the file (in the database) and it's relatively easy to
create such a mechanism using VBA. If you're interested, please reply.

 

[Guest]

Im faily new to access but i will try to help. You need to link each picture
into your table and not your form. Create a field in your table that is
connected to your form where you want the picture to be displayed. The
datatype needs to be OLE Object. Select the row on your table where you want
to link the picture and click on the new OLE Oblect field. In the INSERT menu
at the top of the window click object. I would then create a new bitmap
image. This will open paint, where you can paste the desired picture into.
once you have your picture in paint, select file and then click update table.

you will have to do this for each picture in each record.

Hope it helps.

 

[Guest]

If I were you, I would reather be looking for a solution on how to create
unbound images, as in the same help file it follows that bound images take up
more space, because MS Access needs to create a DIB for each image it stores
in the database. While unbound images are stored outside of the database - as
files - and take up only the space needed for the image file and it's path
stored in the database. Such a mechanism can easily be created using VBA and
I can show you how if you're interested.

 

[Guest]

Thanks Stujol; I tried linking each picture in the table just as you said,
but unfortunately the pictures still disappear! I just can't get them to stay
visible. Wadim Grasza, if I made unbound images, would the pictures would
remain static throughout the database? I need different individual pictures
linked to each separate database entry, like a picture of an employee next to
their name. If you can help me with this, I'd be very grateful. Thank you
both!


:
Im faily new to access but i will try to help. You need to link each picture
into your table and not your form. Create a field in your table that is
connected to your form where you want the picture to be displayed. The
datatype needs to be OLE Object. Select the row on your table where you want
to link the picture and click on the new OLE Oblect field. In the INSERT menu
at the top of the window click object. I would then create a new bitmap
image. This will open paint, where you can paste the desired picture into.
once you have your picture in paint, select file and then click update table.

you will have to do this for each picture in each record.

Hope it helps.

 

[Guest]

Are you familiar with VBA?

 

[Guest]

i would surgest looking at the northwind sample database via the help menu.
They have done the same as you want to. Study how they have done it and try
to apply it to your database.

 

[Guest]

Ah, wait, I got it working! It was to do with the table after all. Thanks,
guys, you've been a great help