Read Write an OLE object to Access 97
Posted on 1998-08-04
i have an Access 97 table with an OLE object (a word 97 doc) in one of the fields. I want to read that field into an OLE object on my form. I know how to do it using a data control but I dont want to use data controls.
how do i set my ole object (OLEWord) to display the data in my recordset and how do i write it back
after I have made changes to it?
set RS = dbtemp.openrecordset("mydatabase", dbOpenDynaset)
OLEWord= ???? rs.fields("Myfieldname")
rs.fields("Myfieldname") = OLEWord
i know this last part is wrong, but that the idea of what i need to do.