OLE

[Haytham]

Hi All...
In my main form, I created a OLE field type to place the photo of my employees.
When I double click the Ole, nothing will happen. I have to right click and go to insert into then a list of: Open with will open to me so I can choose Photo Editor or any other ...
My point is to put a command button so when pressed it will open Photo editor so I can choose browse....
Any help is highly appreciated.

 

[Surjer]

I have something like that only mine are sketches to GPS Points located within a certain state!

I just pulled that open with a Click

eventrivate Sub Sketch__BMP__Click()
DoCmd.RunCommand acCmdInsertObject
End Sub


This might help but your probably looking for something a little more intence...

 

[Haytham]

Hi Surjer,
Thanks for your reply.
Well, I tried to put the code On Click of the button

Private Sub Sketch__BMP__Click()
DoCmd.RunCommand acCmdInsertObject
End Sub

It's giving me an error, InsertObject in not available now.
I don't know why
Any more suggestions please.
Thanks