How do I make a button open an image in access?

[dannyf]

I have an access database that I need to open scanned jpegs from. I don't care if it opens "in" access or if it just invokes the native application for that file type. I need the button to look at the "Circuit ID" field in the form, locate a matching file name in a specified directory and open the file. Can anyone tell me how to do this?

[MMcCarthy]

I have an access database that I need to open scanned jpegs from. I don't care if it opens "in" access or if it just invokes the native application for that file type. I need the button to look at the "Circuit ID" field in the form, locate a matching file name in a specified directory and open the file. Can anyone tell me how to do this?

You need to look at creating an OLE Object datatype field.

Mary

[robertoathome]

You need to look at creating an OLE Object datatype field.

Mary

Can the answer include beginners please? I've been reading/using about using OLE ( and it only works with bitmaps) but it bloats large databases.

I've been trying to learn how to create a button that runs a macro to open a pic ( from ono of the column of a table ) in a picture box but my brain is about to fry.

Any help?

Thanks.

[MMcCarthy]

Can the answer include beginners please? I've been reading/using about using OLE ( and it only works with bitmaps) but it bloats large databases.

I've been trying to learn how to create a button that runs a macro to open a pic ( from ono of the column of a table ) in a picture box but my brain is about to fry.

Any help?

Thanks.

OLE objects can work with any type of image including jpeg's. Linking rather than embedding the images wouldn't bloat the database as much.

To link images directly into an image window at runtime would be a very heavy load on the database. I'm not aware of an ActiveX object for viewing images in Access but I'm sure there is one. Maybe someone else can help further.

Mary