I have a database (Access97)in which the table "T_EXERCISES" includes a OLE object Field (OLE_VIEW). I store Word Docs (embedded) in that field. After i put search criteria on a form there is a query which takes the results. All I want to do is export the docs from the query to Word.
I've tried with Publish, Merge but I get null. I think that the problem is that I can't pass through the content of the object (the formated text of the Word docs) so I could simply Copy-Paste it.
What is wrong with the code below?
Why it isn't working?

Dim objWord As Word.Application
Dim objDoc As Object
Dim rCust As Recordset
Dim dbase As Database

Set dbase = CurrentDb()
Set rCust = dbase.OpenRecordset("q_SearchList")

Set objWord = New Word.Application
objWord.Visible = True
Set objDoc = objWord.Documents.Add

objWord.Selection.Text = rCust("OLE_VIEW")
rCust.MoveNext
....


GregoryHu

Hi GregoryHu,

Thanks for your personal message.

Unfortunately, Word automation is not really my cup of tea, so I am afraid I can't help you.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Data stored in an Access database is not appropriate for pasting into a host application. You can instead open the host from within Access and copy and paste from there. I've attached a link about OLE and graphics but the principles apply to OLE servers.

http://www.ammara.com/articles/imagesaccess.html

You may want to reconsider your design if you objective is to concatenate the data in several fields into a formatted Word document. It may be much easier to use rich text in Access and then copy the recordset fields into one or more Word docs.



Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]

It depends on how the data is stored in the table. If saved carefully in its raw format it appears as 'Long binary data' and can be extracted and saved to disk then opened in the correct application. If it appears as 'Microosft Word Document' then Access has added extra information and I don't think it can be easily opened directly as a document. If you need more help about the first scenario let me know.



--

Joe

Gregory

Tour basic problem is that you're storing a whole Word document in an OLE field, in it's own proprietory binary format, and then trying to treat it as a piece of text. It just isn't going to work.

What you need to do is create a temporary Word document from the contents of the OLE field and then open that temp file in Word. I may have the code to do this on my work machine - I'll try and dig it out tommorrow.


Brian Skelton
Braxis Computer Services Ltd.

I've got a problem like this one...
I transfer data (with ole type column) from access to SqlServer with DTS.
When i extract a document from SqlServer, I can't open it !!!
Help !!!