p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   OLE object in table and Form control (http://p2p.wrox.com/showthread.php?t=6477)

bleitner November 21st, 2003 04:35 AM

OLE object in table and Form control
 
I'm new to Access and have set up a table that includes a field for a picture as an OLE object. In the form I would like to use a Browse button that opens the standard windows File Open dialog to find the picture and then have it displayed on the Form as well as store the picture in the table - not just the path to it. Is this possible with Access, and if so, can someone direct me to where I might find information on how to do it? I tried searching the Microsoft site but didn't find anything.

Thanx much-

Bob


sal November 21st, 2003 12:20 PM

just create the field as ole object. When you create a form, you can right click (or doubleclick I think) on the field where you want to store the object and the File dialog will automatically open for you. It is simple and easy to do.



Sal

bleitner November 21st, 2003 01:05 PM

Thank you - I got that far but double clicking doesn't work and if you right-click and select insert object, it brings up the "Create New/Insert Existing Object" dialog. This seems very cumbersome, especially for a user. For sake of user-friendlyness, is there a way to create a button to launch the File Open dialog so they can just search for the picture. It would be nice to have it restrict to a file type too - like jpeg.


sal November 21st, 2003 01:24 PM

You can use the file dialog in Access, but, it will not always work on all user machines depending on the version of Access and even SR level of Access. You can only get around that by using MOD, and that is a headache in itself.

Train your users on how to use the one supplied with Access, or create your own Active X control to do that (even harder).

Users, we kno them, we love them.



Sal


All times are GMT -4. The time now is 07:42 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.