Can I place an MS Word .doc document into an access 2003 form?

[Patentinv]

Hi,
Can I place an MS Word .doc document into an access 2003 form?

If so please explain how?

Thanks--I appreciate all help.

 

[HandsOnAccess]

Yes, You can place MS Word.doc document in an Access 2003 Form
The easiest and the simplest way to do this is by using "Unbound Object Frame" control which is available in Toolsbox (Next to Image Control).

When you place the "Unbound Object Frame" on a Access Form,
An "Insert Object" Dialog box appears,
Here you will find a list of Object that can be placed on a Access Form. For example -

Bitmap Image
Media Clip
Microsoft Clip Gallery
Microsoft Excel Chart
Microsoft Excel Worksheet
....
...
..
.

Scroll down until you find Microsoft Word Document
Select Microsoft Word Document
Here you will have 2 Options - Create New, Create From File
Choose appropriate Option.
Microsoft Word Document will be created and placed on your Form.

Hope this helps you...
Regards,

 

[Patentinv]

Hi HandsOnAccess,

I did as you said except when getting out of design view and going to normal view, I recieve and error saying
(A problem occured while MS Access was communicating with the OLE server or ActiveX Control)
Close the OLE Server and restart it out side of Access, And retry operation again.

I have no idea what all this means, OLE server? Do you have any suggestions

Thanks--Any help will be greatly appreciated.

 

[HandsOnAccess]

There are several reason for the above error, most probably either your DLL's or Access Form is corrupt.

IMPORTANT - MAKE SURE YOU SAVE A BACKUP-COPY OF THE DATABASE BEFORE TRYING THESE.
Option-1
Try it on a different computer and see if you get the same error (Make sure you have same version of Access on the other computer too).

Option-2
The cause may also due to a syntax error in the code.
Compile the Code using Debug menu of the VBA window.

Option-3
Open the form, select and copy all the objects using CTRL-A, CTRL-C and then open a new form and paste them using CTRL-V, copy all the code as well, Try new form.

Option-4
Make sure that correct DLL is being referenced under Tools, References menu of the VBA window.

Option-5
Create a new database and import the form.
Then imported the form from the new database into the original database and remove the old form.

Hope these Option help you fix your error

Regards

 

[Patentinv]

HandsOnAccess,

I did get it to work on 2 other computers, but for some reason I can't get it to work on my main computer or my laptop.
They both give the same error
(A problem occured while MS Access was communicating with the OLE server or ActiveX Control)
Close the OLE Server and restart it out side of Access, And retry operation again.



Thanks--HandsOnAccess

 

[PHV]

Have you tried to launch word before access ?

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

 

[Patentinv]

Hi PHV,
Yes I just tried it, and it gives the same error.

(A problem occured while MS Access was communicating with the OLE server or ActiveX Control)
Close the OLE Server and restart it out side of Access, And retry operation again. Reinstall OLE to make sure it is registered.


It says to reinstall OLE to make sure it is registered. I wonder if this means to reinstall office?

Thanks--for your help.

 

[Patentinv]

I figured out what was causing this error,I had Norton script blocking enabled, Once I disabled this every thing was fine.

Thanks HandsOnAccess and PHV for all your help, I appreciate it.

 

[PHV]

You may try to repair your office install.

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