By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,558 Members | 1,533 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,558 IT Pros & Developers. It's quick & easy.

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

P: 1
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?
Mar 10 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Mar 10 '07 #2

P: 20
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.
Mar 29 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Apr 1 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.