Inserting a picture(OLE object) via command button

[FIT]

Hello folks,



I'm new in Access and I could use some help. I have a table with an OLE object and some other information. I've created a form for inserting information in that table and I want to add a button to insert pictures from local hard drive.In other word I'm trying to make a button that will open a browse window.

Thank you in advance.

[RuralGuy]

This is what I use all of the time for that: http://www.mvps.org/access/api/api0001.htm

[FIT]

This is what I use all of the time for that: http://www.mvps.org/access/api/api0001.htm

Every body has been pointing me to this code but i do not understand it!

Can you simplify it?

Thx...

[RuralGuy]

You need to create a new Standard Module and copy all of the code into that module and then compile it. Name the Module basAPI.

[FIT]

THX

I can now open a browsing window. But now how do i save the image in the table?

[RuralGuy]

It is my experience that you will be better off just saving the link and leave the actual picture outside of the db to save the bloat they cause. http://accdevel.tripod.com/imaging.htm

[ZMAN]

Create a macro. Select the RunCommand option and select Insert Object. in the properties window of the control enter the macro name in the On Click event.