Word in access form (Access 2000 or greater)

Topic

New Reply

I did this some years ago and have forgotten how to.

I would like to have aa form based on a table which contsins the paths to winword docs. When I change the record I want to display the selected file in an embedded copy of winword on a form for the user to edit it.
What object do I need on the form and how do I get it to update the contents based on the path selected.

Reply | Quote

Replies

You can put an unbound object frame on the form, and link it to a Word document. You could then change its SourceDoc property in the On Current event of the form.

But you’ll only see the first page of the Word document; you can’t scroll through it. If you enable the frame, the user can double click it to open Word. I don’t think that is what you intend.

Reply | Quote

Thanks Hans.
Thats what I tried without success. When I changed the record it didn’t update the doc. Do I need to force some event in the object?

Reply | Quote

You must recreate the link:

Me.OLEUnbound0.SourceDoc = Me.PathField
Me.OLEUnbound0.Action = acOLECreateLink

where OLEUnbound0 is the name of the OLE control, and PathField is the name of the text field containing the path+filename. The OLE control must be unlocked and enabled for this to work.

Updating is very slow, though. You might be better off providing a hyperlink to the documents, so that the user can decide to open a document or not.

Reply | Quote

Runtime error 2793

I have the code in the Form_Current event (and no other code at all)

Reply | Quote

Have you set Enabled to Yes and Locked to No for the OLE control? And did you set the OLE Type to Linked when you created the control? Otherwise, you’ll get runtime error 2793.

Reply | Quote

A thousand thanks.

(I feel a right idiot for not spotting that)

Reply | Quote

Why do you think I could reply so quickly? I made the same mistake initially

Reply | Quote

Why do you think I could reply so quickly? I made the same mistake initially

Reply | Quote

A thousand thanks.

(I feel a right idiot for not spotting that)

Reply | Quote

Have you set Enabled to Yes and Locked to No for the OLE control? And did you set the OLE Type to Linked when you created the control? Otherwise, you’ll get runtime error 2793.

Reply | Quote

Runtime error 2793

I have the code in the Form_Current event (and no other code at all)

Reply | Quote

You must recreate the link:

Me.OLEUnbound0.SourceDoc = Me.PathField
Me.OLEUnbound0.Action = acOLECreateLink

where OLEUnbound0 is the name of the OLE control, and PathField is the name of the text field containing the path+filename. The OLE control must be unlocked and enabled for this to work.

Updating is very slow, though. You might be better off providing a hyperlink to the documents, so that the user can decide to open a document or not.

Reply | Quote

Thanks Hans.
Thats what I tried without success. When I changed the record it didn’t update the doc. Do I need to force some event in the object?

Reply | Quote

You can put an unbound object frame on the form, and link it to a Word document. You could then change its SourceDoc property in the On Current event of the form.

But you’ll only see the first page of the Word document; you can’t scroll through it. If you enable the frame, the user can double click it to open Word. I don’t think that is what you intend.

Reply | Quote

If you can make your Word docs RTF files then you can do exactly what you want using the Rich Text Control.

The updating is instantious if you do it this way, and you can scroll.

Reply | Quote

Thats a good idea, I’ll bear it in mind.

Reply | Quote

Thats a good idea, I’ll bear it in mind.

Reply | Quote

If you can make your Word docs RTF files then you can do exactly what you want using the Rich Text Control.

The updating is instantious if you do it this way, and you can scroll.

Reply | Quote