Create/Emded OLE in record

J

Jarryd

Hi,

I want to create a button that creates a Word document in a field in the
current record. I can't seem to find the syntax. I found things like
acOLECreateEmbed, but not a whole solution. What I was imagining is that
you would
a.)define the type of object and create it:
Dim Notes As Object
Set Notes = CreateObject("Word.Application")

b.)maybe give it a name:
"NO IDEA."

c.)and this is what I really stuck on - putting it in a designated field in
the current record
"DEFINATLEY NO IDEA!!"

d.)open the object:
"AGAIN, NOT TOO SURE."

After that I was going to enable access to the object via the same button.
If an object hasn't been created then it does the above, otherwise it just
opens it - problem d.) above.

Anyone have any ideas?

TIA,

Jarryd.
 
Top