Bind object to OLE Bound Frame

[Sanya Ibrahim]

Hi,
Is it possible to bind an oleBoundFrame object in a form to value in a
DAO.Recordset using vba?
Thanks
Sanya

 

[Alex Dybenko]

Hi,
you need to bind form to recordset (or underlying table), then you can bind
oleBoundFrame control on this form to corresponding field in recordset

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Sanya Ibrahim]

Hi
I got this interesting page
(http://accessblog.net/2006/04/how-to-open-document-in-ole-field.html) of
yours when I was trying to open a ole object saved in an Access table. But it
talks about Excel and a bound ole frame and I am not experienced in VBA. I
actually wanted to open an OLE object in a table in Access without an ole
bound frame. Say, I double click on an item in the list box, which will open
an OLE object in a recordset. Is there a way to do this?

Sanya.

 

[Alex Dybenko]

Hi,
well, I think you can, but could be more difficult then doing this in the
form. This post will give you an idea how to get access to table datasheet:
http://accessblog.net/2008/12/events-on-query-datasheet.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com