edit a word document

[samotek]

Is it possible to open the word document called Notes in My Documents from within Access, write some notes and then save it.Then to open this same document from another place in Access, say another form, write further notes and then save agan.I didnt hear something of the kind up to now and i am curious about the opinion of the professionals

 

[PHV]

It is very possible with OLE Automation.
Have a look at the CreateObject and GetObject functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[KenReay]

Hi

Yes

There are (at least)two ways to do it:

Use Shell to open word, from within Access

Use GetObject() and/or CreateObject(), in VBA code to open an instance of word from within Access, you can then control this instance of word from Access

See help on Shell, GetObject(), CreateObject()

As an aside, why not use a Memo column in an Access table to keep your notes?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK