aaahhhrrggghhhh
Programmer
Hi.
I have an unbound object frame (y'know one of those OLE thingies), and a combo box. The combo box refers to a list of word documents, so the table behind it is :
Table OLE_Letters :
WordDocID Autonumber
LetterDescr Text
LetterObj OLE Object (the word document)
so the rowsource property reads :
select WordDocID, LetterDescr from OLE Letters
The user selects the LetterDescr from the list.
OK, so I need the code to take the "LetterObj" (Embedded Word Object - NOT linked), and display it in the Unbound Object Frame. How do I do this? Seems like it should be pretty easy as I am not (at this moment) doing anything else.
Oh, and I don't want to bind the Unbound Object frame as I want to allow the users to alter the document, but not retain any changes to it (this is already handled somewhere else).
I thought :
Me.MyUnboundObj.Object = DFirst("LetterObj", "OLE_Letters", " LetterID = " & me.cbMySelLetter)
might work, but object is not set! Please help me as I am on a tight schedule - this is to be presented soon.
Regards,
AAAARRRRRGGGGGHHHHHH. Dont be small. be BIG
I have an unbound object frame (y'know one of those OLE thingies), and a combo box. The combo box refers to a list of word documents, so the table behind it is :
Table OLE_Letters :
WordDocID Autonumber
LetterDescr Text
LetterObj OLE Object (the word document)
so the rowsource property reads :
select WordDocID, LetterDescr from OLE Letters
The user selects the LetterDescr from the list.
OK, so I need the code to take the "LetterObj" (Embedded Word Object - NOT linked), and display it in the Unbound Object Frame. How do I do this? Seems like it should be pretty easy as I am not (at this moment) doing anything else.
Oh, and I don't want to bind the Unbound Object frame as I want to allow the users to alter the document, but not retain any changes to it (this is already handled somewhere else).
I thought :
Me.MyUnboundObj.Object = DFirst("LetterObj", "OLE_Letters", " LetterID = " & me.cbMySelLetter)
might work, but object is not set! Please help me as I am on a tight schedule - this is to be presented soon.
Regards,
AAAARRRRRGGGGGHHHHHH. Dont be small. be BIG