Display .bmp of each record

[Emanuel Violante]

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

 

[Rick B]

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

 

[Emanuel Violante]

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: