Hi everyone,

I have a database with lots of products, and i would like to have a form for
each product with the correspondent picture.

each product as a unique ID and the .bmp file has the same name.

For example:

Product code: 123456
and in my picture folder the picture is called: 123456.bmp

Is that possible that everytime a open a record to look in the pictures
folder for the picture with the same code, and view the picture on the form?

Sorry for my english, but I'm Portuguese =D


--
Thanks,

Emanuel Violante Galeano

I believe the following links will help you...

www.rogersaccesslibrary.com has two small sample databases: "Pictures.mdb"
and
"PicturesLoad.mdb" which illustrate how to handle pictures



Another link related to pictures:

http://www.granite.ab.ca/access/imagehandling.htm


--
Rick B



"Emanuel Violante" <(E-Mail Removed)> wrote in
message news:FD8BA13B-12F3-4E1E-878F-(E-Mail Removed)...
> Hi everyone,
>
> I have a database with lots of products, and i would like to have a form
> for
> each product with the correspondent picture.
>
> each product as a unique ID and the .bmp file has the same name.
>
> For example:
>
> Product code: 123456
> and in my picture folder the picture is called: 123456.bmp
>
> Is that possible that everytime a open a record to look in the pictures
> folder for the picture with the same code, and view the picture on the
> form?
>
> Sorry for my english, but I'm Portuguese =D
>
>
> --
> Thanks,
>
> Emanuel Violante Galeano

Hi Rick,

Tks for your post, in fact the first database is very close to what i need
but could you give me a little help, to achieve my needs?

For example i have in my table a ID field withe the value 123456
Is that possible to automatically assign to the photo field 123456.bmp?????

Something like:

Photo = "ID".bmp



Thanks,

Emanuel Violante Galeano


"Rick B" escreveu:

> I believe the following links will help you...
>
> www.rogersaccesslibrary.com has two small sample databases: "Pictures.mdb"
> and
> "PicturesLoad.mdb" which illustrate how to handle pictures
>
>
>
> Another link related to pictures:
>
> http://www.granite.ab.ca/access/imagehandling.htm
>
>
> --
> Rick B