OLE objects

[ccrites]

I'm a new user of OLE objects in Access 2000. Thus, I need some help.
What I'm trying to do is open MS Word and paste a "message" out of a
text box into a temporary document. This is a fairly easy problem, but
my help has been subpar as of yet. Any help would be appreciated.
Thanks in Advance...


-Casey

 

[Guest]

First, Create the Field with the OLE Data type, then when you decide to use
the field in either a form or in the datasheet view, you will right-click in
the field space and select to insert the object. From the list of choices in
the dialog window, you may either use an existing document or create a new
one (the types will be listed). You can just choose the notepad or wordpad
option usually at the bottom of the list. This will open the software where
you can then paste the data and simply close the app. The information is now
stored in your access database.
Hope this helps.